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

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Tue, 24 Apr 2012 08:22:54 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B23A6E04_at_SPOBMEXC14.adprod.directory>

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 Received on Tue Apr 24 2012 - 08:22:54 CDT