RMAN DUPLICATE FAILED WITH BELOW ERROR
=====================================
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 02:57:58 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12154: TNS:could not resolve the connect identifier specified
RMAN>
connected to recovery catalog database
RMAN>
connected to auxiliary database (not started)
Note: Comment ebstest_LOCAL paramater in tnsnames.ora file and try it again.
Solution:
oratest@ctsst $ diff tnsnames.ora tnsnames.ora_bkp
24c24
< #ebstest_LOCAL =
---
> ebstest_LOCAL =
46,57d45
< ebsoltp =
< (DESCRIPTION=
< (ADDRESS=(PROTOCOL=tcp)(HOST=ebsoltp.user.com)(PORT=1535))
< (CONNECT_DATA=
< (SID=ebsoltp)
< )
< )
< catalog=
< (DESCRIPTION =
< (ADDRESS_LIST =
< (ADDRESS = (COMMUNITY = TCP) (PROTOCOL=TCP) (Host =catalog.user.com) (Port = 1525)))
< (CONNECT_DATA = (SID = catalog)))
59d46
<
oratest@ctsst $
oratest@ctsst $ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 03:03:57 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/tim3Pa55@ebsoltp
connected to target database: EBSOLTP (DBID=2581404741)
RMAN> connect catalog catalog/catalog007@catalog
connected to recovery catalog database
RMAN> connect auxiliary /
connected to auxiliary database: EBSTEST (not mounted)
After doing above steps issue got resolved.Happy learning !!!!!!!!!!!!!!!
=====================================
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 02:57:58 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12154: TNS:could not resolve the connect identifier specified
RMAN>
connected to recovery catalog database
RMAN>
connected to auxiliary database (not started)
Note: Comment ebstest_LOCAL paramater in tnsnames.ora file and try it again.
Solution:
oratest@ctsst $ diff tnsnames.ora tnsnames.ora_bkp
24c24
< #ebstest_LOCAL =
---
> ebstest_LOCAL =
46,57d45
< ebsoltp =
< (DESCRIPTION=
< (ADDRESS=(PROTOCOL=tcp)(HOST=ebsoltp.user.com)(PORT=1535))
< (CONNECT_DATA=
< (SID=ebsoltp)
< )
< )
< catalog=
< (DESCRIPTION =
< (ADDRESS_LIST =
< (ADDRESS = (COMMUNITY = TCP) (PROTOCOL=TCP) (Host =catalog.user.com) (Port = 1525)))
< (CONNECT_DATA = (SID = catalog)))
59d46
<
oratest@ctsst $
oratest@ctsst $ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 03:03:57 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/tim3Pa55@ebsoltp
connected to target database: EBSOLTP (DBID=2581404741)
RMAN> connect catalog catalog/catalog007@catalog
connected to recovery catalog database
RMAN> connect auxiliary /
connected to auxiliary database: EBSTEST (not mounted)
After doing above steps issue got resolved.Happy learning !!!!!!!!!!!!!!!
Great and useful blog. Creating content regularly is very tough. Your points are motivated me to move on. That is a really neatly written article.
ReplyDeleteOracle Fusion HCM Technical Online Training
Hi,
ReplyDeleteThis is very useful article.Thanks for sharing such a nice article.
oracle fusion SCM online training
Very efficiently written information. It will be beneficial to anybody who utilizes it, including me. Keep up the good work. For sure i will check out more posts. This site seems to get a good amount of visitors. Legal Entity Identifier Number
ReplyDelete