This in an Oracle 126.96.36.199.0 64 bits
After a restore from cold backup I get this when trying to start DB:
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle1/oradata/ardlpdev/system_01.dbf'
Autobackup of controlfile is off, and DB is in NOARCHIVELOG (that's why I have a cold backup).
What´s the problem?
I started the process by doing this:
restore database from tag 'TAGXXXXXXXXX';
Should I bring an old control file before starting the restore?
I don't have it and it seems it was not included in cold backup.
Solved, just restore control file from rman backup and DB opened.
Edited by: 951854 on 19-abr-2013 9:15