Re: Simple archive question

Hi Arun ,

These are the steps and error message:

Starting form the beginning:

1. shutdown immediate
2. copy all files to a backup location . (al files including control redo undo)
3. startup and create some tables insert data commit.
4. archive log all;
5. shutdown immediate.

at this state , select * from v$log says the current log seq is 295 , it is not archived . Log 294 is inactive and archived . These are the only logs defined since this is my laptop.

now i start recovery:

1. copy files back to the original location apart from redo logs.
2. startup mount
3. recover database using backup controlfile;

It returns with error :

ora-00279 and ora-00289 . In ora-00289 it says it needs arc295.001:   

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

This log is the current log and it is in redo log files not archived . At this
point i choose <ret> option but since the log is not archived i got the same error and recovery fails.

Since seq 295 is not archived and inside the redo log files , why does the recovery ask the archived location?

These are the steps . I still havent understood the point i missed .

Kind Regards,
tolga

"Arun Mathur" <themathurs_at_gmail.com> wrote in message news:<1110588615.651917.13710_at_f14g2000cwb.googlegroups.com>...
> Hi Tolga,
>
> "recover database using backup controlfile
>
> But indeed this is what i tried to complish at the beginning. This
> fails after some point during redo log applying , and i am unable to
> start the dbserver. "
>
> What error message(s) are you getting at this stage of recovery?
>
> Regards,
> Arun
Received on Mon Mar 14 2005 - 02:36:34 CST