maybe http://www.plsgoogleit.com
"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
news:d0p1e7$trq$1_at_news6.zwoll1.ov.home.nl...
> utkanbir wrote:
>> Hi , I am trying a very simple recovery but have not achived it yet.Here
>> what i try to do:
>>
>> This is a test database on my laptop , oracle 9.2.0.5 is installed and
>> db server is in archive log mode.
>> After stopping the db server by using shutdown immediate , i copy all
>> the data file ,redo log files , control files etc to my backup
>> location. Then i restart the db , make some transactions (someof them
>> are nologging some of them are logging operations) . Archive all the
>> redo logs by using archive log all . Then at this point , i want to
>> return to my previous backup and recover the dbserver up to the latest
>> point in order to see which operations are really logged and recovered
>> :
>>
>> 1. I copy all the files from my backup location to the original
>> location.
>>
>> 2. startup mount
>>
>> 3. recover database ;
>>
>> At this point the command fails and says recover database using backup
>> controlfile is necessary. Why?
>>
>> 3. recover database using backup controlfile;
>>
>> this command applies each log , it says for some of the logs they are
>> not required , at the end it asks for an archived log number which
>> does not exist and fails.
>>
>>
>> Then recovery stops. What point do i miss here? It seems very simple and
>> staright forward
>> but it fails.
>>
>> I will be appreciated ,if some one can help me.
>>
>> Kind Regards,
>> hope
>
> OK - so you have a cold backup.
> What happens, is you need no recovery at all, not when you
> copy all files back from your backup location. All files are
> in sync (you did a shutdown before copy), so there's nothing
> to recover.
>
> The fact oracle comes up with another scenario means you did
> not copy back all files (or you did not copy them all in the
> first place - this does not matter for the outcome).
>
> We can only guess.
> --
> Regards,
> Frank van Bortel
Received on Thu Mar 10 2005 - 08:17:00 CST
