Recovery from Loss of Data files on the Primary Database

Recovery from Loss of Data files on the Primary Database

When you use user base backup you must have ensure the following things

·         Should be have rman full backup  (it enough dally rman full backup with archivelogs)

·         Oracle database must be  run on archive log  mode

When you open the database its giving following error if data file is missing or corrupted

Error has come when open the DB

SQL>startup force;

ORACLE instance started.

Total System Global Area 1043886080 bytes

Fixed Size                  2219952 bytes

Variable Size             767557712 bytes

Database Buffers          268435456 bytes

Redo Buffers                5672960 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 4 - see DBWR trace file

ORA-01110: data file 4: '/u01/app/oracle/oradata/TEST/users01.dbf'

Restore and recover data file from RMAN backup pieces

1.   rman target /

2.   RESTORE datafile '/u01/app/oracle/oradata/TEST/users01.dbf';

3.   RECOVER DATAFILE '/u01/app/oracle/oradata/TEST/users01.dbf'

SQL>startup force;

ORACLE instance started.

Total System Global Area 1043886080 bytes

Fixed Size                  2219952 bytes

Variable Size             767557712 bytes

Database Buffers          268435456 bytes

Redo Buffers                5672960 bytes

Database mounted.

Database opened.

Data file status

select file_id, file_name, tablespace_name, online_status from dba_data_files;

Reference

http://docs.oracle.com/cd/B19306_01/server.102/b14239/rman.htm