Re: Backup en Caliente

Brian:
After reading docs, I made several tests and I think that I found my error. I'm not sure, but when I tried to recover at a given time (recover ... until time ...), I didn't put the exact time (given by the backupcontrolfile). If I put the time with minutes and seconds, it works.
I suppose that the system does any changes in system.dbf while "begin...end backup". In fact, the error refers to system tablespace. (Remember that I was trying to recover complete database, simulating a total hardware failure, because I have to take a decision about backup strategy).

thanks

Brian Peasland ha escrito:

> > My idea was try to recover complete databae without using redo.log
> > files or arcxx.log files.
>
> Please, please, please go through the docs. A complete recovery from a
> hot backup will use the archived redo log files and the online redo log
> files as well. A complete recovery from a cold backup does not, however,
> you have lost information since the cold backup was taken. All of this
> is spelled out in the docs.
>
> > I'll multiplex the redo.log files.
> > A last question: Is it possible to make a copy of redo.log files
> > without stopping database?.
>
> Why would you want to copy the online redo logs with the database open?
> I'm going to reiterate my plea..."Please, please, please go through the
> docs." There should not be any need to copy the online redo logs of an
> open database. Additionally, there is no mechanism to ensure your copy
> is read consistent or can be made read consistent. Some would even go so
> far as to say that you don't need to copy the online redo logs for a
> cold backup either. Please read the docs so that you can gain a better
> understanding of these concepts.
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Tue Apr 18 2006 - 03:50:17 CDT