Posts Tagged: RMAN

[RMAN] Check Backup status (rman)

This script will report on all backups – full, incremental and archivelog backups – col STATUS format a9 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’)   end_time, elapsed_seconds/3600                   hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; This script will report all on full and incremental backups, not archivelog backups – col STATUS

Read on »

Restore RMAN backup to another server (Disaster Recovery)

Restore RMAN Backup to another server with same database SID I hope this would be useful when we have to do periodic testing of disaster recovery procedures where we simulate a scenario when the complete database server has crashed and a new server has been provisioned. The directory structure on the new or target server

Read on »