Restore and Recover the damaged Database
                                                 Last update (2011-07-19 16:57:32)
                                                                                                                   Date added (2011-07-19 12:53:43)

Summary
How to restore and recover the complete database (controlfiles, datafiles, applying archives) until point in time with RMAN. It is used in cases where everything is lost. Of course you must have at least the oracle binaries and the init.ora file.

1. Login as the oracle user and set the environment ($ORACLE_HOME, $ORACLE_SID, $PATH)

2. export NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI'

3. Connect to the RMAN catalog : $>rman TARGET / CATALOG rman/***@RMAN

4. Run the restore.sql script
RUN {
SET UNTIL TIME '19-07-2011 10:00';
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH02 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH03 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=wlrdb';
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
}
5. SQLPLUS>alter database open resetlogs;
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search