In NOARCHIVELOG mode, there are no archived log file to apply.
You will need to restore ALL databse files from the last valid closed database backup. If you need to restore, say, datafiles to a new location (because the media failure was a disk crash that can't be fixed) then you will need to do an ALTER DATABASE RENAME FILE...TO... command.
All data entered after the time of the previous backup that was just applied will need to be re-entered manually.
Edward Haskins, OCP
OraKnowledge, Inc. www.oraknowledge.com--"Live" Instructor-led Online Training for Oracle9i, Java and XML--
The main reason to do in this case:
recover database until cancel
is not for datafile header or archived log. It is for online log.
when you restore from backup, oracle recommend you not restore online log file. And in order to reset the online log file, you need to open databse resetlogs. In order for you to resetlogs, you need to MIMIC recover database until cancel.
Originally posted by oca9i2002 In order for you to resetlogs, you need to MIMIC recover database until cancel.
Thanks for the response guys.
Does this mean the faked incomplete recovery is mandatory or simply recommended?
If mandatory, what does it actually achieve?
Not being lazy (well not that lazy) just don't have access to a test lab at present.
As an aside, does Oracle have documentation similar to IBM's red books describing how the product actually works rather than how it should work. I'm really after some info on the nuts and bolts on the product.
I am not sure whether it is useful for you, this question appears on my last Saturday 032 exams, although I do not know whether it is a counted question, since there are 73 questions, and only 64 of them are accounted.
As the backup recommended by Oracle for NOARCHIVELOG:
You should backup your datafile and controlfile, not online redo file.
when you restore from a backup, you can only restore datafile and controfile.
your online log can not be used with your restored backup. You have to reset your online log, which can be achived by open database resetlogs.
in order for you to execute open database resetlogs, you need to perform incomplete recovery.
To pass your exam, remember this is recommended.
In your real career, just backup your online redo log, and restore it. In this way, you can open database normal.
I now have my lab back, (That'll teach me to let my son play Tweenie' Fun Time on my Vaio!, crashed the machine and corrupted the registry with no backup ironic, considering the exam.) so I can check check it out myself.
Must have had some clue cos I took the test on Monday and passed with 53/60. Still a bit disappointed as I could only find 3 questions which I thought might be a problem.
It might just be me, but I found it much easier to discount incorrect answers on this exam than A&A or SQL-PL/SQL. One side of me says that quite a number of the questions were too easy.
Gonna take some "beer time" and possibly re-wire the spare room to keep her indoors happy. Then two more to get done by Christmas! Oh Joy.