API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 9th, 2019
375
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.56 KB | None | 0 0
raw download clone embed print report
  1. [oracle@o71 ~]$ rman target /
  2.  
  3. Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 9 13:49:38 2019
  4. Version 19.3.0.0.0
  5.  
  6. Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
  7.  
  8. connected to target database: MIN19 (DBID=2116532768)
  9.  
  10. RMAN> delete noprompt backup;
  11.  
  12. using target database control file instead of recovery catalog
  13. allocated channel: ORA_DISK_1
  14. channel ORA_DISK_1: SID=18 device type=DISK
  15.  
  16. List of Backup Pieces
  17. BP Key BS Key Pc# Cp# Status Device Type Piece Name
  18. ------- ------- --- --- ----------- ----------- ----------
  19. 22 22 1 1 AVAILABLE DISK /fra/MIN19_O71/backupset/2019_07_04/o1_mf_annnn_TAG20190704T174648_gkw7v8l7_.bkp
  20. 23 23 1 1 AVAILABLE DISK /fra/MIN19_O71/backupset/2019_07_04/o1_mf_nnndf_MYTAG_gkw7vb2p_.bkp
  21. 24 24 1 1 AVAILABLE DISK /fra/MIN19_O71/backupset/2019_07_04/o1_mf_annnn_TAG20190704T174715_gkw7w3kq_.bkp
  22. 25 25 1 1 AVAILABLE DISK /fra/MIN19_O71/autobackup/2019_07_04/o1_mf_s_1012758436_gkw7w4wc_.bkp
  23. 26 26 1 1 AVAILABLE DISK /fra/MIN19_O71/backupset/2019_07_04/o1_mf_nnsnf_MYTAG_gkw894hh_.bkp
  24. 27 27 1 1 AVAILABLE DISK /fra/MIN19_O71/autobackup/2019_07_04/o1_mf_s_1012758855_gkw897rp_.bkp
  25. deleted backup piece
  26. backup piece handle=/fra/MIN19_O71/backupset/2019_07_04/o1_mf_annnn_TAG20190704T174648_gkw7v8l7_.bkp RECID=22 STAMP=1012758408
  27. deleted backup piece
  28. backup piece handle=/fra/MIN19_O71/backupset/2019_07_04/o1_mf_nnndf_MYTAG_gkw7vb2p_.bkp RECID=23 STAMP=1012758410
  29. deleted backup piece
  30. backup piece handle=/fra/MIN19_O71/backupset/2019_07_04/o1_mf_annnn_TAG20190704T174715_gkw7w3kq_.bkp RECID=24 STAMP=1012758435
  31. deleted backup piece
  32. backup piece handle=/fra/MIN19_O71/autobackup/2019_07_04/o1_mf_s_1012758436_gkw7w4wc_.bkp RECID=25 STAMP=1012758436
  33. deleted backup piece
  34. backup piece handle=/fra/MIN19_O71/backupset/2019_07_04/o1_mf_nnsnf_MYTAG_gkw894hh_.bkp RECID=26 STAMP=1012758852
  35. deleted backup piece
  36. backup piece handle=/fra/MIN19_O71/autobackup/2019_07_04/o1_mf_s_1012758855_gkw897rp_.bkp RECID=27 STAMP=1012758855
  37. Deleted 6 objects
  38.  
  39.  
  40. RMAN> show all;
  41.  
  42. RMAN configuration parameters for database with db_unique_name MIN19_O71 are:
  43. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
  44. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  45. CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
  46. CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
  47. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  48. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
  49. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  50. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  51. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  52. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  53. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  54. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  55. CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
  56. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  57. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/snapcf_MIN19.f'; # default
  58.  
  59. RMAN> backup incremental level 0 database plus archivelog delete all input;
  60.  
  61.  
  62. Starting backup at 09-JUL-19
  63. current log archived
  64. using channel ORA_DISK_1
  65. channel ORA_DISK_1: starting archived log backup set
  66. channel ORA_DISK_1: specifying archived log(s) in backup set
  67. input archived log thread=1 sequence=173 RECID=282 STAMP=1012755768
  68. input archived log thread=1 sequence=174 RECID=283 STAMP=1012755815
  69. input archived log thread=1 sequence=175 RECID=284 STAMP=1012756059
  70. input archived log thread=1 sequence=176 RECID=285 STAMP=1012756079
  71. input archived log thread=1 sequence=177 RECID=286 STAMP=1012756128
  72. input archived log thread=1 sequence=178 RECID=287 STAMP=1012758407
  73. input archived log thread=1 sequence=179 RECID=288 STAMP=1012758435
  74. input archived log thread=1 sequence=180 RECID=289 STAMP=1012795182
  75. input archived log thread=1 sequence=181 RECID=290 STAMP=1012843061
  76. input archived log thread=1 sequence=182 RECID=291 STAMP=1012881659
  77. input archived log thread=1 sequence=183 RECID=292 STAMP=1012929785
  78. input archived log thread=1 sequence=184 RECID=293 STAMP=1012952306
  79. input archived log thread=1 sequence=185 RECID=294 STAMP=1012975939
  80. input archived log thread=1 sequence=186 RECID=295 STAMP=1013013328
  81. input archived log thread=1 sequence=187 RECID=296 STAMP=1013053483
  82. input archived log thread=1 sequence=188 RECID=297 STAMP=1013103089
  83. input archived log thread=1 sequence=189 RECID=298 STAMP=1013143746
  84. input archived log thread=1 sequence=190 RECID=299 STAMP=1013176209
  85. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  86. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  87. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135009_gl8zvlkd_.bkp tag=TAG20190709T135009 comment=NONE
  88. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
  89. channel ORA_DISK_1: deleting archived log(s)
  90. archived log file name=/fra/MIN19_O71/archivelog/2019_07_04/o1_mf_1_173_gkw58rbg_.arc RECID=282 STAMP=1012755768
  91. archived log file name=/fra/MIN19_O71/archivelog/2019_07_04/o1_mf_1_174_gkw5b77m_.arc RECID=283 STAMP=1012755815
  92. archived log file name=/fra/MIN19_O71/archivelog/2019_07_04/o1_mf_1_175_gkw5kv3f_.arc RECID=284 STAMP=1012756059
  93. archived log file name=/fra/MIN19_O71/archivelog/2019_07_04/o1_mf_1_176_gkw5lhhw_.arc RECID=285 STAMP=1012756079
  94. archived log file name=/fra/MIN19_O71/archivelog/2019_07_04/o1_mf_1_177_gkw5n0q2_.arc RECID=286 STAMP=1012756128
  95. archived log file name=/fra/MIN19_O71/archivelog/2019_07_04/o1_mf_1_178_gkw7v6nv_.arc RECID=287 STAMP=1012758407
  96. archived log file name=/fra/MIN19_O71/archivelog/2019_07_04/o1_mf_1_179_gkw7w338_.arc RECID=288 STAMP=1012758435
  97. archived log file name=/fra/MIN19_O71/archivelog/2019_07_05/o1_mf_1_180_gkxcrbmy_.arc RECID=289 STAMP=1012795182
  98. archived log file name=/fra/MIN19_O71/archivelog/2019_07_05/o1_mf_1_181_gkytjkyd_.arc RECID=290 STAMP=1012843061
  99. archived log file name=/fra/MIN19_O71/archivelog/2019_07_06/o1_mf_1_182_gl006sbb_.arc RECID=291 STAMP=1012881659
  100. archived log file name=/fra/MIN19_O71/archivelog/2019_07_06/o1_mf_1_183_gl1h6q7h_.arc RECID=292 STAMP=1012929785
  101. archived log file name=/fra/MIN19_O71/archivelog/2019_07_06/o1_mf_1_184_gl256kj0_.arc RECID=293 STAMP=1012952306
  102. archived log file name=/fra/MIN19_O71/archivelog/2019_07_07/o1_mf_1_185_gl2w9221_.arc RECID=294 STAMP=1012975939
  103. archived log file name=/fra/MIN19_O71/archivelog/2019_07_07/o1_mf_1_186_gl40shyd_.arc RECID=295 STAMP=1013013328
  104. archived log file name=/fra/MIN19_O71/archivelog/2019_07_08/o1_mf_1_187_gl5808q5_.arc RECID=296 STAMP=1013053483
  105. archived log file name=/fra/MIN19_O71/archivelog/2019_07_08/o1_mf_1_188_gl6rggv8_.arc RECID=297 STAMP=1013103089
  106. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_189_gl80502t_.arc RECID=298 STAMP=1013143746
  107. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_190_gl8zvhyl_.arc RECID=299 STAMP=1013176209
  108. Finished backup at 09-JUL-19
  109.  
  110. Starting backup at 09-JUL-19
  111. using channel ORA_DISK_1
  112. channel ORA_DISK_1: starting incremental level 0 datafile backup set
  113. channel ORA_DISK_1: specifying datafile(s) in backup set
  114. input datafile file number=00003 name=/oradata/MIN19_O71/undotbs01.dbf
  115. input datafile file number=00001 name=/oradata/MIN19_O71/system01.dbf
  116. input datafile file number=00004 name=/oradata/MIN19_O71/users01.dbf
  117. input datafile file number=00002 name=/oradata/MIN19_O71/sysaux01.dbf
  118. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  119. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  120. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd0_TAG20190709T135047_gl8zwqd5_.bkp tag=TAG20190709T135047 comment=NONE
  121. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
  122. Finished backup at 09-JUL-19
  123.  
  124. Starting backup at 09-JUL-19
  125. current log archived
  126. using channel ORA_DISK_1
  127. channel ORA_DISK_1: starting archived log backup set
  128. channel ORA_DISK_1: specifying archived log(s) in backup set
  129. input archived log thread=1 sequence=191 RECID=300 STAMP=1013176272
  130. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  131. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  132. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135112_gl8zxk1w_.bkp tag=TAG20190709T135112 comment=NONE
  133. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  134. channel ORA_DISK_1: deleting archived log(s)
  135. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_191_gl8zxjh9_.arc RECID=300 STAMP=1013176272
  136. Finished backup at 09-JUL-19
  137.  
  138. Starting Control File and SPFILE Autobackup at 09-JUL-19
  139. piece handle=/fra/MIN19_O71/autobackup/2019_07_09/o1_mf_s_1013176274_gl8zxln0_.bkp comment=NONE
  140. Finished Control File and SPFILE Autobackup at 09-JUL-19
  141.  
  142. RMAN> backup incremental level 1 database plus archivelog delete all input;
  143.  
  144.  
  145. Starting backup at 09-JUL-19
  146. current log archived
  147. using channel ORA_DISK_1
  148. channel ORA_DISK_1: starting archived log backup set
  149. channel ORA_DISK_1: specifying archived log(s) in backup set
  150. input archived log thread=1 sequence=192 RECID=301 STAMP=1013176295
  151. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  152. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  153. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135135_gl8zy7xk_.bkp tag=TAG20190709T135135 comment=NONE
  154. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  155. channel ORA_DISK_1: deleting archived log(s)
  156. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_192_gl8zy7dv_.arc RECID=301 STAMP=1013176295
  157. Finished backup at 09-JUL-19
  158.  
  159. Starting backup at 09-JUL-19
  160. using channel ORA_DISK_1
  161. channel ORA_DISK_1: starting incremental level 1 datafile backup set
  162. channel ORA_DISK_1: specifying datafile(s) in backup set
  163. input datafile file number=00003 name=/oradata/MIN19_O71/undotbs01.dbf
  164. input datafile file number=00001 name=/oradata/MIN19_O71/system01.dbf
  165. input datafile file number=00004 name=/oradata/MIN19_O71/users01.dbf
  166. input datafile file number=00002 name=/oradata/MIN19_O71/sysaux01.dbf
  167. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  168. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  169. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd1_TAG20190709T135137_gl8zy9ls_.bkp tag=TAG20190709T135137 comment=NONE
  170. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
  171. Finished backup at 09-JUL-19
  172.  
  173. Starting backup at 09-JUL-19
  174. current log archived
  175. using channel ORA_DISK_1
  176. channel ORA_DISK_1: starting archived log backup set
  177. channel ORA_DISK_1: specifying archived log(s) in backup set
  178. input archived log thread=1 sequence=193 RECID=302 STAMP=1013176300
  179. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  180. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  181. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135140_gl8zyf4j_.bkp tag=TAG20190709T135140 comment=NONE
  182. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  183. channel ORA_DISK_1: deleting archived log(s)
  184. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_193_gl8zydnb_.arc RECID=302 STAMP=1013176300
  185. Finished backup at 09-JUL-19
  186.  
  187. Starting Control File and SPFILE Autobackup at 09-JUL-19
  188. piece handle=/fra/MIN19_O71/autobackup/2019_07_09/o1_mf_s_1013176302_gl8zygm2_.bkp comment=NONE
  189. Finished Control File and SPFILE Autobackup at 09-JUL-19
  190.  
  191. RMAN> backup incremental level 0 database plus archivelog delete all input;
  192.  
  193.  
  194. Starting backup at 09-JUL-19
  195. current log archived
  196. using channel ORA_DISK_1
  197. channel ORA_DISK_1: starting archived log backup set
  198. channel ORA_DISK_1: specifying archived log(s) in backup set
  199. input archived log thread=1 sequence=194 RECID=303 STAMP=1013176359
  200. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  201. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  202. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135239_gl900857_.bkp tag=TAG20190709T135239 comment=NONE
  203. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  204. channel ORA_DISK_1: deleting archived log(s)
  205. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_194_gl9007ly_.arc RECID=303 STAMP=1013176359
  206. Finished backup at 09-JUL-19
  207.  
  208. Starting backup at 09-JUL-19
  209. using channel ORA_DISK_1
  210. channel ORA_DISK_1: starting incremental level 0 datafile backup set
  211. channel ORA_DISK_1: specifying datafile(s) in backup set
  212. input datafile file number=00003 name=/oradata/MIN19_O71/undotbs01.dbf
  213. input datafile file number=00001 name=/oradata/MIN19_O71/system01.dbf
  214. input datafile file number=00004 name=/oradata/MIN19_O71/users01.dbf
  215. input datafile file number=00002 name=/oradata/MIN19_O71/sysaux01.dbf
  216. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  217. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  218. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd0_TAG20190709T135241_gl9009on_.bkp tag=TAG20190709T135241 comment=NONE
  219. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
  220. Finished backup at 09-JUL-19
  221.  
  222. Starting backup at 09-JUL-19
  223. current log archived
  224. using channel ORA_DISK_1
  225. channel ORA_DISK_1: starting archived log backup set
  226. channel ORA_DISK_1: specifying archived log(s) in backup set
  227. input archived log thread=1 sequence=195 RECID=304 STAMP=1013176386
  228. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  229. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  230. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135307_gl901390_.bkp tag=TAG20190709T135307 comment=NONE
  231. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  232. channel ORA_DISK_1: deleting archived log(s)
  233. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_195_gl9012qm_.arc RECID=304 STAMP=1013176386
  234. Finished backup at 09-JUL-19
  235.  
  236. Starting Control File and SPFILE Autobackup at 09-JUL-19
  237. piece handle=/fra/MIN19_O71/autobackup/2019_07_09/o1_mf_s_1013176388_gl9014pw_.bkp comment=NONE
  238. Finished Control File and SPFILE Autobackup at 09-JUL-19
  239.  
  240. RMAN> backup incremental level 1 database plus archivelog delete all input;
  241.  
  242.  
  243. Starting backup at 09-JUL-19
  244. current log archived
  245. using channel ORA_DISK_1
  246. channel ORA_DISK_1: starting archived log backup set
  247. channel ORA_DISK_1: specifying archived log(s) in backup set
  248. input archived log thread=1 sequence=196 RECID=305 STAMP=1013176393
  249. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  250. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  251. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135313_gl901b0p_.bkp tag=TAG20190709T135313 comment=NONE
  252. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  253. channel ORA_DISK_1: deleting archived log(s)
  254. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_196_gl9019j7_.arc RECID=305 STAMP=1013176393
  255. Finished backup at 09-JUL-19
  256.  
  257. Starting backup at 09-JUL-19
  258. using channel ORA_DISK_1
  259. channel ORA_DISK_1: starting incremental level 1 datafile backup set
  260. channel ORA_DISK_1: specifying datafile(s) in backup set
  261. input datafile file number=00003 name=/oradata/MIN19_O71/undotbs01.dbf
  262. input datafile file number=00001 name=/oradata/MIN19_O71/system01.dbf
  263. input datafile file number=00004 name=/oradata/MIN19_O71/users01.dbf
  264. input datafile file number=00002 name=/oradata/MIN19_O71/sysaux01.dbf
  265. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  266. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  267. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd1_TAG20190709T135315_gl901cjt_.bkp tag=TAG20190709T135315 comment=NONE
  268. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
  269. Finished backup at 09-JUL-19
  270.  
  271. Starting backup at 09-JUL-19
  272. current log archived
  273. using channel ORA_DISK_1
  274. channel ORA_DISK_1: starting archived log backup set
  275. channel ORA_DISK_1: specifying archived log(s) in backup set
  276. input archived log thread=1 sequence=197 RECID=306 STAMP=1013176398
  277. channel ORA_DISK_1: starting piece 1 at 09-JUL-19
  278. channel ORA_DISK_1: finished piece 1 at 09-JUL-19
  279. piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135318_gl901h3z_.bkp tag=TAG20190709T135318 comment=NONE
  280. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  281. channel ORA_DISK_1: deleting archived log(s)
  282. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_197_gl901gmt_.arc RECID=306 STAMP=1013176398
  283. Finished backup at 09-JUL-19
  284.  
  285. Starting Control File and SPFILE Autobackup at 09-JUL-19
  286. piece handle=/fra/MIN19_O71/autobackup/2019_07_09/o1_mf_s_1013176400_gl901jl6_.bkp comment=NONE
  287. Finished Control File and SPFILE Autobackup at 09-JUL-19
  288.  
  289. RMAN> exit
  290.  
  291.  
  292. Recovery Manager complete.
  293. [oracle@o71 ~]$ sqlplus / as sysdba
  294.  
  295. SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 9 13:53:26 2019
  296. Version 19.3.0.0.0
  297.  
  298. Copyright (c) 1982, 2019, Oracle. All rights reserved.
  299.  
  300.  
  301. Connected to:
  302. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  303. Version 19.3.0.0.0
  304.  
  305. SQL> shu immediate
  306. Database closed.
  307. Database dismounted.
  308. ORACLE instance shut down.
  309. SQL> startup mount
  310. ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
  311. ORACLE instance started.
  312.  
  313. Total System Global Area 536868920 bytes
  314. Fixed Size 8898616 bytes
  315. Variable Size 339738624 bytes
  316. Database Buffers 180355072 bytes
  317. Redo Buffers 7876608 bytes
  318. Database mounted.
  319. SQL> exit
  320. Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  321. Version 19.3.0.0.0
  322. [oracle@o71 ~]$ rman target /
  323.  
  324. Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 9 13:54:17 2019
  325. Version 19.3.0.0.0
  326.  
  327. Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
  328.  
  329. connected to target database: MIN19 (DBID=2116532768, not open)
  330.  
  331. RMAN> list backup of datafile 1 summary;
  332.  
  333. using target database control file instead of recovery catalog
  334.  
  335. List of Backups
  336. ===============
  337. Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
  338. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
  339. 29 B 0 A DISK 09-JUL-19 1 1 NO TAG20190709T135047
  340. 33 B 1 A DISK 09-JUL-19 1 1 NO TAG20190709T135137
  341. 37 B 0 A DISK 09-JUL-19 1 1 NO TAG20190709T135241
  342. 41 B 1 A DISK 09-JUL-19 1 1 NO TAG20190709T135315
  343.  
  344. RMAN> report schema;
  345.  
  346. Report of database schema for database with db_unique_name MIN19_O71
  347.  
  348. List of Permanent Datafiles
  349. ===========================
  350. File Size(MB) Tablespace RB segs Datafile Name
  351. ---- -------- -------------------- ------- ------------------------
  352. 1 1330 SYSTEM *** /oradata/MIN19_O71/system01.dbf
  353. 2 1170 SYSAUX *** /oradata/MIN19_O71/sysaux01.dbf
  354. 3 7845 UNDOTBS1 *** /oradata/MIN19_O71/undotbs01.dbf
  355. 4 1285 USERS *** /oradata/MIN19_O71/users01.dbf
  356.  
  357. List of Temporary Files
  358. =======================
  359. File Size(MB) Tablespace Maxsize(MB) Tempfile Name
  360. ---- -------- -------------------- ----------- --------------------
  361. 1 16384 TEMP 12147 /oradata/MIN19_O71/temp01.dbf
  362.  
  363. RMAN> exit
  364.  
  365.  
  366. Recovery Manager complete.
  367. rm[oracle@o71 ~]$
  368. [oracle@o71 ~]$ rm /oradata/MIN19_O71/system01.dbf
  369. [oracle@o71 ~]$ rman target /
  370.  
  371. Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 9 13:54:37 2019
  372. Version 19.3.0.0.0
  373.  
  374. Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
  375.  
  376. connected to target database: MIN19 (DBID=2116532768, not open)
  377.  
  378. RMAN> restore datafile 1 from tag TAG20190709T135047;
  379.  
  380. Starting restore at 09-JUL-19
  381. using channel ORA_DISK_1
  382.  
  383. channel ORA_DISK_1: starting datafile backup set restore
  384. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
  385. channel ORA_DISK_1: restoring datafile 00001 to /oradata/MIN19_O71/system01.dbf
  386. channel ORA_DISK_1: reading from backup piece /fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd0_TAG20190709T135047_gl8zwqd5_.bkp
  387. channel ORA_DISK_1: piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd0_TAG20190709T135047_gl8zwqd5_.bkp tag=TAG20190709T135047
  388. channel ORA_DISK_1: restored backup piece 1
  389. channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
  390. Finished restore at 09-JUL-19
  391.  
  392. RMAN> recover datafile 1;
  393.  
  394. Starting recover at 09-JUL-19
  395. using channel ORA_DISK_1
  396. channel ORA_DISK_1: starting incremental datafile backup set restore
  397. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
  398. destination for restore of datafile 00001: /oradata/MIN19_O71/system01.dbf
  399. channel ORA_DISK_1: reading from backup piece /fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd1_TAG20190709T135137_gl8zy9ls_.bkp
  400. channel ORA_DISK_1: piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_nnnd1_TAG20190709T135137_gl8zy9ls_.bkp tag=TAG20190709T135137
  401. channel ORA_DISK_1: restored backup piece 1
  402. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
  403.  
  404. starting media recovery
  405.  
  406. channel ORA_DISK_1: starting archived log restore to default destination
  407. channel ORA_DISK_1: restoring archived log
  408. archived log thread=1 sequence=193
  409. channel ORA_DISK_1: reading from backup piece /fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135140_gl8zyf4j_.bkp
  410. channel ORA_DISK_1: piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135140_gl8zyf4j_.bkp tag=TAG20190709T135140
  411. channel ORA_DISK_1: restored backup piece 1
  412. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
  413. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_193_gl9051jh_.arc thread=1 sequence=193
  414. channel default: deleting archived log(s)
  415. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_193_gl9051jh_.arc RECID=307 STAMP=1013176513
  416. channel ORA_DISK_1: starting archived log restore to default destination
  417. channel ORA_DISK_1: restoring archived log
  418. archived log thread=1 sequence=194
  419. channel ORA_DISK_1: reading from backup piece /fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135239_gl900857_.bkp
  420. channel ORA_DISK_1: piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135239_gl900857_.bkp tag=TAG20190709T135239
  421. channel ORA_DISK_1: restored backup piece 1
  422. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
  423. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_194_gl9052t9_.arc thread=1 sequence=194
  424. channel default: deleting archived log(s)
  425. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_194_gl9052t9_.arc RECID=308 STAMP=1013176515
  426. channel ORA_DISK_1: starting archived log restore to default destination
  427. channel ORA_DISK_1: restoring archived log
  428. archived log thread=1 sequence=195
  429. channel ORA_DISK_1: reading from backup piece /fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135307_gl901390_.bkp
  430. channel ORA_DISK_1: piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135307_gl901390_.bkp tag=TAG20190709T135307
  431. channel ORA_DISK_1: restored backup piece 1
  432. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
  433. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_195_gl90545h_.arc thread=1 sequence=195
  434. channel default: deleting archived log(s)
  435. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_195_gl90545h_.arc RECID=309 STAMP=1013176516
  436. media recovery complete, elapsed time: 00:00:00
  437. channel ORA_DISK_1: starting archived log restore to default destination
  438. channel ORA_DISK_1: restoring archived log
  439. archived log thread=1 sequence=196
  440. channel ORA_DISK_1: reading from backup piece /fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135313_gl901b0p_.bkp
  441. channel ORA_DISK_1: piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135313_gl901b0p_.bkp tag=TAG20190709T135313
  442. channel ORA_DISK_1: restored backup piece 1
  443. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
  444. channel default: deleting archived log(s)
  445. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_196_gl9055kx_.arc RECID=310 STAMP=1013176517
  446. channel ORA_DISK_1: starting archived log restore to default destination
  447. channel ORA_DISK_1: restoring archived log
  448. archived log thread=1 sequence=197
  449. channel ORA_DISK_1: reading from backup piece /fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135318_gl901h3z_.bkp
  450. channel ORA_DISK_1: piece handle=/fra/MIN19_O71/backupset/2019_07_09/o1_mf_annnn_TAG20190709T135318_gl901h3z_.bkp tag=TAG20190709T135318
  451. channel ORA_DISK_1: restored backup piece 1
  452. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
  453. channel default: deleting archived log(s)
  454. archived log file name=/fra/MIN19_O71/archivelog/2019_07_09/o1_mf_1_197_gl9056s0_.arc RECID=311 STAMP=1013176518
  455. Finished recover at 09-JUL-19
  456.  
  457. RMAN>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!