Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: resetlogs

Re: resetlogs

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 6 Mar 2002 14:28:43 -0000
Message-ID: <3c8627a3$0$8507$ed9e5944@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:28:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US