Re: RMAN Related question (Earliest restore point within an RMAN backup?)
- From: saurabh manroy <saurabhmanroy@xxxxxxxxx>
- To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
- Date: Tue, 24 Apr 2012 15:44:40 +0200
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Taylor, Chris David
> Sent: Tuesday, April 24, 2012 8:15 AM
> To: 'oracle-l@xxxxxxxxxxxxx'
> 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*
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
