Oracle RMAN 11g Backup and Recovery (145 page)

BS Key Type LV Size Device Type Elapsed Time Completion Time

928 Full 9.67M DISK 00:00:01 08 SEP 09

BP Key: 930 Status: AVAILABLE Compressed: NO Tag: TAG20090908T202923

Piece Name:

/oracle/app/oracle/flash recovery area/ROB1/autobackup/2009 09 08

/o1 mf s 697062563 5bg4r47m .bkp

Control File Included: Ckp SCN: 679329 Ckp time: 08 SEP 09

BS Key Type LV Size Device Type Elapsed Time Completion Time

1062 Full 9.67M DISK 00:00:01 08 SEP 09

BP Key: 1064 Status: AVAILABLE Compressed: NO Tag: TAG20090908T203421

Piece Name:

/oracle/app/oracle/flash recovery area/ROB1/autobackup/2009 09 08

/o1 mf s 697062861 5bg51g1m .bkp

Control File Included: Ckp SCN: 679822 Ckp time: 08 SEP 09

RMAN> list backup of spfile;

List of Backup Sets

BS Key Type LV Size Device Type Elapsed Time Completion Time

774 Full 9.67M DISK 00:00:01 08 SEP 09

BP Key: 776 Status: AVAILABLE Compressed: NO Tag: TAG20090908T202724

Piece Name:

/oracle/app/oracle/flash recovery area/ROB1/autobackup/2009 09 08

/o1 mf s 697062444 5bg4ndym .bkp

SPFILE Included: Modification time: 08 SEP 09

SPFILE db unique name: ROB1

BS Key Type LV Size Device Type Elapsed Time Completion Time

928 Full 9.67M DISK 00:00:01 08 SEP 09

Chapter 17: Monitoring and Reporting on RMAN
435

BP Key: 930 Status: AVAILABLE Compressed: NO Tag: TAG20090908T202923

Piece Name:

/oracle/app/oracle/flash recovery area/ROB1/autobackup/2009 09 08

/o1 mf s 697062563 5bg4r47m .bkp

SPFILE Included: Modification time: 08 SEP 09

SPFILE db unique name: ROB1

BS Key Type LV Size Device Type Elapsed Time Completion Time

1062 Full 9.67M DISK 00:00:01 08 SEP 09

BP Key: 1064 Status: AVAILABLE Compressed: NO Tag: TAG20090908T203421

Piece Name:

/oracle/app/oracle/flash recovery area/ROB1/autobackup/2009 09 08

/o1 mf s 697062861 5bg51g1m .bkp

SPFILE Included: Modification time: 08 SEP 09

SPFILE db unique name: ROB1

We’ll bet you have already guessed that you can use the
list expired backup of archivelog all
command here, too. Also, you can limit the report by time or log sequence number. For example, to list expired archive log backups until a given sequence, you could use the command
list expired
backup of archivelog until sequence
.

Listing Image Copies

Just as you can use the
list
command to determine the status of backup sets, you can also use the
list
command to determine the status of database image copies. You can generate a list of all copies with the
list copy
command:

RMAN> list copy;

starting full resync of recovery catalog

full resync complete

specification does not match any control file copy in the repository

List of Datafile Copies

Key File S Completion Time Ckp SCN Ckp Time

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

1215 3 A 08-SEP-09 681024 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/datafile

/o1 mf undotbs1 5bg6sw1s .dbf

Tag: TAG20090908T210427

List of Archived Log Copies for database with db unique name ROB1

Key Thrd Seq S Low Time

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

54 1 9 X 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/2009 09 08

/o1 mf 1 9 5bd8qv45 .arc

436
Part III: Using RMAN Effectively

1170 1 19 A 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/2009 09 08

/o1 mf 1 19 5bg61l4l .arc

In addition to this summary list, you can create lists of individual datafile copies, archived redo logs, and control file copies. Let’s look at those options in more detail for a moment.

Listing Datafile Copies

Oracle allows you to generate a summary list of all datafile copies with the
list copy of database
command:

RMAN> list copy of database;

List of Datafile Copies

Key File S Completion Time Ckp SCN Ckp Time

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

1215 3 A 08-SEP-09 681024 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/datafile

/o1 mf undotbs1 5bg6sw1s .dbf

Tag: TAG20090908T210427

In this output, we have two copies of datafiles that belong to our database, datafile2.copy and datafile3.dbf. While the actual name of the datafile or its assigned tablespace name is not listed, the file number is listed in the second column of the report. We could relate this file number to the associated tablespace by running the
report schema
command, which we discuss later in this chapter.

If you want to know whether you have a datafile copy of a tablespace or a datafile, you can use the
list copy of tablespace
or
list copy of datafile
command, as shown here: RMAN> list copy of tablespace undotbs1;

List of Datafile Copies

Key File S Completion Time Ckp SCN Ckp Time

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

1215 3 A 08-SEP-09 681024 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/datafile

/o1 mf undotbs1 5bg6sw1s .dbf

Tag: TAG20090908T210427

Listing Archived Redo Log Copies

If you want a list of archived redo log copies, you can use the
list copy of archivelog all
command: RMAN> list copy of archivelog all;

List of Archived Log Copies for database with db unique name ROB1

Key Thrd Seq S Low Time

Chapter 17: Monitoring and Reporting on RMAN
437

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

54 1 9 X 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/

2009 09 08/o1 mf 1 9 5bd8qv45 .arc

1170 1 19 A 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/2009 09 08

/o1 mf 1 19 5bg61l4l .arc

You can also list copies of specific archived redo logs by time, sequence, or database SCN.

Here are some examples of listing archived redo logs based on differing criteria: RMAN> list copy of archivelog from sequence 9;

List of Archived Log Copies for database with db unique name ROB1

Key Thrd Seq S Low Time

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

54 1 9 X 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/2009 09 08

/o1 mf 1 9 5bd8qv45 .arc

1170 1 19 A 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/2009 09 08

/o1 mf 1 19 5bg61l4l .arc

RMAN> list copy of archivelog from sequence 9 until sequence 19;

List of Archived Log Copies for database with db unique name ROB1

Key Thrd Seq S Low Time

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

54 1 9 X 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/2009 09 08

/o1 mf 1 9 5bd8qv45 .arc

1170 1 19 A 08-SEP-09

Name:

/oracle/app/oracle/flash recovery area/ROB1/archivelog/2009 09 08

/o1 mf 1 19 5bg61l4l .arc

Listing Control File Copies

Finally, RMAN can report on control file copies with the
list copy of controlfile
command: RMAN> list copy of controlfile;

List of Control File Copies

Key S Completion Time Ckp SCN Ckp Time

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