Re: Take the archives during the backup
From: joel garry <joel-garry_at_home.com>
Date: Thu, 26 Aug 2010 13:28:51 -0700 (PDT)
Message-ID: <dfb64b8f-8495-48e5-b8ed-dfd96b91fb7b_at_t5g2000prd.googlegroups.com>
On Aug 25, 11:02 pm, "bob123" <bob..._at_gmail.com> wrote:
> Hi,
>
> I did a hot backup with RMAN.
> To recover to the time of the end of the backup
> how can I specify to take the archive
> only generated during the backup ?
>
> Thanks in advance
> Oracle 10.2.0.4
Date: Thu, 26 Aug 2010 13:28:51 -0700 (PDT)
Message-ID: <dfb64b8f-8495-48e5-b8ed-dfd96b91fb7b_at_t5g2000prd.googlegroups.com>
On Aug 25, 11:02 pm, "bob123" <bob..._at_gmail.com> wrote:
> Hi,
>
> I did a hot backup with RMAN.
> To recover to the time of the end of the backup
> how can I specify to take the archive
> only generated during the backup ?
>
> Thanks in advance
> Oracle 10.2.0.4
In addition to what Mark said, what exactly are you trying to accomplish? It is possible to need archived logs from before the start of the backup. It is possible to get ORA-1152 too, if your specification winds up creating a gap in the logs applied. Remember, hot backups are fuzzy, and you need to apply redo to make transactions consistent. Transactions may not care when your backup started. It is very easy to think nothing is happening when you do your backup, but something is always happening. Then there's read-only tablespaces...
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2010/aug/18/wikileaks-seeks-online-safe-haven-in-sweden/Received on Thu Aug 26 2010 - 15:28:51 CDT