Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Recovery Manager (RMAN)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 19, 2013 11:16 AM by
file 1 needs media recovery after restore from COLD backup
Apr 19, 2013 11:16 AM
This in an Oracle 22.214.171.124.0 64 bits
After a restore from
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
This content has been marked as final.
Show 0 replies