Re: resetlogs

I have.

this is what I am doing.

1. hot backup of production
2. move backup to stby db server (exact same configuration).
3. alter database create standby control file as 'Scontrol01.ctl';
4. alter system archive log current;
5. move the standby control file and archive logs to standby db server.
6. connect internal using svrmgrl
7. startup pfile=init_sprod.ora nomount works ok
8. alter database mount standby database works ok
9. recover standby database problemo. It tries to recover a period prior to my archived redo logs that I have. I lost one so I gashed all the ones prior to it. (hence the moron).

Is there a way I can resetlogs on the production instance while it is open and then redo the hot backup???

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3c8627a3$0$8507$ed9e5944_at_reading.news.pipex.net...
> "clueless" <ro_cright_at_hotmail.com> wrote in message
> news:snph8.3353$f5.133770_at_news...
> > I want to issue the resetlog command on a database that is open.
> >
> > Why?
> > 1. production db cannot be shut down. No coffee, no doughnuts, ...
> > 2. I'm worried that the server is going to crash. Vendor's app is flaky
> and
> > they are screwing around with it.
> > 3. I want to create a standby oracle db. Need to defend myself.
> > 4. I have created a hot backup and moved the archived redo logs over to
> the
> > standby server.
> > 5. I lost one of the archive logs. I am a moron.
> > 6. I can redo the hotbackup but without setting the resetlog I'm
screwed.
> I
> > think?
> >
> > Clueless...
>
> why not drop the current standby and recreate it (or if you have the
> hardware create a second standby. 0
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Wed Mar 06 2002 - 08:42:26 CST