RMAN : Restore rman backup using PITR timestamp recovery
Scenario: Recently we got request from application team as there teamcenter plm app got corrupted about revert database to particular time. As it was test development database for them and strictly told by them to not to take backup due to space crunch storage issue. But luckily we took rman backup 15 days back for our own purpose and we recover database to certain point of time using 15 days back rman backup.
- Start database in mount stage as controlfile recovery not required
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2936012800 bytes
Fixed Size 2928728 bytes
Variable Size 1711280040 bytes
Database Buffers 1207959552 bytes
Redo Buffers 13844480 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
- Connect to the rman console and set time for PITR
oracle@SGDCPLM12:~> rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Dec 6 13:07:24 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: TC12CATI (DBID=3808414881, not open)
RMAN> run
2> {
3> allocate channel dev1 type disk;
4> set until time "to_date('2021-12-03:22:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
5> restore database;
6> recover database;
7> }
using target database control file instead of recovery catalog
allocated channel: dev1
channel dev1: SID=9586 device type=DISK
executing command: SET until clause
Starting restore at 06-DEC-21
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00004 to /u01/oracle_datafile/idata01.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0p0e7g3o_25_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0p0e7g3o_25_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:08:15
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00002 to /home/oracle/app/oracle/oradata/TC12CATIAENV/sysaux01.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0q0e7gf5_26_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0q0e7gf5_26_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:25
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00003 to /home/oracle/app/oracle/oradata/TC12CATIAENV/undotbs01.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0r0e7gfu_27_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0r0e7gfu_27_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:03
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00001 to /home/oracle/app/oracle/oradata/TC12CATIAENV/system01.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0s0e7gfv_28_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0s0e7gfv_28_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:15
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00005 to /home/oracle/app/oracle/oradata/TC12CATIAENV/ilog01.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0t0e7gge_29_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0t0e7gge_29_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:07
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00006 to /home/oracle/app/oracle/oradata/TC12CATIAENV/indx01.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0u0e7ggh_30_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0u0e7ggh_30_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:01
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00007 to /home/oracle/app/oracle/product/12.1.0/dbhome_1/tcmanager.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0v0e7ggi_31_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0v0e7ggi_31_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:01
channel dev1: starting datafile backup set restore
channel dev1: specifying datafile(s) to restore from backup set
channel dev1: restoring datafile 00008 to /home/oracle/app/oracle/product/12.1.0/dbhome_1/tccatenvmanager.dbf
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_100e7ggj_32_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_100e7ggj_32_1_20211115 tag=FULL_BACKUP_DAILY
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:01
Finished restore at 06-DEC-21
Starting recover at 06-DEC-21
starting media recovery
archived log for thread 1 with sequence 188 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_188_js5lm5o2_.arc
archived log for thread 1 with sequence 189 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_189_js5pks7f_.arc
archived log for thread 1 with sequence 190 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_190_js76cxkp_.arc
archived log for thread 1 with sequence 191 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_191_js86z24b_.arc
archived log for thread 1 with sequence 192 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_192_js8ktooq_.arc
archived log for thread 1 with sequence 193 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_193_js9tr2p8_.arc
archived log for thread 1 with sequence 194 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_194_jsbvc5n5_.arc
archived log for thread 1 with sequence 195 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_195_jsd5v7g9_.arc
archived log for thread 1 with sequence 196 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_196_jsfhq802_.arc
archived log for thread 1 with sequence 197 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_197_jsfmw9l9_.arc
archived log for thread 1 with sequence 198 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_198_jsj430p1_.arc
archived log for thread 1 with sequence 199 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_199_jsj8b06m_.arc
archived log for thread 1 with sequence 200 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_200_jsk07gsy_.arc
archived log for thread 1 with sequence 201 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_201_jslbmpc3_.arc
archived log for thread 1 with sequence 202 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_202_jslwqx1f_.arc
archived log for thread 1 with sequence 203 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_203_jsmrfv4m_.arc
archived log for thread 1 with sequence 204 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_204_jsnn83qn_.arc
archived log for thread 1 with sequence 205 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_205_jsofcs3t_.arc
archived log for thread 1 with sequence 206 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_206_jspmjxwq_.arc
archived log for thread 1 with sequence 207 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_207_jsr174xx_.arc
archived log for thread 1 with sequence 208 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_208_jsr5nggy_.arc
archived log for thread 1 with sequence 209 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_209_jsso1d0z_.arc
archived log for thread 1 with sequence 210 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_210_jstomc70_.arc
archived log for thread 1 with sequence 211 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_211_jsv3npx6_.arc
archived log for thread 1 with sequence 212 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_212_jsw9fk3r_.arc
archived log for thread 1 with sequence 213 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_213_jsxb08wr_.arc
archived log for thread 1 with sequence 214 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_214_jsxgjttm_.arc
archived log for thread 1 with sequence 215 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_215_jszmw7l6_.arc
archived log for thread 1 with sequence 216 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_216_jszyfbpw_.arc
archived log for thread 1 with sequence 217 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_217_jt11gp4l_.arc
archived log for thread 1 with sequence 218 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_218_jt2lprkl_.arc
archived log for thread 1 with sequence 219 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_219_jt2lrnos_.arc
archived log for thread 1 with sequence 220 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_220_jt3gtx9h_.arc
archived log for thread 1 with sequence 221 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_221_jt3xzosc_.arc
archived log for thread 1 with sequence 222 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_222_jt57p1fb_.arc
archived log for thread 1 with sequence 223 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_223_jt5g4xdg_.arc
archived log for thread 1 with sequence 224 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_224_jt6fsmld_.arc
archived log for thread 1 with sequence 225 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_225_jt7fg8q5_.arc
archived log for thread 1 with sequence 226 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_226_jt809m3y_.arc
archived log for thread 1 with sequence 227 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_227_jt9dqm0k_.arc
archived log for thread 1 with sequence 228 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_228_jtbhvl2t_.arc
archived log for thread 1 with sequence 229 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_229_jtbnqv1h_.arc
archived log for thread 1 with sequence 230 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_230_jtcmymkl_.arc
archived log for thread 1 with sequence 231 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_231_jtdrt30b_.arc
archived log for thread 1 with sequence 232 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_232_jtf48vgw_.arc
archived log for thread 1 with sequence 233 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_233_jtg3029v_.arc
archived log for thread 1 with sequence 234 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_234_jthg2k86_.arc
archived log for thread 1 with sequence 235 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_235_jthxmhpq_.arc
archived log for thread 1 with sequence 236 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_236_jtkfbpk3_.arc
archived log for thread 1 with sequence 237 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_237_jtldzq8x_.arc
archived log for thread 1 with sequence 238 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_238_jtll0mcs_.arc
archived log for thread 1 with sequence 239 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_239_jtn4mmhq_.arc
archived log for thread 1 with sequence 240 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_240_jto1cvbw_.arc
channel dev1: starting archived log restore to default destination
channel dev1: restoring archived log
archived log thread=1 sequence=187
channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_130e7ggo_35_1_20211115
channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_130e7ggo_35_1_20211115 tag=TAG20211115T074944
channel dev1: restored backup piece 1
channel dev1: restore complete, elapsed time: 00:00:55
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_06/o1_mf_1_187_jtvzw15r_.arc thread=1 sequence=187
channel default: deleting archived log(s)
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_06/o1_mf_1_187_jtvzw15r_.arc RECID=184 STAMP=1090588689
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_188_js5lm5o2_.arc thread=1 sequence=188
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_189_js5pks7f_.arc thread=1 sequence=189
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_190_js76cxkp_.arc thread=1 sequence=190
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_191_js86z24b_.arc thread=1 sequence=191
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_192_js8ktooq_.arc thread=1 sequence=192
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_193_js9tr2p8_.arc thread=1 sequence=193
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_194_jsbvc5n5_.arc thread=1 sequence=194
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_195_jsd5v7g9_.arc thread=1 sequence=195
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_196_jsfhq802_.arc thread=1 sequence=196
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_197_jsfmw9l9_.arc thread=1 sequence=197
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_198_jsj430p1_.arc thread=1 sequence=198
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_199_jsj8b06m_.arc thread=1 sequence=199
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_200_jsk07gsy_.arc thread=1 sequence=200
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_201_jslbmpc3_.arc thread=1 sequence=201
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_202_jslwqx1f_.arc thread=1 sequence=202
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_203_jsmrfv4m_.arc thread=1 sequence=203
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_204_jsnn83qn_.arc thread=1 sequence=204
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_205_jsofcs3t_.arc thread=1 sequence=205
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_206_jspmjxwq_.arc thread=1 sequence=206
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_207_jsr174xx_.arc thread=1 sequence=207
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_208_jsr5nggy_.arc thread=1 sequence=208
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_209_jsso1d0z_.arc thread=1 sequence=209
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_210_jstomc70_.arc thread=1 sequence=210
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_211_jsv3npx6_.arc thread=1 sequence=211
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_212_jsw9fk3r_.arc thread=1 sequence=212
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_213_jsxb08wr_.arc thread=1 sequence=213
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_214_jsxgjttm_.arc thread=1 sequence=214
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_215_jszmw7l6_.arc thread=1 sequence=215
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_216_jszyfbpw_.arc thread=1 sequence=216
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_217_jt11gp4l_.arc thread=1 sequence=217
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_218_jt2lprkl_.arc thread=1 sequence=218
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_219_jt2lrnos_.arc thread=1 sequence=219
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_220_jt3gtx9h_.arc thread=1 sequence=220
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_221_jt3xzosc_.arc thread=1 sequence=221
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_222_jt57p1fb_.arc thread=1 sequence=222
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_223_jt5g4xdg_.arc thread=1 sequence=223
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_224_jt6fsmld_.arc thread=1 sequence=224
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_225_jt7fg8q5_.arc thread=1 sequence=225
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_226_jt809m3y_.arc thread=1 sequence=226
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_227_jt9dqm0k_.arc thread=1 sequence=227
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_228_jtbhvl2t_.arc thread=1 sequence=228
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_229_jtbnqv1h_.arc thread=1 sequence=229
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_230_jtcmymkl_.arc thread=1 sequence=230
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_231_jtdrt30b_.arc thread=1 sequence=231
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_232_jtf48vgw_.arc thread=1 sequence=232
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_233_jtg3029v_.arc thread=1 sequence=233
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_234_jthg2k86_.arc thread=1 sequence=234
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_235_jthxmhpq_.arc thread=1 sequence=235
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_236_jtkfbpk3_.arc thread=1 sequence=236
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_237_jtldzq8x_.arc thread=1 sequence=237
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_238_jtll0mcs_.arc thread=1 sequence=238
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_239_jtn4mmhq_.arc thread=1 sequence=239
archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_240_jto1cvbw_.arc thread=1 sequence=240
media recovery complete, elapsed time: 00:03:03
Finished recover at 06-DEC-21
released channel: dev1
RMAN>
- Open database in resetlogs option and take the fresh RMAN backup
RMAN> alter database open resetlogs;
Statement processed
No comments:
Post a Comment