I have a database that was created from an OS snapshot of production. This snapshot is run during the hot backup. When the "copied" database was created, I performed a startup and received the message
"ORA-10873: file 1 needs to be either taken out of backup mode or media recovered"
I found this solution online:
Solution:
Step 1 : Sqlplus ‘/as sysdba’
Step 2 : startup mount
Step 3 : Check backup file using below command.
select * from V$BACKUP
Step 4 : The following command can be used to take all of the data files out of hot backup mode:
ALTER DATABASE END BACKUP;
Step 5 : Alter database open
Which I performed and it worked.
However another DBA team member has indicated that it should have been media recovered, not just taken out of backup mode as follows:
STARTUP MOUNT
RECOVER AUTOMATIC DATABASE
ALTER DATABASE OPEN;
So is there a preferred method for this? If the database is not recovered does it have something missing or corrupt?
The servers involved are HPUX ia64 11.31
Oracle database version: 11.2.0.3