RMAN Checks

RMAN Checks

During a particluar fault diagnoses it is prudent to quickly check of the database has a back and status of the backup… first set the environment variables to the database in question (Follow .oraenv section) and the following commands listed will quickly give a synopsis of the backup status.

Connect to the target and catalog. Make sure that NLS_LANG and NLS_DATE_FORMAT is set in the rman environment when rman is run and that NLS_DATE_FORMAT includes timestamp (HH24:MI:SS).


$ rman target / catalog user/name@catalog

RMAN>list backupset summary;

1. The info about db and the backups in the catalog database, connected as rman/backup user and db incarnation set to the db in question (put this output in file list_backup.txt):

RMAN>LIST INCARNATION;

RMAN>LIST BACKUP OF DATABASE SUMMARY;

RMAN>LIST BACKUP;

RMAN>LIST BACKUP BY FILE;


2. The info about archive logs in the backups:

RMAN>LIST ARCHIVELOG ALL;

RMAN>LIST COPY OF DATABASE ARCHIVELOG ALL;

RMAN>LIST BACKUP OF ARCHIVELOG ALL;

RMAN>LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 688321 UNTIL 688363
THREAD 1;

3. The info from the RMAN views in the catalog:

SQL> select * from RC_RESYNC;

SQL>select db_key, dbinc_key, dbid, name from RC_DATABASE;

SQL>select * from RC_BACKUP_REDOLOG;

SQL>select * from RC_ARCHIVED_LOG;


4. The info from the target db:


SQL>select RECID, NAME, SEQUENCE#, ARCHIVED, DELETED, STATUS


5. Block corruptions

Database:

SQL> select * from V$database_block_corruption;

Catalog:

SQL>select * from rc_database_block_corruption;

5. Checking the datafiles status

SQL>select name, open_mode from v$database;

SQL>select * from v$recover_file;

SQL>select name, status from v$datafile;