Issue RMAN Duplicate

0

While doing RMAN  dupicate, I have not give log_file_name_convert and db_file_name_convert

Here are errors and solutions

RMAN-03002: failure of Duplicate Db command at 03/19/2018 01:14:29
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-00344: unable to re-create online log ‘/d01/oracle/UAT/data/log01a.dbf’
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

SQL> alter database rename file ‘/d01/oracle/UAT/data/log02a.dbf’ to ‘/d02/oracle/UATSB/data/log02a.dbf’;

alter database rename file ‘/d01/oracle/UAT/data/log02b.dbf’ to ‘/d02/oracle/UATSB/data/log02b.dbf’;

SQL> alter database rename file ‘/d01/oracle/UAT/data/log01a.dbf’ to ‘/d02/oracle/UATSB/data/log01a.dbf’;

alter database rename file ‘/d01/oracle/UAT/data/log01b.dbf’ to ‘/d02/oracle/UATSB/data/log01b.dbf’;

 

ALTER DATABASE OPEN resetlogs
ORA-00392: log 2 OF thread 1 IS being cleared, operation NOT allowed

ALTER DATABASE clear logfile GROUP 2;

ALTER DATABASE OPEN resetlogs;

http://www.dbaref.com/clone-oracle-database/makeacloneofyourdatabasewithrmanonthesameserverasthetargetdatabase-windows

http://www.onlinedbasupport.com/2013/08/25/ora-00392-after-duplicating-the-database/

 

 

Share.

About Author

Leave A Reply

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.