Advertisement
ExaGridDba

12c backup pdb to copy, "corrupt", switch to copy, recover

Sep 3rd, 2013
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.85 KB | None | 0 0
  1. [oracle@waipio1 KILAUEA rman]$ rman target "'sysbackup/bkp.n1te@hilo as sysbackup'"
  2.  
  3. connected to target database: KILAUEA (DBID=2092683371)
  4.  
  5. RMAN> backup as copy database;
  6.  
  7. Starting backup at 03-SEP-13
  8. using target database control file instead of recovery catalog
  9. allocated channel: ORA_DISK_1
  10. channel ORA_DISK_1: SID=69 device type=DISK
  11. allocated channel: ORA_DISK_2
  12. channel ORA_DISK_2: SID=186 device type=DISK
  13. channel ORA_DISK_1: starting datafile copy
  14. input datafile file number=00046 name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/system.280.825114671
  15. channel ORA_DISK_2: starting datafile copy
  16. input datafile file number=00047 name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/sysaux.260.825200449
  17. output file name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/system.693.825201765 tag=TAG20130903T224244 RECID=7 STAMP=825201841
  18. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:53
  19. channel ORA_DISK_1: starting datafile copy
  20. input datafile file number=00050 name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/ts.263.824999673
  21. output file name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/sysaux.688.825201827 tag=TAG20130903T224244 RECID=8 STAMP=825201888
  22. channel ORA_DISK_2: datafile copy complete, elapsed time: 00:02:08
  23. channel ORA_DISK_2: starting datafile copy
  24. input datafile file number=00048 name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675
  25. output file name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/ts.697.825201889 tag=TAG20130903T224244 RECID=9 STAMP=825201898
  26. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:10
  27. output file name=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.520.825201899 tag=TAG20130903T224244 RECID=10 STAMP=825201899
  28. channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:03
  29. Finished backup at 03-SEP-13
  30.  
  31. Starting Control File and SPFILE Autobackup at 03-SEP-13
  32. piece handle=+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/AUTOBACKUP/2013_09_03/s_825201901.516.825201905 comment=NONE
  33. Finished Control File and SPFILE Autobackup at 03-SEP-13
  34.  
  35.  
  36. RMAN> shutdown abort;
  37.  
  38. database closed
  39.  
  40. [grid@waipio1 ~]$ asmcmd rm +DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675
  41.  
  42.  
  43.  
  44. RMAN> startup
  45.  
  46. RMAN-00571: ===========================================================
  47. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  48. RMAN-00571: ===========================================================
  49. RMAN-03002: failure of startup command at 09/03/2013 22:50:10
  50. ORA-01157: cannot identify/lock data file 48 - see DBWR trace file
  51. ORA-01110: data file 48: '+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675'
  52.  
  53.  
  54.  
  55. Tue Sep 03 22:48:41 2013
  56. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local
  57. Pluggable database HILO closed
  58. Completed: alter pluggable database close immediate
  59. Tue Sep 03 22:50:10 2013
  60. alter database open
  61. Tue Sep 03 22:50:10 2013
  62. Errors in file /app/oracle/diag/rdbms/kilauea/KILAUEA/trace/KILAUEA_dbw0_6762.trc:
  63. ORA-01157: cannot identify/lock data file 48 - see DBWR trace file
  64. ORA-01110: data file 48: '+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675'
  65. ORA-17503: ksfdopn:2 Failed to open file +DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675
  66. ORA-15012: ASM file '+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675' does not exist
  67. Tue Sep 03 22:50:10 2013
  68. Pluggable database HILO hit error 1157 during open read write
  69. and will be closed.
  70. Immediate Kill Session#: 12, Serial#: 763
  71. Immediate Kill Session: sess: 0x18a5cf8e0 OS pid: 32480
  72. ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local
  73. Tue Sep 03 22:50:12 2013
  74. Checker run found 1 new persistent data failures
  75. Tue Sep 03 22:50:26 2013
  76. Errors in file /app/oracle/diag/rdbms/kilauea/KILAUEA/trace/KILAUEA_ora_32478.trc:
  77. ORA-19625: error identifying file +DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675
  78. ORA-17503: ksfdopn:2 Failed to open file +DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675
  79. ORA-15012: ASM file '+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.278.825114675' does not exist
  80. Tue Sep 03 22:50:26 2013
  81.  
  82.  
  83. RMAN> switch datafile 48 to copy;
  84.  
  85. datafile 48 switched to datafile copy "+DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.520.825201899"
  86.  
  87. RMAN> recover database;
  88.  
  89. Starting recover at 03-SEP-13
  90. allocated channel: ORA_DISK_1
  91. channel ORA_DISK_1: SID=69 device type=DISK
  92. allocated channel: ORA_DISK_2
  93. channel ORA_DISK_2: SID=186 device type=DISK
  94.  
  95. starting media recovery
  96. media recovery complete, elapsed time: 00:00:01
  97.  
  98. Finished recover at 03-SEP-13
  99.  
  100. RMAN> alter database open;
  101.  
  102. Statement processed
  103.  
  104. RMAN>
  105.  
  106.  
  107. Tue Sep 03 22:50:26 2013
  108. WARNING: switching recovery area datafile copy
  109. +DATA/KILAUEA/E55656EBC9CD1972E0437901A8C02245/DATAFILE/users.520.825201899 as database area datafile.
  110. This datafile is no more accounted into used space. Consider decrementing
  111. db_recovery_file_dest_size parameter value by 5242880 bytes.
  112. Switch of datafile 48 complete to datafile copy
  113. checkpoint is 3366571
  114. alter database recover if needed
  115. datafile 46 , 47 , 48 , 50
  116. Tue Sep 03 22:50:36 2013
  117. Media Recovery Start
  118. Tue Sep 03 22:50:36 2013
  119. Serial Media Recovery started
  120. Tue Sep 03 22:50:37 2013
  121. Recovery of Online Redo Log: Thread 1 Group 1 Seq 157 Reading mem 0
  122. Mem# 0: +DATA/KILAUEA/ONLINELOG/group_1.364.824921903
  123. Mem# 1: +DATA/KILAUEA/ONLINELOG/group_1.681.824921909
  124. Tue Sep 03 22:50:37 2013
  125. Media Recovery Complete (KILAUEA)
  126. Completed: alter database recover if needed
  127. datafile 46 , 47 , 48 , 50
  128. alter database open
  129. Tue Sep 03 22:51:02 2013
  130. Opening pdb HILO (3) with no Resource Manager plan active
  131. Pluggable database HILO opened read write
  132. Completed: alter database open
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement