Recently We have done the RMAN clone DEV from PROD that time We are faced below Issue
Error:-
channel ch1: CommVault Systems for Oracle: Version 9.0.0(BUILD84)
executing command: SET until clause
Starting Duplicate Db at Dec 21 2012 10:36:11
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/21/2012 10:36:11
RMAN-05501: aborting duplication of target database
RMAN-05597: Database started with server parameter file and PFILE clause used in command
Recovery Manager completed
Cause:-
Database mounted with spfile
Solution :-
We have to stop the Database then use startup pfile=<LOcation of Pfile> mount then your problem will resolved
executing command: SET until clause
Starting Duplicate Db at Dec 21 2012 10:36:11
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/21/2012 10:36:11
RMAN-05501: aborting duplication of target database
RMAN-05597: Database started with server parameter file and PFILE clause used in command
Recovery Manager completed
Cause:-
Database mounted with spfile
Solution :-
We have to stop the Database then use startup pfile=<LOcation of Pfile> mount then your problem will resolved
Example:-
SQL> startup pfile=/oracle/product/db/tech_st/11.2.0/dba/initMUTH.ora mount
Then Provide dublicate database command
SQL> startup pfile=/oracle/product/db/tech_st/11.2.0/dba/initMUTH.ora mount
Then Provide dublicate database command
Comments are welcome!!!!!!!!!!
No comments:
Post a Comment