While performing clone action, You may get the below error whenever RMAN failed in between.
It is because of spfile of auxiliary database.
IF YOU FACE THE ERROR IN RMAN DUPLICATE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/26/2013 12:28:20
RMAN-05501: aborting duplication of target database
RMAN-05520: database name mismatch, auxiliary instance has PROD, command specified EKKDB
RMAN> exit
Rman leaves modified auxiliary spfile parameters if DUPLICATE fails [ID 1283344.1]
SOLUTION : Shut down database
Rename SPFILE
check DBNAME in PFILE
If, RAC then put # in front of spfile parameter
Bring up database in nomount state using PFILE
* create pfile from spfile
* replace or remove spfile;
* edit pfile and update db_name
* create spfile from pfile;
RAC DUPLICATE DEMO SCRIPT
Changes in Pfile
FOR DATAFILES
db_create_online_dest_1='+DATA'
log_archive_dest_1='location=+FRA'
FOR REDO LOGS
*.log_file_name_convert=(/prddb/d20/proddata/,+EKKDATA/redo/,/prddb/d21/proddata/,+EKKFRA/redo/)
export ORACLE_SID=TEST
rman TARGET sys/xxxxxx@PROD CATALOG rman/xxxxxx@rman
connect auxiliary /
No comments:
Post a Comment