Auditing backup disks and Oracle data files

You should regularly schedule audits of the backup disks to make sure that they are not corrupt and that they contain a full backup. You can audit:

Note:
Note:
Only disk backups are supported with Oracle on Windows.

To audit Flashbackups

Log in as the oracle user.
Change to the /usr/mvf/bin directory.
Run flashbackup verify.
This performs a checksum on the tape.
Repeat the previous step until you see the listing of the archived redo log files.

To audit disk backups and Oracle data files using RMAN

On Solaris, login as the oracle user.
On Windows, log in as the AgfaService user.
In a command prompt, to run RMAN, type

rman target /
To check for any physical corruption in the data files, from the RMAN prompt, run the following command:

backup validate database archivelog all;

Look for any error messages from RMAN that might indicate a problem with the data files. For example:
```
ORA-19625: error identifying file /dbase/data1/mvf01.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
```
To check for any logical corruption, from the RMAN prompt, run the following from the command:
backup validate check logical database archivelog all;
Any corruption is recorded in the V$DATABASE_BLOCK_CORRUPTION view. You can check this view by running
sqlplus / as sysdba
select * from V$DATABASE_BLOCK_CORRUPTION;
To validate an existing backup set, from RMAN, run the following command to get a listing of the backup sets:
list backupset;
To validate an existing backup set, run the following command:
validate backupset <backup set #>;