Oracle corrupted Block recovery (Physical Block Corruption)

Hello Friend's,

In this post we will talk about block corruption.

What is Physical Block corruption will talk about physical one :

PHYSICAL CORRUPTION Also called media corruption Inconsistency between header and footer is one of the symptom of physical corruption. There can be an invalid checksum or header, or when the block contains all zeroes. Generally the result of infrastructure problems like OS/Storage issues, faulty disks/disks controllers, Memory issues. Oracle Recovery Manager’s BLOCKRECOVER command can help in recovering from Physical Corruption

How to check Physical block corruption :

Alert log is important source to capture the database block corruption related information. There are two important Oracle tools to identify corruption:

1) RMAN

2) DBVerify (DBV)

3) LEGACY EXPORT METHOD

4) ANALYZE VALIDATE STRUCTURE

5) V$DATABASE_BLOCK_CORRUPTION

In our case we have 3 corrupted blocks on diff datafiles , So Let's get started


[oracle@DM01DB01 trace]$
[oracle@DM01DB01 trace]$
[oracle@DM01DB01 trace]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Aug 1 03:35:31 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> desc V$DATABASE_BLOCK_CORRUPTION
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE#                                              NUMBER
 BLOCK#                                             NUMBER
 BLOCKS                                             NUMBER
 CORRUPTION_CHANGE#                                 NUMBER
 CORRUPTION_TYPE                                    VARCHAR2(9)
 CON_ID                                             NUMBER

SQL> select FILE#,BLOCK#,BLOCKS,CORRUPTION_TYPE from V$DATABASE_BLOCK_CORRUPTION;

     FILE#     BLOCK#     BLOCKS CORRUPTIO
---------- ---------- ---------- ---------
        93     246638          1 CORRUPT
		93     933833          1 CORRUPT
	   120     576638          1 FRACTURED

SQL>

Use of DBV to check corruption :


[oracle@DM01DB01 trace]$ dbv file='/oradata/FINDB/DATA/FINDB/datafile/SCRATCH_04.DBF';

DBVERIFY: Release 12.2.0.1.0 - Production on Sat Jul 31 20:51:30 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = /oradata/FINDB/DATA/FINDB/datafile/SCRATCH_04.DBF

DBV-00200: Block, DBA 390316910, already marked corrupt

DBV-00200: Block, DBA 391004105, already marked corrupt


DBVERIFY - Verification complete

Total Pages Examined         : 2560000
Total Pages Processed (Data) : 276033
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 2232464
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 17222
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 34281
Total Pages Marked Corrupt   : 2
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 10492410138215 (2442.4100001383)

Recover the corrupted blocks :


[oracle@DM01DB01 trace]$ rman catalog rman/Password@catalogdb target /

Recovery Manager: Release 12.2.0.1.0 - Production on Sat Jul 31 23:18:28 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: FINDB (DBID=2203094740)
connected to recovery catalog database
recovery catalog schema version 18.04.00.00. is newer than RMAN version

RMAN> BLOCKRECOVER DATAFILE 93 BLOCK 933833;

Starting recover at 31-JUL-21
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=224 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Database Application Agent Oracle v4.7.0.0
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=220 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Database Application Agent Oracle v4.7.0.0
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=200 device type=DISK

channel ORA_SBT_TAPE_1: restoring block(s)
channel ORA_SBT_TAPE_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00093
channel ORA_SBT_TAPE_1: reading from backup piece INCR0_FINDB_FINDB_DB_2c054cq3_27724_1
channel ORA_SBT_TAPE_1: piece handle=INCR0_FINDB_FINDB_DB_2c054cq3_27724_1 tag=TAG20210728T220135
channel ORA_SBT_TAPE_1: restored block(s) from backup piece 1
channel ORA_SBT_TAPE_1: block restore complete, elapsed time: 02:39:46

starting media recovery

archived log for thread 1 with sequence 110536 is already on disk as file /orafra/FINDB/FINDB/Archive/1_110536_1029242340.dbf
archived log for thread 1 with sequence 110537 is already on disk as file /orafra/FINDB/FINDB/Archive/1_110537_1029242340.dbf
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110248
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110249
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110250
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110251
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110252
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110253
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110254
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110255
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110256
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110257
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110258
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110259
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110260
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110261
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110262
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_3m058iab_1_1_1079265611
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_3m058iab_1_1_1079265611 tag=TAG20210730T120011
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:15
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110263
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110264
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110265
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110266
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110267
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110268
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110269
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110270
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110271
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110272
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110273
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110274
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110275
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110276
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110277
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110278
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_3p0590ce_1_1_1079280014
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_3p0590ce_1_1_1079280014 tag=TAG20210730T160014
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110251
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110254
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110257
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110260
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110261
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110262
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_3m058iab_1_1_1079265611
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_3m058iab_1_1_1079265611 tag=TAG20210730T120011
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110279
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110280
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110281
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110282
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110283
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110284
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110285
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110286
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110287
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110288
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110289
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110290
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110291
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110292
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110293
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110294
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_3q0590ce_1_1_1079280014
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_3q0590ce_1_1_1079280014 tag=TAG20210730T160014
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:05
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110295
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110296
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110297
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110298
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110299
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110300
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110301
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110302
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110303
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110304
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110305
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110306
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110307
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110308
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110309
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110310
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_3t059eec_1_1_1079294412
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_3t059eec_1_1_1079294412 tag=TAG20210730T200012
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110311
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110312
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110313
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110314
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110315
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110316
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110317
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110318
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110319
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110320
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110321
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110322
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110323
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110324
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110325
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_3u059eec_1_1_1079294412
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_3u059eec_1_1_1079294412 tag=TAG20210730T200012
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110326
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110327
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110328
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110329
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110330
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110331
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110332
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110333
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110334
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110335
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110336
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110337
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110338
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110339
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110340
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110341
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_41059sgm_1_1_1079308822
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_41059sgm_1_1_1079308822 tag=TAG20210731T000022
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110311
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110312
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110314
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110318
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110320
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110321
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110322
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110323
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_3u059eec_1_1_1079294412
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_3u059eec_1_1_1079294412 tag=TAG20210730T200012
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110342
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110343
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110344
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110345
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110346
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110347
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110348
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110349
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110350
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110351
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110352
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110353
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110354
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110355
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110356
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110357
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_42059sgm_1_1_1079308822
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_42059sgm_1_1_1079308822 tag=TAG20210731T000022
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110326
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110330
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110332
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110333
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110336
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110338
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110339
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110341
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_41059sgm_1_1_1079308822
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_41059sgm_1_1_1079308822 tag=TAG20210731T000022
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110358
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110359
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110360
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110361
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110362
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110363
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110364
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110365
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110366
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110367
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110368
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110369
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110370
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110371
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110372
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110373
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110374
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110375
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110376
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110377
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4505aaid_1_1_1079323213
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4505aaid_1_1_1079323213 tag=TAG20210731T040013
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110378
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110379
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110380
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110381
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110382
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110383
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110384
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110385
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110386
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110387
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110388
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110389
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110390
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110391
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110392
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110393
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110394
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110395
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110396
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110397
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4605aaid_1_1_1079323213
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4605aaid_1_1_1079323213 tag=TAG20210731T040013
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:05
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110398
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110399
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110400
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110401
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110402
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110403
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110404
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110405
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110406
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110407
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110408
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110409
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110410
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110411
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110412
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110413
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110414
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110415
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4905aokh_1_1_1079337617
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4905aokh_1_1_1079337617 tag=TAG20210731T080017
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110416
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110417
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110418
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110419
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110420
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110421
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110422
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110423
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110424
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110425
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110426
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110427
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110428
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110429
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110430
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110431
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110432
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4a05aokh_1_1_1079337617
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4a05aokh_1_1_1079337617 tag=TAG20210731T080017
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:05
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110398
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110400
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110402
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110404
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110405
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110407
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110409
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110411
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4905aokh_1_1_1079337617
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4905aokh_1_1_1079337617 tag=TAG20210731T080017
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110433
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110434
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110435
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110436
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110437
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110438
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110439
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110440
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110441
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110442
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110443
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110444
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110445
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110446
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110447
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110448
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4d05b6md_1_1_1079352013
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4d05b6md_1_1_1079352013 tag=TAG20210731T120013
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110449
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110450
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110451
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110452
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110453
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110454
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110455
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110456
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110457
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110458
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110459
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110460
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110461
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110462
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110463
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4e05b6me_1_1_1079352014
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4e05b6me_1_1_1079352014 tag=TAG20210731T120013
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:05
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110464
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110465
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110466
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110467
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110468
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110469
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110470
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110471
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110472
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110473
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110474
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110475
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110476
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110477
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110478
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110479
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4h05bkoa_1_1_1079366410
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4h05bkoa_1_1_1079366410 tag=TAG20210731T160010
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:15
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110480
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110481
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110482
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110483
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110484
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110485
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110486
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110487
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110488
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110489
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110490
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110491
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110492
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110493
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110494
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110495
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4i05bkoa_1_1_1079366410
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4i05bkoa_1_1_1079366410 tag=TAG20210731T160010
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110496
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110497
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110498
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110499
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110500
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110501
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110502
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110503
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110504
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110505
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110506
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110507
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110508
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110509
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110510
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110511
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110512
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110513
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110514
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110515
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_5105cgsm_1_1_1079395222
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_5105cgsm_1_1_1079395222 tag=TAG20210801T000020
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110481
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110483
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110484
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110487
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110490
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110491
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110493
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110494
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_4i05bkoa_1_1_1079366410
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_4i05bkoa_1_1_1079366410 tag=TAG20210731T160010
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110516
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110517
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110518
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110519
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110520
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110521
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110522
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110523
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110524
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110525
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110526
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110527
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110528
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110529
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110530
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110531
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110532
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_5005cgsl_1_1_1079395221
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_5005cgsl_1_1_1079395221 tag=TAG20210801T000020
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110533
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110534
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=110535
channel ORA_SBT_TAPE_1: reading from backup piece FINDB_arc_FINDB_5205ch45_1_1_1079395461
channel ORA_SBT_TAPE_1: piece handle=FINDB_arc_FINDB_5205ch45_1_1_1079395461 tag=TAG20210801T000020
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:07
media recovery complete, elapsed time: 00:00:25
Finished recover at 01-AUG-21

Recovery Manager complete.
Previous
Next Post »