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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s