| DBverify Vs RMAN Validate [message #394393] |
Thu, 26 March 2009 14:52  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi all,
Which one is better between the dbverify and the RMAN Validate command. I read that with dbv , the datafiles become in a read-only mode while checking for block corruption . And what if any transactions happen during running dbv? And does the datafile become in a read-only mode during the RMAN validate option.
And when we come to the RMAN > backup validate database. what happens during this time . DOes it backup the database and populate any corrupted blocks in the V$DATABASE_BLOCK_CORRUPTION view when we run the above command.
And is it mandatory that we specify the below init.ora paramters before running the validate command:
DB_BLOCK_CHECKING=TRUE
DB_BLOCK_CHECKSUM=TRUE
And I guess there will be some overhead when we set the above parameters.
Kindly clear my doubts on this.
Regards,
Raj
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
