Printable View
Morning Folks,
I think I'm missing something here, probably several cups of coffee.
When recovering to alternate location because of a media failure, Oracle B&R says "Mimic incomplete recovery using ALTER DATABASE RECOER DATABASE UNTIL CANCEL" but cancel before appling any logs.
Is this step something to do with re-synchronisation of the database files or have I lost the plot here?
Bit of a worry since the exam is on Monday!
Any help much appreciated.
Nick
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.
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.
[Edited by oca9i2002 on 10-17-2002 at 11:14 PM]
Thanks for the response guys.Quote:
Originally posted by oca9i2002
In order for you to resetlogs, you need to MIMIC recover database until cancel.
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.
Many thanks
Nick
Nick, Good luck for your exam monday.
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.
Hi Folks,
Many thanks for all your responses.
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.
Any thanks again all.
Nick
Good job...yes, this exam is easier than A&A or Intro.
Excellent result Nick, and congratualtions on passing. That is the same score I got for that on. :) A few shandys for you... he he
Cheers Mate,
Unfortunately it's now 00:30 and we're are still trying to migrate an application to production, so it'll probably have to wait until Thu.
My stuff worked fine (nice offline backup including control file)
'kin application is stuffed again!!!
PS, I saw your forray onto google. Now stop upsetting Howard ;-)
Where's Shyamis, she should be up for 25 soon.
On a fairly serious note, this exam doesn't do OCP any favours. Big O aren't going to get anyone to believe in the "Professional" element with this one.
All the best
LOL... yeah, Howard didn't like being quoted, I reckon he thought I was bagging him. :D That's a pretty good forum (content that its, the actual forum structure is CRAP!". In their with some pretty "heavy" guys, very interesting.. if you're going to comment, be prepared to Back yourself up, it's quite easy to get.. well, "BURNT". The ol' ego get's put back in it's place pretty quickly to, especially when theories get shot down by Conner McDonald, Jonathan Lewis and Howard Rogers. Respect to them though, they soon put you on the right track. The biggest thing I took out of that is, TEST and TEST again.. preferrable with larger test sets.
Anyway, hope the migration is going well. They're paying you overtime RIGHT! ;)
I hope everyone is aware that those forums are actually not "google forums" or something like that. Those are USENET NEWS discussion groups, one of the oldest services on the internet - definitely older than google itself! Google only provide an *web based access* to those newsgroups, so we can't even speak about "actual forum structure" in this context.Quote:
Originally posted by grjohnson
That's a pretty good forum (content that its, the actual forum structure is CRAP!".
If you are serious about using usnet, then you would certanly not use web based access, you would find some pretty good news reader (like Forté Agent or something like that), and you'll find out that the actual structure of those discussins is darn good (IMHO).
Point noted...
Finally finished that migration 01:00 this morning.
We've all spoken about paper OCPs but I have to say my newly acquired knowledge of B&R stood me on good stead.
Lovely little restore of 2gb at 11:30 last night went sweet as a nut.
Mind you all this work is playing havoc with my study time :D
Cheers
Nick