BrokeDBA

Duplicate incarnation changed durring reco Error

May 28th, 2020
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.49 KB | None | 0 0
  1. Script:
  2. =======
  3. D:\oracle\product\12.1.0.2.0\dbhome>rman TARGET sys@EISA-SOURCE AUXILIARY / msglog=F:\BACKUP\eisb_duplicate_1.log
  4. run {
  5. DUPLICATE DATABASE TO EISB
  6. UNTIL SCN 15446103440
  7. SPFILE
  8. parameter_value_convert ('EISA','EISB')
  9. set db_file_name_convert='D:\ORACLE\ORADATA\EISA\','D:\ORACLE\ORADATA\EISB\'
  10. ,'D:\ORACLE\ORADATA\EISA\DATA\','D:\ORACLE\ORADATA\EISB\DATA\',
  11. 'D:\ORACLE\ORADATA\EISA\USER\','D:\ORACLE\ORADATA\EISB\USER\',
  12. 'D:\ORACLE\ORADATA\EISA\INDX\','D:\ORACLE\ORADATA\EISB\INDX\',
  13. 'D:\ORACLE\ORADATA\EISA\HIST\','D:\ORACLE\ORADATA\EISB\HIST\',
  14. 'D:\ORACLE\ORADATA\EISA\REPORT\','D:\ORACLE\ORADATA\EISB\REPORT\',
  15. 'D:\ORACLE\ORADATA\EISA\AUDIT\','D:\ORACLE\ORADATA\EISB\AUDIT\',
  16. 'F:\ORACLE\ORADATA\EISA\USERS\','D:\oracle\oradata\EISB\USERS\',
  17. 'F:\ORACLE\EISA\USERS\','D:\oracle\oradata\EISB\USERS\',
  18. 'F:\ORACLE\STATSPACK\','D:\oracle\oradata\EISB\USERS\'
  19. set log_file_name_convert='F:\ORACLE\ORADATA\EISA\','F:\ORACLE\ORADATA\EISB\'
  20. set db_name='EISB'
  21. set db_unique_name='eisb'
  22. set memory_max_target='3221225472'
  23. set memory_target='2147483648'
  24. set db_recovery_file_dest_size='21474836480'
  25. set sga_target='1409286144'
  26. set pga_aggregate_target='738197504'
  27. set shared_pool_size='822083584'
  28. BACKUP LOCATION '\\HOVBDBPRXY01\LAWRENCEBKUP$\'
  29. NOFILENAMECHECK;
  30. }
  31.  
  32. error :
  33. channel ORA_AUX_DISK_1: piece handle=\\HOVBDBPRXY01\LAWRENCEBKUP$\EISA_HOT_PTV1974C_1_1 tag=TAG20200527T200922
  34. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
  35. archived log file name=F:\ORACLE\EISB\ARCHIVELOG\2020_05_28\O1_MF_1_16380_HDZTLDHN_.ARC thread=1 sequence=16380
  36. Oracle instance started
  37. contents of Memory Script:
  38. ....
  39. sql statement: alter system set db_name = ''EISB'' comment= ''Reset to original value by RMAN'' scope=spfile
  40. sql statement: alter system reset db_unique_name scope=spfile
  41.  
  42. Oracle instance shut down
  43. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  44. RMAN-00571: ===========================================================
  45. RMAN-03002: failure of Duplicate Db command at 05/28/2020 12:45:11
  46. RMAN-05501: aborting duplication of target database
  47. RMAN-03015: error occurred in stored script Memory Script
  48. ORA-00283: recovery session canceled due to errors
  49. 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'
  50. ORA-00283: recovery session canceled due to errors
  51. ORA-19906: recovery target incarnation changed during recovery
  52.  
  53. ------------------------------------------------------------------------------------------------------------
  54. INCARNATION
  55.  
  56. == DUPLICATE
  57. RMAN> list incarnation;
  58. using target database control file instead of recovery catalog
  59. List of Database Incarnations
  60. DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
  61. ------- ------- -------- ---------------- --- ---------- ----------
  62. 1 1 EISA 1322653252 ORPHAN 1 03-NOV-11
  63. 2 2 EISA 1322653252 ORPHAN 994063 18-JAN-13
  64. 3 3 EISA 1322653252 CURRENT 14331907298 25-APR-19
  65.  
  66. - on the duplicate the current on prod the 18 JAN
  67.  
  68. == PROD
  69. RMAN> list incarnation;
  70. List of Database Incarnations
  71. DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
  72. ------- ------- -------- ---------------- --- ---------- ----------
  73. 1 1 EISA 1322653252 PARENT 1 03-nov-2011 05:39:09
  74. 2 2 EISA 1322653252 CURRENT 994063 18-jan-2013 16:23:36
Add Comment
Please, Sign In to add comment