Re: RMAN in Windows: Issues With Point-In-Time Recovery
Date: Fri, 17 Sep 2010 07:41:13 -0700 (PDT)
Message-ID: <deca7e53-41f4-4311-bc23-c1da11705e31_at_r10g2000vbc.googlegroups.com>
Hi,
Thanks you for the replies, John Hurley and Joel Garry. Much appreciated.
John: Thanks for your idea. It worked. I recovered using sqlplus until
now, though
I used SAP tools for the backups. So, I restored the datafiles and
archive logs
from RMAN, logged into Sqlplus, issued a 'Recover until time..'
command,
opened using resetlogs,and all was fine. So, for now, no RMAN recovery
for me!
Joel Garry: Thanks for the info. I will look into the asktom link, and
the timestamp
SCN connection.
Thanks,
QZ
>
> The association between timestamp and scn is in a table called
> something like smon_scn_time. The granularity is 5 minutes, I think.
> You might consider figuring out which SCN to restore until, rather
> than a time too close to where you want, and 10g has a function to get
> it within 3 seconds. Seehttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9...
>
> Some things are strange for historical reasons.
>
> jg
> --
> _at_home.com is bogus.http://www.bbc.co.uk/news/technology-11313194
Received on Fri Sep 17 2010 - 09:41:13 CDT