Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resetlogs
Is your database internally inconsistent? No (see point 1). Therefore, why on Earth would you want to issue resetlogs in the first place?
Your step 6 is the one I can't fathom. Why do you think that you need to issue a resetlogs simply in order to perform a fresh hot backup? You don't.
I saw in another of your posts that having tried to recover your hot backup, it asks for archives from before the time the backup started. That simply cannot happen... unless you are not taking the backup properly. I hope you have remembered to do the 'alter tablespace blah begin backup' command before attempting to copy the data files. And I hope you've remembered to take a consistent backup of the controlfile, using 'alter database backup command to 'blah.ctl''. And I hope you aren't trying to hot copy the online redo logs.
Regards
HJR
-- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "clueless" <ro_cright_at_hotmail.com> wrote in message news:snph8.3353$f5.133770_at_news...Received on Wed Mar 06 2002 - 14:55:19 CST
> 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...
>
>
>