Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN restore steps need..Urgent!

SITIDec 25 2019 — edited Dec 27 2019
  1. Hi All,

Please help me to restore the RMAN backup

Thanks in Advance.

I have received from the customer are the below Folders:

ARCHIVELOG

AUTOBACKUP

BACKUPSET

CONTROLFILE

ONLINELOG

I have confirmed the below:

1. Which is RMAN Backup to restore the database.

2. Oracle Version 12cR2.

3. Source backup from the windows machine.

I have followed the below steps to restore, but i got error

1. I have restored the SPFILE from backup

2. startup nomount

3. RMAN TARGET /

4. restore controlfile from '/bkup/CLDUMPS/STAM/23DEC19/SN4DB/CONTROLFILE/O1_MF_DYVN2542_.CTL';

5. Alter database mount;

6. catalog start with '/u02/oradata/SN4DB/';

7. And run the following command.

RMAN> run
2> {
3> ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
4> set newname for datafile 1 to '/u02/oradata/SN4DB/O1_MF_SYSTEM_GRS0JS30_.DBF';
5> set newname for datafile 3 to '/u02/oradata/SN4DB/O1_MF_SYSAUX_GRS0JS21_.DBF';
6> set newname for datafile 5 to '/u02/oradata/SN4DB/O1_MF_UNDOTBS1_GRS0JS30_.DBF';
7> set newname for datafile 7 to '/u02/oradata/SN4DB/O1_MF_USERS_GRS0JS40_.DBF';
set newname for datafile 8 to '/u02/oradata/SN4DB/SN4P_DATA01.DBF';
8> 9> set newname for datafile 9 to '/u02/oradata/SN4DB/SN4P_DATA_BACKUP01';
10> set newname for datafile 1 to '/u02/oradata/SN4DB/O1_MF_TEMP_GRS0THX9_.TMP';
11> restore database;
12> switch datafile all;
13> recover database;
14> alter database open resetlogs;
15> }

                    

And below are the attachments, which I have executed:

  2. RMAN> catalog start with '/u02/oradata/SN4DB/';
  4. using target database control file instead of recovery catalog
  5. searching for all files that match the pattern /u02/oradata/SN4DB/
  7. List of Files Unknown to the Database
  8. =====================================
  9. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_28/O1_MF_S_1025494476_GXYDKWV5_.BKP
  10. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_23/O1_MF_S_1022409010_GV07F2JJ_.BKP
  11. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_16/O1_MF_S_1024457707_GWYR2VKH_.BKP
  12. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_11/O1_MF_S_1024025717_GWKL75QW_.BKP
  13. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_29/O1_MF_S_1022926503_GVJ0RQT5_.BKP
  14. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_22/O1_MF_S_1024976077_GXGL9X54_.BKP
  15. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_10/O1_MF_S_1021303757_GSYJ1Y3N_.BKP
  16. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_22/O1_MF_S_1022311183_GTX7VZBR_.BKP
  17. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_29/O1_MF_S_1025580876_GY10XWN9_.BKP
  18. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_30/O1_MF_S_1025667266_GY3O9LZ2_.BKP
  19. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_20/O1_MF_S_1022148788_GTR99468_.BKP
  20. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_12/O1_MF_S_1021454117_GT32WOKT_.BKP
  21. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_31/O1_MF_S_1023098953_GVO95T10_.BKP
  22. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_31/O1_MF_S_1023122475_GVP04VFS_.BKP
  23. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_05/O1_MF_S_1023507287_GW1QY75K_.BKP
  24. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_07/O1_MF_S_1021042787_GSPK6MHO_.BKP
  25. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_24/O1_MF_S_1025148927_GXMV3J45_.BKP
  26. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_27/O1_MF_S_1025408066_GXVR5LPT_.BKP
  27. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_09/O1_MF_S_1023852887_GWD9G7FH_.BKP
  28. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_17/O1_MF_S_1021895484_GTJKXD7V_.BKP
  29. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_03/O1_MF_S_1026012887_GYCLG7JZ_.BKP
  30. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_24/O1_MF_S_1022485427_GV2L13DN_.BKP
  31. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_21/O1_MF_S_1024889667_GXCXXM6J_.BKP
  32. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_07/O1_MF_S_1023680087_GW70P75O_.BKP
  33. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_26/O1_MF_S_1025321717_GXS3V5LN_.BKP
  34. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_06/O1_MF_S_1023593697_GW4DBK78_.BKP
  35. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_19/O1_MF_S_1024716927_GX6O7HO5_.BKP
  36. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_04/O1_MF_S_1026099337_GYG6VSN9_.BKP
  37. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_17/O1_MF_S_1024544127_GX1DHJ18_.BKP
  38. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_25/O1_MF_S_1025235327_GXPHHHSV_.BKP
  39. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_03/O1_MF_S_1023334497_GVWH6KFG_.BKP
  40. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_01/O1_MF_S_1025840086_GY69P71N_.BKP
  41. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_01/O1_MF_S_1025882175_GY7LSHHL_.BKP
  42. File Name: /u02/oradata/SN4DB/AUTOBACKUP/O1_MF_S_1019986064_GRRXN14H_.BKP
  43. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_14/O1_MF_S_1021626950_GT8COPQJ_.BKP
  44. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_13/O1_MF_S_1024198517_GWPTZ5KQ_.BKP
  45. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_04/O1_MF_S_1023420907_GVZ3LVLP_.BKP
  46. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_28/O1_MF_S_1022831841_GVF4BK8O_.BKP
  47. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_02/O1_MF_S_1025926527_GY8Y3HO1_.BKP
  48. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_15/O1_MF_S_1024371307_GWW3PVVG_.BKP
  49. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_05/O1_MF_S_1026185747_GYJV837V_.BKP
  50. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_20/O1_MF_S_1024803266_GX99KLQT_.BKP
  51. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_10/O1_MF_S_1023939317_GWGXV5XT_.BKP
  52. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_02/O1_MF_S_1023248046_GVSTRYCB_.BKP
  53. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_23/O1_MF_S_1025062476_GXK6OX3G_.BKP
  54. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_01/O1_MF_S_1023189218_GVR1BLK0_.BKP
  55. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_14/O1_MF_S_1024284917_GWSHC5DO_.BKP
  56. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_08/O1_MF_S_1023766487_GW9O27HT_.BKP
  57. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_18/O1_MF_S_1024630527_GX40VJ4O_.BKP
  58. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_30/O1_MF_S_1023010713_GVLM09TK_.BKP
  59. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_12/O1_MF_S_1024112107_GWN6LVBT_.BKP
  60. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_15/O1_MF_S_1021751150_GTD4YYO1_.BKP
  61. File Name: /u02/oradata/SN4DB/BACKUPSET/2019_12_05/O1_MF_NNNDF_TAG20191205T033259_GYJV2WVN_.BKP
  62. File Name: /u02/oradata/SN4DB/BACKUPSET/2019_12_05/O1_MF_ANNNN_TAG20191205T033545_GYJV81TB_.BKP
  63. File Name: /u02/oradata/SN4DB/CONTROLFILE/O1_MF_DYVN2542_.CTL
  64. File Name: /u02/oradata/SN4DB/ONLINELOG/O1_MF_1_GRS0TBP6_.LOG
  65. File Name: /u02/oradata/SN4DB/ONLINELOG/O1_MF_2_GRS0TBS4_.LOG
  66. File Name: /u02/oradata/SN4DB/ONLINELOG/O1_MF_3_GRS0TBR4_.LOG
  67. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2194_GYKMKM90_.ARC
  68. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2192_GYKJBKLY_.ARC
  69. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2183_GYK0PV37_.ARC
  70. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2187_GYK7YG3L_.ARC
  71. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2197_GYKQNPPM_.ARC
  72. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2203_GYL0V9BM_.ARC
  73. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2185_GYK4FTYJ_.ARC
  74. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2191_GYKGPXV3_.ARC
  75. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2188_GYK9MXTY_.ARC
  76. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2190_GYKF1K5C_.ARC
  77. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2212_GYLGK2BQ_.ARC
  78. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2210_GYLCH0TP_.ARC
  79. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2198_GYKRYTLY_.ARC
  80. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2186_GYK664TP_.ARC
  81. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2205_GYL3S0LY_.ARC
  82. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2200_GYKW0MWF_.ARC
  83. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2204_GYL2FJ2W_.ARC
  84. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2201_GYKXPZ3G_.ARC
  85. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2182_GYJYTS27_.ARC
  86. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2195_GYKO2F38_.ARC
  87. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2207_GYL6WDHV_.ARC
  88. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2184_GYK2KZ0S_.ARC
  89. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2208_GYL8F5BL_.ARC
  90. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2196_GYKP6ZTV_.ARC
  91. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2180_GYJV81F1_.ARC
  92. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2189_GYKCC3XM_.ARC
  93. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2181_GYJX0SCR_.ARC
  94. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2211_GYLDYYXK_.ARC
  95. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2206_GYL5COTZ_.ARC
  96. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2193_GYKKY2C4_.ARC
  97. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2199_GYKTJ93F_.ARC
  98. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2202_GYKZ9KOY_.ARC
  99. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2209_GYL9V1LL_.ARC
  101. Do you really want to catalog the above files (enter YES or NO)? YES
  102. cataloging files...
  103. cataloging done
  105. List of Cataloged Files
  106. =======================
  107. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_28/O1_MF_S_1025494476_GXYDKWV5_.BKP
  108. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_23/O1_MF_S_1022409010_GV07F2JJ_.BKP
  109. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_16/O1_MF_S_1024457707_GWYR2VKH_.BKP
  110. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_11/O1_MF_S_1024025717_GWKL75QW_.BKP
  111. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_29/O1_MF_S_1022926503_GVJ0RQT5_.BKP
  112. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_22/O1_MF_S_1024976077_GXGL9X54_.BKP
  113. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_10/O1_MF_S_1021303757_GSYJ1Y3N_.BKP
  114. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_22/O1_MF_S_1022311183_GTX7VZBR_.BKP
  115. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_29/O1_MF_S_1025580876_GY10XWN9_.BKP
  116. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_30/O1_MF_S_1025667266_GY3O9LZ2_.BKP
  117. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_20/O1_MF_S_1022148788_GTR99468_.BKP
  118. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_12/O1_MF_S_1021454117_GT32WOKT_.BKP
  119. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_31/O1_MF_S_1023098953_GVO95T10_.BKP
  120. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_31/O1_MF_S_1023122475_GVP04VFS_.BKP
  121. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_05/O1_MF_S_1023507287_GW1QY75K_.BKP
  122. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_07/O1_MF_S_1021042787_GSPK6MHO_.BKP
  123. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_24/O1_MF_S_1025148927_GXMV3J45_.BKP
  124. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_27/O1_MF_S_1025408066_GXVR5LPT_.BKP
  125. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_09/O1_MF_S_1023852887_GWD9G7FH_.BKP
  126. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_17/O1_MF_S_1021895484_GTJKXD7V_.BKP
  127. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_03/O1_MF_S_1026012887_GYCLG7JZ_.BKP
  128. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_24/O1_MF_S_1022485427_GV2L13DN_.BKP
  129. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_21/O1_MF_S_1024889667_GXCXXM6J_.BKP
  130. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_07/O1_MF_S_1023680087_GW70P75O_.BKP
  131. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_26/O1_MF_S_1025321717_GXS3V5LN_.BKP
  132. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_06/O1_MF_S_1023593697_GW4DBK78_.BKP
  133. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_19/O1_MF_S_1024716927_GX6O7HO5_.BKP
  134. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_04/O1_MF_S_1026099337_GYG6VSN9_.BKP
  135. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_17/O1_MF_S_1024544127_GX1DHJ18_.BKP
  136. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_25/O1_MF_S_1025235327_GXPHHHSV_.BKP
  137. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_03/O1_MF_S_1023334497_GVWH6KFG_.BKP
  138. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_01/O1_MF_S_1025840086_GY69P71N_.BKP
  139. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_01/O1_MF_S_1025882175_GY7LSHHL_.BKP
  140. File Name: /u02/oradata/SN4DB/AUTOBACKUP/O1_MF_S_1019986064_GRRXN14H_.BKP
  141. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_14/O1_MF_S_1021626950_GT8COPQJ_.BKP
  142. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_13/O1_MF_S_1024198517_GWPTZ5KQ_.BKP
  143. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_04/O1_MF_S_1023420907_GVZ3LVLP_.BKP
  144. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_28/O1_MF_S_1022831841_GVF4BK8O_.BKP
  145. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_02/O1_MF_S_1025926527_GY8Y3HO1_.BKP
  146. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_15/O1_MF_S_1024371307_GWW3PVVG_.BKP
  147. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_12_05/O1_MF_S_1026185747_GYJV837V_.BKP
  148. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_20/O1_MF_S_1024803266_GX99KLQT_.BKP
  149. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_10/O1_MF_S_1023939317_GWGXV5XT_.BKP
  150. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_02/O1_MF_S_1023248046_GVSTRYCB_.BKP
  151. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_23/O1_MF_S_1025062476_GXK6OX3G_.BKP
  152. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_01/O1_MF_S_1023189218_GVR1BLK0_.BKP
  153. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_14/O1_MF_S_1024284917_GWSHC5DO_.BKP
  154. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_08/O1_MF_S_1023766487_GW9O27HT_.BKP
  155. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_18/O1_MF_S_1024630527_GX40VJ4O_.BKP
  156. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_30/O1_MF_S_1023010713_GVLM09TK_.BKP
  157. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_11_12/O1_MF_S_1024112107_GWN6LVBT_.BKP
  158. File Name: /u02/oradata/SN4DB/AUTOBACKUP/2019_10_15/O1_MF_S_1021751150_GTD4YYO1_.BKP
  159. File Name: /u02/oradata/SN4DB/BACKUPSET/2019_12_05/O1_MF_NNNDF_TAG20191205T033259_GYJV2WVN_.BKP
  160. File Name: /u02/oradata/SN4DB/BACKUPSET/2019_12_05/O1_MF_ANNNN_TAG20191205T033545_GYJV81TB_.BKP
  161. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2194_GYKMKM90_.ARC
  162. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2192_GYKJBKLY_.ARC
  163. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2183_GYK0PV37_.ARC
  164. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2187_GYK7YG3L_.ARC
  165. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2197_GYKQNPPM_.ARC
  166. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2203_GYL0V9BM_.ARC
  167. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2185_GYK4FTYJ_.ARC
  168. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2191_GYKGPXV3_.ARC
  169. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2188_GYK9MXTY_.ARC
  170. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2190_GYKF1K5C_.ARC
  171. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2212_GYLGK2BQ_.ARC
  172. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2210_GYLCH0TP_.ARC
  173. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2198_GYKRYTLY_.ARC
  174. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2186_GYK664TP_.ARC
  175. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2205_GYL3S0LY_.ARC
  176. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2200_GYKW0MWF_.ARC
  177. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2204_GYL2FJ2W_.ARC
  178. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2201_GYKXPZ3G_.ARC
  179. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2182_GYJYTS27_.ARC
  180. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2195_GYKO2F38_.ARC
  181. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2207_GYL6WDHV_.ARC
  182. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2184_GYK2KZ0S_.ARC
  183. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2208_GYL8F5BL_.ARC
  184. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2196_GYKP6ZTV_.ARC
  185. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2180_GYJV81F1_.ARC
  186. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2189_GYKCC3XM_.ARC
  187. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2181_GYJX0SCR_.ARC
  188. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2211_GYLDYYXK_.ARC
  189. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2206_GYL5COTZ_.ARC
  190. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2193_GYKKY2C4_.ARC
  191. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2199_GYKTJ93F_.ARC
  192. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2202_GYKZ9KOY_.ARC
  193. File Name: /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2209_GYL9V1LL_.ARC
  195. List of Files Which Were Not Cataloged
  196. =======================================
  197. File Name: /u02/oradata/SN4DB/CONTROLFILE/O1_MF_DYVN2542_.CTL
  198. RMAN-07519: Reason: Error while cataloging. See alert.log.
  199. File Name: /u02/oradata/SN4DB/ONLINELOG/O1_MF_1_GRS0TBP6_.LOG
  200. RMAN-07529: Reason: catalog is not supported for this file type
  201. File Name: /u02/oradata/SN4DB/ONLINELOG/O1_MF_2_GRS0TBS4_.LOG
  202. RMAN-07529: Reason: catalog is not supported for this file type
  203. File Name: /u02/oradata/SN4DB/ONLINELOG/O1_MF_3_GRS0TBR4_.LOG
  204. RMAN-07529: Reason: catalog is not supported for this file type
  206. RMAN> run
  207. 2> {
  208. 3> ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
  209. 4> set newname for datafile 1 to '/u02/oradata/SN4DB/O1_MF_SYSTEM_GRS0JS30_.DBF';
  210. 5> set newname for datafile 3 to '/u02/oradata/SN4DB/O1_MF_SYSAUX_GRS0JS21_.DBF';
  211. 6> set newname for datafile 5 to '/u02/oradata/SN4DB/O1_MF_UNDOTBS1_GRS0JS30_.DBF';
  212. 7> set newname for datafile 7 to '/u02/oradata/SN4DB/O1_MF_USERS_GRS0JS40_.DBF';
  213. set newname for datafile 8 to '/u02/oradata/SN4DB/SN4P_DATA01.DBF';
  214. 8> 9> set newname for datafile 9 to '/u02/oradata/SN4DB/SN4P_DATA_BACKUP01';
  215. 10> set newname for datafile 1 to '/u02/oradata/SN4DB/O1_MF_TEMP_GRS0THX9_.TMP';
  216. 11> restore database;
  217. 12> switch datafile all;
  218. 13> recover database;
  219. 14> alter database open resetlogs;
  220. 15> }
  222. allocated channel: ch1
  223. channel ch1: SID=768 device type=DISK
  225. executing command: SET NEWNAME
  227. executing command: SET NEWNAME
  229. executing command: SET NEWNAME
  231. executing command: SET NEWNAME
  233. executing command: SET NEWNAME
  235. executing command: SET NEWNAME
  237. executing command: SET NEWNAME
  239. Starting restore at 23-DEC-19
  241. channel ch1: starting datafile backup set restore
  242. channel ch1: specifying datafile(s) to restore from backup set
  243. channel ch1: restoring datafile 00001 to /u02/oradata/SN4DB/O1_MF_TEMP_GRS0THX9_.TMP
  244. channel ch1: restoring datafile 00003 to /u02/oradata/SN4DB/O1_MF_SYSAUX_GRS0JS21_.DBF
  245. channel ch1: restoring datafile 00005 to /u02/oradata/SN4DB/O1_MF_UNDOTBS1_GRS0JS30_.DBF
  246. channel ch1: restoring datafile 00007 to /u02/oradata/SN4DB/O1_MF_USERS_GRS0JS40_.DBF
  247. channel ch1: restoring datafile 00008 to /u02/oradata/SN4DB/SN4P_DATA01.DBF
  248. channel ch1: restoring datafile 00009 to /u02/oradata/SN4DB/SN4P_DATA_BACKUP01
  249. channel ch1: reading from backup piece D:\APP\ORACLE\FAST_RECOVERY_AREA\SN4DB\SN4DB\BACKUPSET\2019_12_05\O1_MF_NNNDF_TAG20191205T033259_GYJV2WVN_.BKP
  250. channel ch1: errors found reading piece handle=D:\APP\ORACLE\FAST_RECOVERY_AREA\SN4DB\SN4DB\BACKUPSET\2019_12_05\O1_MF_NNNDF_TAG20191205T033259_GYJV2WVN_.BKP
  251. channel ch1: failover to piece handle=/u02/oradata/SN4DB/BACKUPSET/2019_12_05/O1_MF_NNNDF_TAG20191205T033259_GYJV2WVN_.BKP tag=TAG20191205T033259
  252. channel ch1: restored backup piece 1
  253. channel ch1: restore complete, elapsed time: 00:08:25
  254. Finished restore at 23-DEC-19
  256. datafile 1 switched to datafile copy
  257. input datafile copy RECID=7 STAMP=1027793369 file name=/u02/oradata/SN4DB/O1_MF_TEMP_GRS0THX9_.TMP
  258. datafile 3 switched to datafile copy
  259. input datafile copy RECID=8 STAMP=1027793369 file name=/u02/oradata/SN4DB/O1_MF_SYSAUX_GRS0JS21_.DBF
  260. datafile 5 switched to datafile copy
  261. input datafile copy RECID=9 STAMP=1027793369 file name=/u02/oradata/SN4DB/O1_MF_UNDOTBS1_GRS0JS30_.DBF
  262. datafile 7 switched to datafile copy
  263. input datafile copy RECID=10 STAMP=1027793369 file name=/u02/oradata/SN4DB/O1_MF_USERS_GRS0JS40_.DBF
  264. datafile 8 switched to datafile copy
  265. input datafile copy RECID=11 STAMP=1027793369 file name=/u02/oradata/SN4DB/SN4P_DATA01.DBF
  266. datafile 9 switched to datafile copy
  267. input datafile copy RECID=12 STAMP=1027793369 file name=/u02/oradata/SN4DB/SN4P_DATA_BACKUP01
  269. Starting recover at 23-DEC-19
  271. starting media recovery
  273. archived log for thread 1 with sequence 2180 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2180_GYJV81F1_.ARC
  274. archived log for thread 1 with sequence 2181 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2181_GYJX0SCR_.ARC
  275. archived log for thread 1 with sequence 2182 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2182_GYJYTS27_.ARC
  276. archived log for thread 1 with sequence 2183 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2183_GYK0PV37_.ARC
  277. archived log for thread 1 with sequence 2184 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2184_GYK2KZ0S_.ARC
  278. archived log for thread 1 with sequence 2185 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2185_GYK4FTYJ_.ARC
  279. archived log for thread 1 with sequence 2186 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2186_GYK664TP_.ARC
  280. archived log for thread 1 with sequence 2187 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2187_GYK7YG3L_.ARC
  281. archived log for thread 1 with sequence 2188 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2188_GYK9MXTY_.ARC
  282. archived log for thread 1 with sequence 2189 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2189_GYKCC3XM_.ARC
  283. archived log for thread 1 with sequence 2190 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2190_GYKF1K5C_.ARC
  284. archived log for thread 1 with sequence 2191 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2191_GYKGPXV3_.ARC
  285. archived log for thread 1 with sequence 2192 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2192_GYKJBKLY_.ARC
  286. archived log for thread 1 with sequence 2193 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2193_GYKKY2C4_.ARC
  287. archived log for thread 1 with sequence 2194 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2194_GYKMKM90_.ARC
  288. archived log for thread 1 with sequence 2195 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2195_GYKO2F38_.ARC
  289. archived log for thread 1 with sequence 2196 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2196_GYKP6ZTV_.ARC
  290. archived log for thread 1 with sequence 2197 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2197_GYKQNPPM_.ARC
  291. archived log for thread 1 with sequence 2198 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2198_GYKRYTLY_.ARC
  292. archived log for thread 1 with sequence 2199 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2199_GYKTJ93F_.ARC
  293. archived log for thread 1 with sequence 2200 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2200_GYKW0MWF_.ARC
  294. archived log for thread 1 with sequence 2201 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2201_GYKXPZ3G_.ARC
  295. archived log for thread 1 with sequence 2202 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2202_GYKZ9KOY_.ARC
  296. archived log for thread 1 with sequence 2203 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2203_GYL0V9BM_.ARC
  297. archived log for thread 1 with sequence 2204 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2204_GYL2FJ2W_.ARC
  298. archived log for thread 1 with sequence 2205 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2205_GYL3S0LY_.ARC
  299. archived log for thread 1 with sequence 2206 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2206_GYL5COTZ_.ARC
  300. archived log for thread 1 with sequence 2207 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2207_GYL6WDHV_.ARC
  301. archived log for thread 1 with sequence 2208 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2208_GYL8F5BL_.ARC
  302. archived log for thread 1 with sequence 2209 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2209_GYL9V1LL_.ARC
  303. archived log for thread 1 with sequence 2210 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2210_GYLCH0TP_.ARC
  304. archived log for thread 1 with sequence 2211 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2211_GYLDYYXK_.ARC
  305. archived log for thread 1 with sequence 2212 is already on disk as file /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2212_GYLGK2BQ_.ARC
  306. archived log file name=/u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2180_GYJV81F1_.ARC thread=1 sequence=2180
  307. released channel: ch1
  308. RMAN-00571: ===========================================================
  309. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  310. RMAN-00571: ===========================================================
  311. RMAN-03002: failure of recover command at 12/23/2019 18:09:31
  312. RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2180_GYJV81F1_.ARC'
  313. ORA-10562: Error occurred while applying redo to data block (file# 1, block# 1164)
  314. ORA-10564: tablespace SYSTEM
  315. ORA-01110: data file 1: '/u02/oradata/SN4DB/O1_MF_TEMP_GRS0THX9_.TMP'
  316. ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 100
  317. ORA-00600: internal error code, arguments: [ktbrcl:NOOP incompat_opt], [214], [], [], [], [], [], [], [], [], [], []
  319. RMAN>
  321. Recovery Manager complete.
  322. [oracle@INMAA3-VQADB09 CONTROLFILE]$ sqldba
  324. SQL*Plus: Release 12.2.0.1.0 Production on Mon Dec 23 18:10:07 2019
  326. Copyright (c) 1982, 2016, Oracle.  All rights reserved.
  329. Connected to:
  330. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  332. SQL> @status
  334. INSTANCE_NAME    STATUS
  335. ---------------- ------------
  336. SN4DB            MOUNTED
  338. SQL> Alter database open;
  339. Alter database open
  340. *
  341. ERROR at line 1:
  342. ORA-01113: file 1 needs media recovery
  343. ORA-01110: data file 1: '/u02/oradata/SN4DB/O1_MF_TEMP_GRS0THX9_.TMP'
  346. SQL> Alter database open resetlogs;
  347. Alter database open resetlogs
  348. *
  349. ERROR at line 1:
  350. ORA-01139: RESETLOGS option only valid after an incomplete database recovery
  353. SQL> Alter database recover;
  354. Alter database recover
  355. *
  356. ERROR at line 1:
  357. ORA-00279: change 139740703541 generated at 12/05/2019 03:30:01 needed for
  358. thread 1
  359. ORA-00289: suggestion :
  360. /u02/oradata/SN4DB/ARCHIVELOG/2019_12_05/O1_MF_1_2180_GYJV81F1_.ARC
  361. ORA-00280: change 139740703541 for thread 1 is in sequence #2180

Thanks in Advance,

Thanks & Regards,

Jayaprakash
Comments
Post Details
Added on Dec 25 2019
#oracle, #performance-availability, #recovery-manager-rman, #rman
4 comments
1,607 views