I am earning RMAN.
For experience purpose, i moved control02.ctl from actual position, and then restore from backup. After restoring successfully, i could not open DB as yet and encountering ORA-01110 error, i need your help to understand mistake on my part and its resolution.
RMAN> restore controlfile from '/u01/app/oracle/fast_recovery_area/TBMDB/backupset/2013_03_26/o1_mf_ncsnf_TAG20130326T164239_8o32h84t_.bkp';
Starting restore at 27-MAR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/tbmdb/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/tbmdb/control02.ctl
Finished restore at 27-MAR-13
$sqlplus / as sysdba
SQL> startup
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2229944 bytes
Variable Size 402655560 bytes
Database Buffers 109051904 bytes
Redo Buffers 7999488 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/tbmdb/system01.dbf'
Edited by: malhi on Mar 27, 2013 11:55 PM