Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Restore Database Validate for READ ONLY in Oracle10g

Posted by Hendry chinnapparaj on August 22, 2011

Problem

The standard syntax works only for oracle11g, not for oracle10g with regard to Restore Validation of READONLY Tablespaces. It actually skips the readonly tablespaces (validates only read  write)

RESTORE DATABASE VALIDATE FORCE;

Solution

This will validate the read write and then readonly tablespaces.

Run

{

RESTORE DATABASE VALIDATE FORCE;

RESTORE DATABASE VALIDATE FORCE CHECK READONLY;

}

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: