The Systems People Inc.

The Systems People Inc.

Customer Focused Service since 1993

RMAN report/list in Oracle

In our previous post we configured RMAN to disk base backup and cleared SBT.

Let's run some report and list commands to see the status of backups. Verify the FRA configuration.

RMAN> list backup;


RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1    0     /u02/oradata/orcl/system01.dbf
2    0     /u02/oradata/orcl/sysaux01.dbf
3    0     /u02/oradata/orcl/undotbs01.dbf
4    0     /u02/oradata/orcl/users01.dbf
5    0     /u02/oradata/orcl/example01.dbf

RMAN>

There no backups yet for our database. We'll create some backups after urning on the backup optimization.

RMAN> configure backup optimization on;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored

RMAN>

From the output of list archive log we can see that logs are being archived to FRA.

RMAN> list archivelog all;

List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1       1    3       A 07-JUN-12
        Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_07/o1_mf_1_3_7x2q7cyp_.arc

2       1    4       A 07-JUN-12
        Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_4_7x34qzvx_.arc

3       1    5       A 08-JUN-12
        Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_5_7x3z3p7x_.arc

4       1    6       A 08-JUN-12
        Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_6_7x4xh6c6_.arc

5       1    7       A 08-JUN-12
        Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_7_7x5dlngn_.arc

6       1    8       A 08-JUN-12
        Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_8_7x5rm6jw_.arc

7       1    9       A 09-JUN-12
        Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_9_7x6c78bg_.arc


RMAN>

 

 Blog Stats

  • Total posts(18)
  • Total comments(0)

Forgot your password?