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.

 

01	RMAN> list backup;

02

03

04	RMAN> report obsolete;

05

06	RMAN retention policy will be applied to the command

07	RMAN retention policy is set to redundancy 1

08	no obsolete backups found

09

10	RMAN> report need backup;

11

12	RMAN retention policy will be applied to the command

13	RMAN retention policy is set to redundancy 1

14	Report of files with less than 1 redundant backups

15	File #bkps Name

16	---- ----- -----------------------------------------------------

17	1 0 /u02/oradata/orcl/system01.dbf

18	2 0 /u02/oradata/orcl/sysaux01.dbf

19	3 0 /u02/oradata/orcl/undotbs01.dbf

20	4 0 /u02/oradata/orcl/users01.dbf

21	5 0 /u02/oradata/orcl/example01.dbf

22

23

RMAN>

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

 

1	RMAN> configure backup optimization on;

2

3	new RMAN configuration parameters:

4	CONFIGURE BACKUP OPTIMIZATION ON;

5	new RMAN configuration parameters are successfully stored

6

7

RMAN>

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

 

01	RMAN> list archivelog all;

02

03	List of Archived Log Copies for database with db_unique_name ORCL

04	=====================================================================

05

06	Key Thrd Seq S Low Time

07	------- ---- ------- - ---------

08	1 1 3 A 07-JUN-12

09	Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_07/o1_mf_1_3_7x2q7cyp_.arc

10

11	2 1 4 A 07-JUN-12

12	Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_4_7x34qzvx_.arc

13

14	3 1 5 A 08-JUN-12

15	Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_5_7x3z3p7x_.arc

16

17	4 1 6 A 08-JUN-12

18	Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_6_7x4xh6c6_.arc

19

20	5 1 7 A 08-JUN-12

21	Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_08/o1_mf_1_7_7x5dlngn_.arc

22

23	6 1 8 A 08-JUN-12

24	Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_8_7x5rm6jw_.arc

25

26	7 1 9 A 09-JUN-12

27	Name: /u02/flash_recovery_area/ORCL/archivelog/2012_06_09/o1_mf_1_9_7x6c78bg_.arc

28

29

30

RMAN>