Home > Oracle > validate database and Rman Backups

validate database and Rman Backups

To  validate all datafiles and control files (and the server parameter file if one is in use),execute the following command at the RMAN prompt:

RMAN> VALIDATE DATABASE

For example, you can validate that all database files and archived logs
can be backed up by running a command as shown in the following example.
This command checks for physical corruptions only.

rman> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

To check for logical corruptions in addition to physical corruptions,
run the following variation of the preceding command:

rman> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

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: