RMAN recovery lab records

This article focuses on backing up and recovering data files. For more information about rman, see my other article:

First, let's look at the data files:

SQL> selectfile_name, file_id, tablespace_name from dba_data_files;

 

FILE_NAME FILE_ID TABLESPACE_NAME

----------------------------------------------------------------------------------------------------

E: \ Oracle \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ USERS01.DBF 4 USERS

E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ SYSAUX01.DBF 3 SYSAUX

E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ UNDOTBS01.DBF 2 UNDOTBS1

E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ SYSTEM01.DBF 1 SYSTEM

E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ EXAMPLE01.DBF 5 EXAMPLE

E: \ RM_TAB.DBF 6 RM_TABLESPACE

E: \ RMAN. DBF 7 RMAN_TAB

 

You have selected 7 rows.

 

 

C: \ Documents ents andSettings \ Administrator> rman target/

 

Recovery MANAGER: Release 11.2.0.1.0-Production on Tuesday 15: 54: 092013

 

Copyright (c) 1982,200 9, Oracle and/or itsaffiliates. All rights reserved.

 

Connect to the target database: ORCL (DBID = 1318810635)

 

Check the existing backup status of the database:

 

RMAN> list backup;

 

Backup set list

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

BS keyword Type LV Size Device type time completed

--------------------------------------------------------

145 Full 1.60g disk 00:03:35-13

BP Keyword: 144 Status: AVAILABLE compressed: NO mark: TAG20130902T160350

Segment name: D: \ BACKUP \ FULL_ORCL_825091431_171.BAK

Data File List in backup set 145

CkpSCN Ckp time name of file LV type

----------------------------------

1 Full 33823078237 month-13E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ SYSTEM01.DBF

2 Full 33823078237 month-13E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ UNDOTBS01.DBF

3 Full 33823078237 month-13E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ SYSAUX01.DBF

4 Full 33823078237 month-13E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ USERS01.DBF

5 Full 33823078237 month-13E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ EXAMPLE01.DBF

6 Full 33823078237 month-13E: \ RM_TAB.DBF

7 Full 33823078237 month-13E: \ RMAN. DBF

 

BS keyword size: time used by the device type

--------------------------------------------------

150 698.25 m disk 00:01:40-13

BP Keyword: 149 status: AVAILABLE compressed: NO mark: TAG20130902T165210

Segment name: D: \ BACKUP \ ARCH_ORCL_20130902_176.BAK

 

Archived log list in backup set 150

Thread sequence low SCN lower time limit next SCN next time

--------------------------------------------------

1 42 33822522080 1333822546427-8 months-26-8 months-13

1 43 33822546427 month-1333822572086 month-13

1 44 33822572086 month-1333822577968 month-13

33822577968 month-1333822597826 month-13

1 46 33822597826 month-1333822632804 month-13

1 47 33822632804 month-1333822708919 month-13

1 48, 33822708919, 1333822741205-,-13

1 49 33822741205 month-1333822776061 month-13

1 50 33822776061 28-8 months-1333822806367 28-8 months-13

1 51 33822806367 28-8 month-13 3382284917730-8 month-13

1 52 33822849177 30-8 months-1333822855569 30-8 months-13

1 53 33822855569 30-8 months-1333822890493 30-8 months-13

1 54 33822890493 30-8 months-1333822914392 31-8 months-13

1 55 33822914392 month-1333822923253 month-13

1 56 33822923253 months-1333822946575 months-13 months-13

1 57 33822946575 01-9 month-1333822953742 01-9 month-13

1 58 33822953742 month-1333822956954 month-13

1 59 months 33822956954-9 months-1333822972848-9 months-13

1 60 33822972848 month-1333823003071 month-13

1 61 33823003071 month-1333823038838 month-13

1 62 33823038838 months-1333823060805 months-13 months-13

1 63 33823060805 month-1333823080230 month-13

1 64 33823080230 02-9 month-13 3382308026302-9 month-13

 

BS keyword Type LV Size Device type time completed

--------------------------------------------------------

154 Full 96.00 k disk 00:00:01 17-9 month-13

BP Keyword: 153 status: AVAILABLE compressed: NO mark: TAG20130917T160606

Segment name: D: \ BACKUP \ ORCL_180.BAK

Data File List in backup set 154

CkpSCN Ckp time name of file LV type

----------------------------------

7 Full 33823344873 17-9 month-13E: \ RMAN. DBF

 

BS keyword Type LV Size Device type time completed

--------------------------------------------------------

155 Full 9.55 m disk 00:00:03 17-9 month-13

BP Keyword: 154 status: AVAILABLE compressed: NO mark: TAG20130917T160610

Segment name: F: \ RMANBACKUP \ CONTROLFILE \ C-1318810635-20130917-00

Included SPFILE: modification time: 17-9-13

Included control file: CkpSCN: 33823344928 Ckp time: 17-9 month-13

Recommended reading:

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

1 2 3 4 Next Page