Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Script:
- =======
- D:\oracle\product\12.1.0.2.0\dbhome>rman TARGET sys@EISA-SOURCE AUXILIARY / msglog=F:\BACKUP\eisb_duplicate_1.log
- run {
- DUPLICATE DATABASE TO EISB
- UNTIL SCN 15446103440
- SPFILE
- parameter_value_convert ('EISA','EISB')
- set db_file_name_convert='D:\ORACLE\ORADATA\EISA\','D:\ORACLE\ORADATA\EISB\'
- ,'D:\ORACLE\ORADATA\EISA\DATA\','D:\ORACLE\ORADATA\EISB\DATA\',
- 'D:\ORACLE\ORADATA\EISA\USER\','D:\ORACLE\ORADATA\EISB\USER\',
- 'D:\ORACLE\ORADATA\EISA\INDX\','D:\ORACLE\ORADATA\EISB\INDX\',
- 'D:\ORACLE\ORADATA\EISA\HIST\','D:\ORACLE\ORADATA\EISB\HIST\',
- 'D:\ORACLE\ORADATA\EISA\REPORT\','D:\ORACLE\ORADATA\EISB\REPORT\',
- 'D:\ORACLE\ORADATA\EISA\AUDIT\','D:\ORACLE\ORADATA\EISB\AUDIT\',
- 'F:\ORACLE\ORADATA\EISA\USERS\','D:\oracle\oradata\EISB\USERS\',
- 'F:\ORACLE\EISA\USERS\','D:\oracle\oradata\EISB\USERS\',
- 'F:\ORACLE\STATSPACK\','D:\oracle\oradata\EISB\USERS\'
- set log_file_name_convert='F:\ORACLE\ORADATA\EISA\','F:\ORACLE\ORADATA\EISB\'
- set db_name='EISB'
- set db_unique_name='eisb'
- set memory_max_target='3221225472'
- set memory_target='2147483648'
- set db_recovery_file_dest_size='21474836480'
- set sga_target='1409286144'
- set pga_aggregate_target='738197504'
- set shared_pool_size='822083584'
- BACKUP LOCATION '\\HOVBDBPRXY01\LAWRENCEBKUP$\'
- NOFILENAMECHECK;
- }
- error :
- channel ORA_AUX_DISK_1: piece handle=\\HOVBDBPRXY01\LAWRENCEBKUP$\EISA_HOT_PTV1974C_1_1 tag=TAG20200527T200922
- channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
- archived log file name=F:\ORACLE\EISB\ARCHIVELOG\2020_05_28\O1_MF_1_16380_HDZTLDHN_.ARC thread=1 sequence=16380
- Oracle instance started
- contents of Memory Script:
- ....
- sql statement: alter system set db_name = ''EISB'' comment= ''Reset to original value by RMAN'' scope=spfile
- sql statement: alter system reset db_unique_name scope=spfile
- Oracle instance shut down
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of Duplicate Db command at 05/28/2020 12:45:11
- RMAN-05501: aborting duplication of target database
- RMAN-03015: error occurred in stored script Memory Script
- ORA-00283: recovery session canceled due to errors
- RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile 'F:\ORACLE\EISB\ARCHIVELOG\2020_05_28\O1_MF_1_16380_HDZTLDHN_.ARC'
- ORA-00283: recovery session canceled due to errors
- ORA-19906: recovery target incarnation changed during recovery
- ------------------------------------------------------------------------------------------------------------
- INCARNATION
- == DUPLICATE
- RMAN> list incarnation;
- using target database control file instead of recovery catalog
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 1 EISA 1322653252 ORPHAN 1 03-NOV-11
- 2 2 EISA 1322653252 ORPHAN 994063 18-JAN-13
- 3 3 EISA 1322653252 CURRENT 14331907298 25-APR-19
- - on the duplicate the current on prod the 18 JAN
- == PROD
- RMAN> list incarnation;
- List of Database Incarnations
- DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
- ------- ------- -------- ---------------- --- ---------- ----------
- 1 1 EISA 1322653252 PARENT 1 03-nov-2011 05:39:09
- 2 2 EISA 1322653252 CURRENT 994063 18-jan-2013 16:23:36
Add Comment
Please, Sign In to add comment