Apr 11, 2013
RMAN Restore and Recovery Scenarios
849

RMAN Restore and Recovery Scenarios

RMAN Restore and Recovery Scenarios: RESTORE AND RECOVERY SCENARIOS: Full Database Restore $ORACLE_HOME/bin/rman target / nocatalog RMAN> shutdown abort; RMAN> startup mount; RMAN> restore database; RMAN> recover database; RMAN> alter database open; Tablespace Restore (online) $rman target / nocatalog RMAN> sql ‘alter tablespace users offline’; RMAN> restore tablespace users; RMAN>...
Apr 11, 2013
RMAN Archivelog List Commands
724

RMAN Archivelog List Commands

RMAN Archivelog List Commands RMAN>list archivelog all; RMAN>list copy of archivelog until time ‘SYSDATE-10′; RMAN>list copy of archivelog from time ‘SYSDATE-10′ RMAN>list copy of archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′; RMAN>list copy of archivelog from sequence 1000; RMAN>list copy of archivelog until sequence 1500; RMAN>list copy of archivelog from...
Jun 05, 2012
Oracle – How to purge old RMAN backups
829

Oracle – How to purge old RMAN backups

Oracle – How to purge old RMAN backups Do not use rm to remove files.  You must do it via RMAN. $ export NLS_DATE_FORMAT=’DD-MM-YY HH24:MI’ $ rman target / NOCATALOG RMAN > crosscheck backupset; This command will verify whether backup file is still on media. If it is unavailable, RMAN...
May 05, 2011
RMAN Restore and Recovery Scenarios
671

RMAN Restore and Recovery Scenarios

RMAN Restore and Recovery Scenarios // // Full Database Restore $ORACLE_HOME/bin/rman target / nocatalog RMAN> shutdown abort; RMAN> startup mount; RMAN> restore database; RMAN> recover database; RMAN> alter database open; database opened Tablespace Restore (online) $ORACLE_HOME/bin/rman target / nocatalog RMAN> sql ‘alter tablespace users offline’; RMAN> restore tablespace users; RMAN>...