Re: RMAN Related question (Earliest restore point within an RMAN backup?)

From: saurabh manroy <saurabhmanroy_at_gmail.com>
Date: Tue, 24 Apr 2012 15:44:40 +0200
Message-ID: <CAELkjfVt7i0ts0vgC5OpuWMuGJ-oJ4x-wpifBuh4r5fLHt+yiA_at_mail.gmail.com>

Hello Chris,
If controlfile autobackup is on, it might not give the 'correct' information that you are looking for.
You can use controlfile_included column in rc_backup_set_details to crosscheck.

btw: 'Restore database preview' provides detailed information about backupsets needed for restore to a point in time.

Regards,
Saurabh Manroy

On Tue, Apr 24, 2012 at 3:22 PM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> I think I figured it out:
>
> (Windows)
> Set NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS
>
> RMAN> list backup of controlfile;
>
> List of Backup Sets
> ===================
>
> BS Key Type LV Size Device Type Elapsed Time Completion Time
> ------- ---- -- ---------- ----------- ------------ --------------------
> 3096549 Full 1.08M DISK 00:00:02 23-APR-2012 22:27:56
> BP Key: 3096554 Status: AVAILABLE Compressed: YES Tag: %TAG
> Piece Name: Z:\DBABACKUP\CURRENT\TST3\0EN96A3A_1_1
> Control File Included: Ckp SCN: 16795861918 Ckp time: 23-APR-2012
> 22:27:54
>
> So 22:27:54 is the *earliest* I could duplicate this database using this
> backup, correct? (Or no?)
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Taylor, Chris David
> Sent: Tuesday, April 24, 2012 8:15 AM
> To: 'oracle-l_at_freelists.org'
> Subject: RE: RMAN Related question (Earliest restore point within an RMAN
> backup?)
>
>
> Ok, I couldn't find it quickly so I'm asking...
>
> How do you find the earliest restore point within an existing RMAN backup?
>
> Looking specifically for DATE & *TIME*
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 24 2012 - 08:44:40 CDT