Advertisement
Guest User

Untitled

a guest
May 24th, 2016
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.75 KB | None | 0 0
  1. RUN{
  2. DUPLICATE TARGET DATABASE TO UAT
  3. FROM ACTIVE DATABASE
  4. USING BACKUPSET
  5. SPFILE
  6. set control_files 'E:oracleproduct12.1.0oradataUATCONTROLFILEcf1.ctl','E:oracleproduct12.1.0oradataUATCONTROLFILEcf2.ctl','E:oracleproduct12.1.0oradataUATCONTROLFILEcf3.ctl'
  7. set db_recovery_file_dest 'L:ORACLEORADATAUAT'
  8. set db_create_file_dest 'E:oracleproduct12.1.0oradata'
  9. set log_archive_dest_1 'LOCATION=L:BACKUPUATRMAN_BACKUPS'
  10. set log_archive_dest_2 'LOCATION=L:ORACLEORADATAUATARCHIVELOG'
  11. set audit_file_dest 'E:oracleadminUATadump'
  12. set core_dump_dest 'E:oracleadminUATcdump'
  13. nofilenamecheck;
  14. }
  15.  
  16. Finished restore at 24-MAY-16
  17.  
  18. sql statement: alter system archive log current
  19. current log archived
  20.  
  21. contents of Memory Script:
  22. {
  23. restore clone force from service 'ENGSPH'
  24. archivelog from scn 2661373093;
  25. switch clone datafile all;
  26. }
  27. executing Memory Script
  28.  
  29. Starting restore at 24-MAY-16
  30. using channel ORA_AUX_DISK_1
  31.  
  32. channel ORA_AUX_DISK_1: starting archived log restore to default destination
  33. channel ORA_AUX_DISK_1: using network backup set from service ENGSPH
  34. channel ORA_AUX_DISK_1: restoring archived log
  35. archived log thread=1 sequence=5659
  36. Oracle instance started
  37.  
  38. Total System Global Area 2147483648 bytes
  39.  
  40. Fixed Size 3047720 bytes
  41. Variable Size 822087384 bytes
  42. Database Buffers 1308622848 bytes
  43. Redo Buffers 13725696 bytes
  44.  
  45. contents of Memory Script:
  46. {
  47. sql clone "alter system set db_name =
  48. ''UAT'' comment=
  49. ''Reset to original value by RMAN'' scope=spfile";
  50. sql clone "alter system reset db_unique_name scope=spfile";
  51. shutdown clone immediate;
  52. }
  53. executing Memory Script
  54.  
  55. sql statement: alter system set db_name = ''UAT'' comment= ''Reset to original
  56. value by RMAN'' scope=spfile
  57.  
  58. sql statement: alter system reset db_unique_name scope=spfile
  59.  
  60. Oracle instance shut down
  61. RMAN-00571: ===========================================================
  62. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  63. RMAN-00571: ===========================================================
  64. RMAN-03002: failure of Duplicate Db command at 05/24/2016 16:26:55
  65. RMAN-05501: aborting duplication of target database
  66. RMAN-03015: error occurred in stored script Memory Script
  67.  
  68. ORA-19845: error in backupArchivedLog while communicating with remote database s
  69. erver
  70. ORA-17628: Oracle error 19571 returned by remote Oracle server
  71. ORA-19571: RECID STAMP not found in control file
  72. ORA-19660: some files in the backup set could not be verified
  73. ORA-19662: archived log thread 1 sequence 5659 could not be verified
  74. ORA-19845: error in backupArchivedLog while communicating with remote database s
  75. erver
  76. ORA-17628: Oracle error 19571 returned by remote Oracle server
  77. ORA-19571: RECID STAMP not found in control file
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement