Can you restore oracle using only hot <online, noarchive mode!> backups?
Posted on 2004-09-29
Using Arcserve, our Oracle system <win2k server> is backed up nightly. The database is never closed during this time but the CA BAOF agent is active on that server. The database is running in noarchive mode. For piece of mind I decided to put the backup tapes into practice and perform a restore on a test win2k server box. Bloody good job Ive done this exercise because I cant manage to get Oracle to function correctly using the backed up datafiles.
After installing Oracle 8i and restoring the backed up datafiles into place oracle was able to mount without an issue but when attempting to fully open, it displays:
ORA-01122 Failed Validation check
ORA-01110 on QTEMP1.DBF
ORA-01207 File is more recent than controlfile - old controlfile
After viewing many FAQ pages I performed a recover database until cancel using backup of controlfiles and it completed but displaying this:
ORA-01194 File 1 needs to be more consistent
ORA-01110 Data file 1 /oracle/oradata/system01.DBF
Then I attempted to startup again using alter database open resetlogs now I continue to get the same message as above!
I then added _allow_resetlog_corruption = true in my Pfile and tried to startup and it fails with:
ORA-00603 Fatal Error
I used the DBV tool and checked my datafiles and it comes up with:
"Blocksize 2048 differs from actual 8192" on all my DBF/CTL files
I then removed the new line out of my Pfile and tried again and miraculously the database opened and I am able to view the instance, schema, datafiles, tablespace etc apart from the SGA parameters. At this point I attempted to connect via sqlplus but it comes up with:
ORA-01033 Initialisation or shutdown in progress and it wont permit the login
Is what Im trying to achieve still feasible or do I need to re-think by backup strategy to include archivemode and full exports of the database?
Any advise particularly on my technical issue but also on backup strategy would be greatly appreciated