oracle sql and dba tutorial logo

Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step



Oracle SQL

Tutorial for Oracle SQL

 

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions


Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.



Configuring Settings in RMAN

Configuring AUTOBACKUP of CONTROLFILE  and SPFILE

You can configure RMAN to take backup of Control File & SPFILE whenever any type of backup is taken using RMAN.

Note: If you are using RMAN without Recovery Catalog then it's recommended to Turn ON auto backup of Control file and SPFILE.

To configure Control File and SPFILE AUTOBACKUP give the following command

RMAN> configure controlfile autobackup on;

controlfile autobackup

Once you give the above command RMAN will automatically takes the backup of control file and server parameter file in the directory specified in DB_RECOVERY_FILE_DEST

Like for example, when we take the backup of a particular tablespace, RMAN will take backup of Control File and SPFILE as shown in the output below

autobackup_2

Turning of AUTOBACKUP of Control File and SPFILE

To turn OFF automatic backup of Control File and SPFILE, give the following command

RMAN> configure controlfile autobackup off;

Configuring the Default Type for Backups

Whenever you give BACKUP command in RMAN, you can tell RMAN to take backup as BACKUPSET or IMAGE copy by configuring the device type.

For example, to take backup as backupset as default whenever you give backup command, give the following command at RMAN prompt

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;

To take backup as IMAGE COPY as default whenever you give backup command

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

You can even configure backups to be compressed when you give backup command by issuing the following command

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;

 

 

 


HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats


Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved