Forum Stats

  • 3,825,190 Users
  • 2,260,478 Discussions
  • 7,896,432 Comments

Discussions

RMAN restore steps need..Urgent!

SITI
SITI Member Posts: 238 Bronze Badge
edited Dec 27, 2019 7:44AM in Recovery Manager (RMAN)
  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:

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

Thanks in Advance,

Thanks & Regards,

Jayaprakash

Tagged:
SITI

Comments

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    edited Dec 26, 2019 8:38AM

    ORA-00600:

    That's an 'unhandled exception' (aka: you hit a bug).

    You only have one course of action:

    Logon on to My Oracle Support and use the ORA-0600 lookup tool (use the home page 'search' for 'ora-0600').

    If that doesn't yeild a solution, open an SR.

    BTW, this is a forum of peer volunteers who have other jobs.  There is no 'urgent' here.

    SITISITI
  • Sunny kichloo
    Sunny kichloo Member Posts: 2,459 Gold Trophy
    edited Dec 26, 2019 10:52PM

    Are you sure whether backup provided to you is consistent?

    As per me it is not complete backup may be datafile is not recent.

    If you have metalink support access better raise a Oracle SR as suggested earlier.

    SITISITI
  • Dude!
    Dude! Member Posts: 22,829 Black Diamond
    edited Dec 27, 2019 2:23AM
    channel ch1: reading from backup piece D:\APP\ORACLE\FAST_RECOVERY_AREA\SN4DB\SN4DB\BACKUPSET\2019_12_05\O1_MF_NNNDF_TAG20191205T033259_GYJV2WVN_.BKPRMAN-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'

    You may have a hardware defect or damaged backup/recovery data. If the hardware is OK, then I suggest you try an incomplete restore and recovery to a previous time (PITR).

    SITISITI
  • SITI
    SITI Member Posts: 238 Bronze Badge
    edited Dec 27, 2019 7:44AM

    Thanks for the reply..

    I have asked for expdp backup..

    Thank you!!