Scribd
Upload
48 views2 pages

Check L0 BKP Oracle

The document provides a sequence of commands to verify Level 0 backup in Oracle using RMAN, including setting the date format and listing the backup. Key fields to observe are 'Elapsed Time' and 'Completion Time' for the backup. An example output from the RMAN command is also included for reference.

Uploaded by

ovidiu0702
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
48 views2 pages

Check L0 BKP Oracle

The document provides a sequence of commands to verify Level 0 backup in Oracle using RMAN, including setting the date format and listing the backup. Key fields to observe are 'Elapsed Time' and 'Completion Time' for the backup. An example output from the RMAN command is also included for reference.

Uploaded by

ovidiu0702
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

Pentru a verifica L0 backup in Oracle (cu RMAN), putem folosi urmatoarea

secventa de comenzi (data de Adrian Neagu):

-export NLS_DATE_FORMAT='DD-MON-YYYY hh24:mi:ss'

-rman target /

-list backup of database;

Prima comanda seteaza ora intr-un format "friendly", urmatoarele doua sunt
pentru conectare si check. Cele doua campuri dupa care trebuie sa ne uitam
sunt : "Elapsed Time" si "Completion Time", pentru Level 0.

Mai jos aveti un exemplu din WTK. Sper sa ajute. Daca aveti nelamuriri,
completari, va rog sa dati reply la acest email:)

Andrei

lsav@voms22$ export NLS_DATE_FORMAT='DD-MON-YYYY hh24:mi:ss'


lsav@voms22$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Thu Apr 19 19:01:21


2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: PMB (DBID=1235920186)

RMAN> list backup of database;

using target database control file instead of recovery catalog

List of Backup Sets


===================

BS Key Type LV Size Device Type Elapsed Time Completion Time


------- ---- -- ---------- ----------- ------------ --------------------
1115 Incr 0 16.45G DISK 00:08:51 18-APR-2012 01:11:01
BP Key: 1115 Status: AVAILABLE Compressed: NO Tag:
WEDNESDAY_00
Piece Name:
/backup1/flash_recovery_area/pmb/201204180059PMB_1118_780886930
List of Datafiles in backup set 1115
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/system.261.747680641
2 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/undotbs.262.747680667
3 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/sysaux.263.747680701
4 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/userstbs.265.747680721
5 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs1.266.747682021
6 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs2.267.747682025
7 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs1.268.747682029
8 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs2.269.747682071
9 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/stpk_tbs.272.747682115
10 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs1.281.773505079
11 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs1.287.773505101
12 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs1.288.773505131
13 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs1.274.773505165
14 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs2.275.773505225
15 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs2.276.773505279
16 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs2.277.773505323
17 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs2.283.773505421
18 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs1.284.773505467
19 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs1.285.773505513
20 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs1.286.773505629
21 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs1.280.773505695
22 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs2.278.773505725
23 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs2.279.773506157
24 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs2.282.773506317
25 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/index_tbs2.289.773506631
26 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/data_tbs2.290.773507097
27 0 Incr 254244925 18-APR-2012 01:02:10
+DGROUP1/pmb/datafile/undotbs.298.777162813

You might also like