Practice: Oracle Recovery Manager Overview and Configuration

  1. Connect to your database as the target database in the default Nocatalog mode.

  1. Use the RMAN REPORT command to generate a listing of your database structure.

  1. Use the RMAN SHOW command to generate a listing of the RMAN configuration settings.

  1. Use the RMAN CONFIGURE command to set the backup retention policy to a recovery window of 14 days.

  1. Verify the setting for the backup retention policy.

  1. Set the backup retention policy back to the default value.

Practice #<number>: <topic title>

Practice: RMAN Channel Allocation

 

In this practice you will perform automatic channel allocation using the RMAN configure commands.

 

 

Assumptions

 

·        This practice assumes that you have a target database available. A recovery catalog is not required.  

 

Instructions

 

1.      The target database needs to be mounted or open to perform the configure commands. If the database is shutdown, use RMAN to start the database.

 

RMAN> startup

 

Oracle instance started

database mounted

database opened

 

Total System Global Area     109866920 bytes

 

Fixed Size                      282536 bytes

Variable Size                 83886080 bytes

Database Buffers              25165824 bytes

Redo Buffers                    532480 bytes

 

 

2.      Set the default device type to disk using the CONFIGURE command, and then show the stored value with the SHOW command.

 

<RMAN> configure default device type to disk;

 

new RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

new RMAN configuration parameters are successfully stored

 

RMAN> show default device type;

 

RMAN configuration parameters are:

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

 

RMAN>

 

 

3.      Set the disk device type to the degree of parallelism of three using the CONFIGURE command, and then show the stored value with the SHOW command.

 

RMAN> configure device type disk parallelism 3;

 

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

new RMAN configuration parameters are successfully stored

 

RMAN> show device type;

 

RMAN configuration parameters are:

CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

 

RMAN>

 

 

4.      Set the channel to specify the format to your backup directory and a maxpiecesize setting of 50Meg using the CONFIGURE command, and then show the stored value with the SHOW command. This needs to be performed in a single configure channel command.

 

<RMAN> configure channel device type disk

2> format ='D:\backup\%U' maxpiecesize 50m;

 

old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50 M;

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'D:\backup\%U' MAXPIECESIZE 50 M;

new RMAN configuration parameters are successfully stored

 

RMAN> show channel;

 

RMAN configuration parameters are:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'D:\backup\%U' MAXPIECESIZE 50 M;

 

RMAN>

 

 

5.      Use the SHOW command to show all of the current settings.

 

RMAN> show all;

 

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

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

CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

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

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

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'D:\backup\%U' MAXPIECESIZE 50 M;

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\901\DATABASE\SNCFORCL.ORA'; #

default

 

RMAN>

 

 

This completes this practice.

 

 

 

ã Oracle Corporation, 2002

1