| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to OPEN RESETLOGS when not recovering?
Why do you want to do this? I'm not sure what you meant by "whack all
the archived redo information". After a cold backup, the old archived
redo logs are no longer necessary. You do not need to tell the Oracle db
anything about this. During recovery, you restore from your full backup
and then apply only those redo logs since that backup. Can you explain
why you want to open the database with RESETLOGS?
Thanks,
Brian
argosy22_at_my-deja.com wrote:
>
> Hi all,
>
> We are using Oracle 7.3.4.
>
> I shutdown the database and did a full backup
> of all the files.
>
> I wanted to OPEN RESETLOGS and whack all the
> archived redo information.
>
> In svrmgrl, I did:
>
> connect internal
> alter database open resetlogs
>
> but got the error:
> ORA-01139: RESETLOGS option only valid after an incomplete database
> recovery
>
> Trying the command:
> alter database recover database
>
> gave:
>
> ORA-00283: Recovery session canceled due to errors
> ORA-00264: no recovery required
>
> What do I need to do, to reset the archiving to the beginning?
>
> Thanks,
>
> Argosy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
--
 |
 |