RMAN reporting & configuration in Oracle on AWS

Initiated an Oracle instance on AWS. In this posts I'll review some of the reporting and backup/recover using RMAN.
Log into to the instance (AWS/Oracle) using password. Start RMAN and let's investigate.

 

01	login as: oracle

02	oracle@ec2-23-22-205-159.compute-1.amazonaws.com's password:

03	oracle@domU-12-31-39-00-7C-94:[/home/oracle]

04

$

05	oracle@domU-12-31-39-00-7C-94:[/home/oracle]

06

$

07	oracle@domU-12-31-39-00-7C-94:[/home/oracle]

08	$ rman target=orcl

09

10	Recovery Manager: Release 11.1.0.7.0 - Production on Fri Jun 8 18:01:12 2012

11

12	Copyright (c) 1982, 2007, Oracle. All rights reserved.

13

14	target database Password:

15	connected to target database: ORCL (DBID=1313137175)

16

17	RMAN> list backup;

18

19	using target database control file instead of recovery catalog

20

21

RMAN>

Now, we are in RMAN and realize there are no backups.
Let's check of the database's configuration like, archivelog mode, FRA configureation etc...

 

01	$ sqlplus / as sysdba

02

03	SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 8 18:01:43 2012

04

05	Copyright (c) 1982, 2008, Oracle. All rights reserved.

06

07

08	Connected to:

09	Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

10	With the Partitioning, OLAP, Data Mining and Real Application Testing options

11

12	SQL> show user;

13	USER is "SYS"

14	SQL> archive log list;

15	Database log mode Archive Mode

16	Automatic archival Enabled

17	Archive destination USE_DB_RECOVERY_FILE_DEST

18	Oldest online log sequence 5

19	Next log sequence to archive 7

20	Current log sequence 7

21

SQL>

Well the database is in archivelog mode; Let's check the RMAN configuration...

 

01	RMAN> show all;

02

03	using target database control file instead of recovery catalog

04	RMAN configuration parameters for database with db_unique_name ORCL are:

05	CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

06	CONFIGURE BACKUP OPTIMIZATION OFF; # default

07	CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

08	CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

09	CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

10	CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

11	CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

12	CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

13	CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

14	CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

15	CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

16	CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

17	CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/u02/admin/orcl/osbws/libosbws11.so';

18	CONFIGURE MAXSETSIZE TO UNLIMITED; # default

19	CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

20	CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

21	CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default

22	CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'TAPE';

23	CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/db_1/dbs/snapcf_orcl.f'; # default

24

25

RMAN>

This instance is designed for OSB (Oracle Secure Backup) with SBT as default, with channel defined for SBT. We'll change the default to disk.

 

1	RMAN> configure default device type to disk;

2

3	old RMAN configuration parameters:

4	CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

5	new RMAN configuration parameters:

6	CONFIGURE DEFAULT DEVICE TYPE TO DISK;

7	new RMAN configuration parameters are successfully stored

8

9

RMAN>

Now we'll CLEAR the tape related configurations...

 

1	RMAN> configure default device type to disk;

2

3	old RMAN configuration parameters:

4	CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

5	new RMAN configuration parameters:

6	CONFIGURE DEFAULT DEVICE TYPE TO DISK;

7	new RMAN configuration parameters are successfully stored

8

9

RMAN>

Notice with the TAPE CLEAR... all values are set to #default

 

01	RMAN> CONFIGURE DEVICE TYPE SBT_TAPE clear;

02

03	RMAN configuration parameters are successfully reset to default value

04

05	RMAN> show all;

06

07	RMAN configuration parameters for database with db_unique_name ORCL are:

08	CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

09	CONFIGURE BACKUP OPTIMIZATION OFF; # default

10	CONFIGURE DEFAULT DEVICE TYPE TO DISK;

11	CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

12	CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

13	CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

14	CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

15	CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

16	CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

17	CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

18	CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

19	CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

20	CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/u02/admin/orcl/osbws/libosbws11.so';

21	CONFIGURE MAXSETSIZE TO UNLIMITED; # default

22	CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

23	CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

24	CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default

25	CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'TAPE';

26	CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/db_1/dbs/snapcf_orcl.f'; # default

27

28

RMAN>

Now we are set to default (for SBT) and configured RMAN for disk backup.

In next post we'll expolre additional RAN backup reporting.