5. Feminicidio
5.2 Doctrina
The list utility queries the contents of the recovery catalog or the control file, primarily to determine which backup or copies are available. Examples of the list utility are given in the following sections.
7.2.2.1 List database incarnations
The next example lists incarnation of databases that are cataloged within the recovery catalog. Every time a RESETLOGS is performed, an incarnation is created for the database.
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
---- --- ---RMAN>
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
Chapter 7. Day-to-day monitoring of Oracle backups on UNIX 97 7.2.2.2 List old backups
You can list old backups to determine obsolete backups. The next example lists backups older than 5 days:
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
7.2.2.3 List backup of certain objects
By default, the list utility lists backups made for the target database. You can restrict the list to 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:11:43
Chapter 7. Day-to-day monitoring of Oracle backups on UNIX 99 • To list all backups of datafile ‘/opt/app/oracle/oradata/paris/system01.dbf’
that have been backed up 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:11:
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:46:
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:17:
33
• To list backups of archive logs between SCN 178172 and 178175:
RMAN> list backup of archivelog from scn 178172 until scn 178175;
RMAN-03022: compiling command: list
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- ---2039 87 425130567 0 425130566 100 2001/03/23 11:49:27
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
--- --- --- --- --- ---2041 1 1 AVAILABLE 2001/03/23 11:49:27 PARIS/425130566/100/1
List of Archived Logs Included
Thrd Seq Low SCN Next SCN Low Time Next Time ---- --- --- --- ---1 655 178149 178181 2001/03/22 15:16:29 2001/03/23 11:49:23
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time --- --- --- -- --- --- ---2040 88 425130567 0 425130566 101 2001/03/23 11:49:27
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
--- --- --- --- --- ---2042 1 1 AVAILABLE 2001/03/23 11:49:27 PARIS/425130566/101/1
List of Archived Logs Included
Thrd Seq Low SCN Next SCN Low Time Next Time ---- --- --- --- ---1 655 178149 178181 2001/03/22 15:16:29 2001/03/23 11:49:23
Chapter 7. Day-to-day monitoring of Oracle backups on UNIX 101
7.2.3 Crosscheck utility
The crosscheck utility verifies whether backups still exist on disk or TSM.
RMAN does not delete backup entries that it could not find, but instead marks them as expired. If the backup was erroneously marked expired, for example, because TSM was unavailable or misconfigured, the crosscheck utility will mark it available the next time it is run if the backup still exists.
Like the list utility discussed in 7.2.2.3, “List backup of certain objects” on page 98, you can run the crosscheck utility on certain objects. See the Oracle8i Recovery Manager User Guide and Reference, A76990-1, for the complete syntax of the crosscheck utility.
Here is a sample script to crosscheck all backup entries in the recovery catalog or control file: