RMAN Backup and Recovery scenarios

The following notes will illustrate the steps required to recover from a number of common failure scenarios that a DBA could possibly face in his career. RMAN Restore on another machine with different file system- same database name RMAN duplicate database on the same host Loss Of All Files – Disaster Recovery Incomplete Recovery (until […]

Recovery from a backup taken before a RESETLOGS

Simulate loss of redo log files [oracle@itlinuxdevblade08 opsdba]$ rm redo*.log Check alert log Errors in file /u02/ORACLE/opsdba/bdump/opsdba_arc1_29898.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ‘/u02/ORACLE/opsdba/redo01.log’ ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Wed Jun […]

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?