Today, i encountered an issue where i installed the EBS 12.1.1 and tried to take a full rman backup.
First converted the db to archive mode and then tried to take a full rman backup.
Then configured the rman channel to place the backup in disk at the designated location.
RMAN backup error.
thankfully, these corruptions does not belong to any object and hence it will not impact the installtion or db startup.
Reference
=======
1. Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]
First converted the db to archive mode and then tried to take a full rman backup.
RMAN backup error.
To verify the blocks corrupted, we need to run the dbv
command line utility:
[oracle@sam fmw]$ dbv file=/u01/12.1.1/EBS/SOURCE/db/apps_st/data/system09.dbf
DBVERIFY - Verification complete
Total Pages Examined
: 192128
Total Pages Processed (Data) : 52304
Total Pages Failing
(Data) : 0
Total Pages Processed (Index): 26450
Total Pages Failing
(Index): 0
Total Pages Processed (Other): 2123
Total Pages Processed (Seg)
: 0
Total Pages Failing
(Seg) : 0
Total Pages Empty
: 84778
Total Pages Marked Corrupt
: 26473
Total Pages Influx
: 0
Total Pages Encrypted
: 0
Highest block SCN
: 3712725850 (1388.3712725850)
Once you conform through dbv the blocks are corrupted then you need to run the Rman validating script
Rman script to validate
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
backup check logical validate database;
release channel d1;
release channel d2;
release channel d3;
}
it will produce the error in the alert log for all the corrupted blocks it will validate all the blocks corrupted and populate into the v$database_block_corruption Once the Rman command completes then you can proceed to the next step ..it is mandatory to complete this step
Check the no of blocks corrupted
SQL> Select * from v$database_block_corruption ;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTI
---------- ---------- ---------- ------------------ ---------
352 165660 26341 0 ALL ZERO
note the it is the data file number which is effected and the block number
Check the corrupted block belongs to any object
SYNTEX :select segment_name, segment_type, owner
from dba_extents
where file_id = <data_file_name>
and < corrupted block number >between block_id
and block_id + blocks -1;
SQL> select segment_name, segment_type, owner
from dba_extents
where file_id = 352
and 165660 between block_id
and block_id + blocks -1;
It will return now rows selected and then proceed with the steps if it returns now row selected then the particular block does not belongs to any object and it is empty
To conform the empty block run the below query
Then, i performed the below action plan
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 -
64bit Production
With the Partitioning, OLAP, Data Mining and Real
Application Testing options
SQL> alter database datafile
'/u01/12.1.1/EBS/SOURCE/db/apps_st/data/system09.dbf' resize 1056M;
Database altered.
Verified again the count of corrupted objects
[oracle@sam 11.1.0]$ dbv
file=/u01/12.1.1/EBS/SOURCE/db/apps_st/data/system09.dbf
DBVERIFY: Release 11.1.0.7.0 - Production on Sun Jul 3
10:54:10 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE =
/u01/12.1.1/EBS/SOURCE/db/apps_st/data/system09.dbf
DBVERIFY - Verification complete
Total Pages Examined
: 135168
Total Pages Processed (Data) : 104090
Total Pages Failing
(Data) : 0
Total Pages Processed (Index): 26450
Total Pages Failing
(Index): 0
Total Pages Processed (Other): 2124
Total Pages Processed (Seg)
: 0
Total Pages Failing
(Seg) : 0
Total Pages Empty
: 2504
Total Pages Marked Corrupt
: 0
Total Pages Influx
: 0
Total Pages Encrypted
: 0
Highest block SCN
: 3714312362 (1388.3714312362)
[oracle@sam 11.1.0]$
Re initiated the backup again and it completed successfully.
=======
1. Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]
2. More than 20000 Blocks Corrupted in system09.dbf After Fresh Installation of E-Business Suite R12.1.1 on Linux x86_64 Platform [ID 840963.1]
