Re: Archive Logs

You must use the control files from your current database - otherwise you are recovering to the time of the cold backup - hence no recovery.

If you do not have the current control file -then you must create a backup control file and use that instead. To create a backup controlfile do 'Alter system backup controlfile to trace'. Find the trace file, rename the existing controlfiles and run the script contained in the trace file. This will recreate the controlfiles.

Now startup the datbase and do 'recover until cancel'. This will read the archive logs until you say stop

Alex

On Thu, 2 Dec 1999 09:55:24 +0100, "Paweł Kokot" <pkokot_at_zg.szczecin.pl> wrote:

>It does not work
>I wrote:
> startup mount pfile=...
> set autorecovery on
> recover database
>
>and after this command it wrot that database does need recovery.
>
> alter database open
>
>What to do with it?
>
>--
>Paweł Kokot
>STAR-SOFT Cieszyn
>Kathinka Diehl <kathinka_at_rrr.de> wrote in message
>news:823chc$2b4ga$1_at_fu-berlin.de...
>>
>> Paweł Kokot <pkokot_at_zg.szczecin.pl> schrieb:
>>
>> > I know all you wrote, but there is problem. ORACLE says that database
>does
>> > not need to be recovered. So what to do with it?
>>
>> Of cause your backup needs no recovery, it's a complete and correct
>> database. You have to do the following steps after you have restored your
>> backup and your archive-redologs
>>
>> startup mount pfile=...
>> set autorecovery on
>> recover database
>> alter database open
>>
>> This should work.
>>
>> HTH, Kathinka
>>
>>
>
>
Received on Thu Dec 02 1999 - 10:12:40 CST