Conexiones Domiciliaras en Redes de Agua Potable

The List utility query the contents of the recovery catalog or the control file primarily to determine which backup or copies are available. Below are examples of the List utility.

7.2.2.1 List database incarnations

The example below list incarnation of databases that are catalog within the recovery catalog. Every time a RESETLOGS is performed, an incarnation is created for the database.

RMAN> report obsolete orphan device type 'sbt_tape';

RMAN-03022: compiling command: report Report of obsolete backups and copies

Type Key Completion Time Filename/Handle --- --- --- --- Backup Set 2194 26-MAR-01

Backup Piece 2197 26-MAR-01 OSLO/425411996/16/1 Backup Set 2211 27-MAR-01

Backup Piece 2214 27-MAR-01 OSLO/425461354/19/1 Backup Set 2212 27-MAR-01

Backup Piece 2215 27-MAR-01 OSLO/425461478/21/1 Backup Set 2213 27-MAR-01

Backup Piece 2216 27-MAR-01 OSLO/425461354/20/1

RMAN> report unrecoverable device type 'sbt_tape';

RMAN-03022: compiling command: report

Report of files that need backup due to unrecoverable operations File Type of Backup Required Name

---- --- ---

Chapter 7. Day to day monitoring of Oracle backups on UNIX 95

Draft Document for Review May 2, 2001 8:03 pm 6249ch06.fm

7.2.2.2 List old backups

You can list old backups to determine obsolete backups. The example below list backups older that 5 days.

RMAN> list incarnation;

RMAN-03022: compiling command: list

List of Database Incarnations

DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time --- --- --- --- --- --- --- 640 641 BEACH 24844426 YES 282236 12-MAR-01 2060 2070 UNKNOWN 948509196 NO 1 09-MAR-01 2060 2061 BERLIN 948509196 NO 264394 23-MAR-01 2060 2117 BERLIN 948509196 NO 264583 26-MAR-01 2060 2128 BERLIN 948509196 YES 264583 26-MAR-01 2060 2103 BERLIN 948509196 NO 264633 26-MAR-01 1654 1655 OSLO 2939852137 NO 1 09-MAR-01 1654 2142 OSLO 2939852137 YES 264394 26-MAR-01 1 2 PARIS 3920710371 YES 1 05-MAR-01

6249ch06.fm Draft Document for Review May 2, 2001 8:03 pm

RMAN> list backup completed before 'sysdate-5';

RMAN-03022: compiling command: list

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 1941 77 424966369 0 424966318 90 21-MAR-01

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 1944 1 1 AVAILABLE 21-MAR-01 PARIS/424966318/90/1

List of Datafiles Included

File Name LV Type Ckp SCN Ckp Time

---- --- -- ---- --- --- 4 /opt/app/oracle/oradata/paris/temp01.dbf 0 Full 157535 21-MAR-01 5 /opt/app/oracle/oradata/paris/users01.dbf 0 Full 157535 21-MAR-01 6 /opt/app/oracle/oradata/paris/indx01.dbf 0 Full 157535 21-MAR-01

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 1942 78 424966428 0 424966318 91 21-MAR-01

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 1945 1 1 AVAILABLE 21-MAR-01 PARIS/424966318/91/1

List of Datafiles Included

File Name LV Type Ckp SCN Ckp Time

---- --- -- ---- --- --- 1 /opt/app/oracle/oradata/paris/system01.dbf 0 Full 157535 21-MAR-01 2 /opt/app/oracle/oradata/paris/tools01.dbf 0 Full 157535 21-MAR-01

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 1943 79 424966444 0 424966374 92 21-MAR-01

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 1946 1 1 AVAILABLE 21-MAR-01 PARIS/424966374/92/1

List of Datafiles Included

File Name LV Type Ckp SCN Ckp Time

---- --- -- ---- --- --- 3 /opt/app/oracle/oradata/paris/rbs01.dbf 0 Full 157535 21-MAR-01

Chapter 7. Day to day monitoring of Oracle backups on UNIX 97

Draft Document for Review May 2, 2001 8:03 pm 6249ch06.fm

7.2.2.3 List backup of certain objects

By default, the list utility list backups made for the target database. You can restrict the list to a specific objects. The following are examples:

• To find out if there is a backup of the controlfile within the last 24 hours:

• To find out if you can recover to a point in time for tablespace USERS before March 22, 2001:

RMAN> list backup of controlfile completed after 'sysdate-1';

RMAN-03022: compiling command: list

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 2402 90 425488744 0 425488651 103 27-MAR-01

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 2405 1 1 AVAILABLE 27-MAR-01 PARIS/425488651/103/1

Controlfile Included Ckp SCN Ckp time --- --- 198333 27-MAR-01

RMAN> list backup of tablespace 'USERS' completed before '22-MAR-01';

RMAN-03022: compiling command: list

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 1941 77 424966369 0 424966318 90 2001/03/21 14:12:49

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 1944 1 1 AVAILABLE 2001/03/21 14:12:49 PARIS/424966318/90/1

List of Datafiles Included

File Name LV Type Ckp SCN Ckp Time

---- --- -- ---- --- --- 5 /opt/app/oracle/oradata/paris/users01.dbf 0 Full 157535 2001/03/21 14:

6249ch06.fm Draft Document for Review May 2, 2001 8:03 pm • To list all backup of datafile ‘/opt/app/oracle/oradata/paris/system01.dbf’

that has been backup to TSM:

RMAN> list backup of datafile '/opt/app/oracle/oradata/paris/system01.dbf' 2> device type 'sbt_tape';

RMAN-03022: compiling command: list

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 1942 78 424966428 0 424966318 91 2001/03/21 14:13:48

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 1945 1 1 AVAILABLE 2001/03/21 14:13:48 PARIS/424966318/91/1

List of Datafiles Included

File Name LV Type Ckp SCN Ckp Time

---- --- -- ---- --- --- 1 /opt/app/oracle/oradata/paris/system01.dbf 0 Full 157535 2001/03/21 14 43

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 2022 85 425130529 0 425130432 98 2001/03/23 11:48:49

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 2025 1 1 AVAILABLE 2001/03/23 11:48:49 PARIS/425130432/98/1

List of Datafiles Included

File Name LV Type Ckp SCN Ckp Time

---- --- -- ---- --- --- 1 /opt/app/oracle/oradata/paris/system01.dbf 0 Full 178171 2001/03/23 11 58

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- --- 2402 90 425488744 0 425488651 103 2001/03/27 15:19:04

List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

--- --- --- --- --- --- 2405 1 1 AVAILABLE 2001/03/27 15:19:04 PARIS/425488651/103/1

List of Datafiles Included

File Name LV Type Ckp SCN Ckp Time

---- --- -- ---- --- --- 1 /opt/app/oracle/oradata/paris/system01.dbf 0 Full 198334 2001/03/27 15 33

Chapter 7. Day to day monitoring of Oracle backups on UNIX 99

Draft Document for Review May 2, 2001 8:03 pm 6249ch06.fm

• To list backup of archive logs between SCN 178172 and 178175: