RMAN related tasks

#how to reset RMAN persistent parameters back to their defaults

rman>configure retention policy clear;
rman>configure controlfile autobackup clear;
rman>configure channel device type disk clear;
rman>configure backup optimization on;
rman>configure backup optimization clear;

rman>show all;
rman>report schema;


#rman run script and from cmd shell
rman>@scropt_name.sql
rman target / cmdfile scropt_name

#how to modify where RMAN backup pieces are written on disk
rman backup def loc is

default:E:\APP\MANI\PRODUCT\11.1.0\DB_1\DATABASE\
ie oraclehome/database

rman>show all;

rman>configure channel device type disk format 'C:\rman-%d%s.bkp

d---db name
s----bkp set unique no


#how to multiplex RMAN backup pieces when running backup

rman>backup device type disk copies 3 database plus archivelog;
to make it persistent
rman>configure datafile backup copies for device disk to 3;
rman>configure ARCHIVELOG backup copies for device disk to 3;
how to multiplex archived log locations for an oracle db
show parameter log_archive_dest;
alter system set log_archive_dest_1='LOCATION=e:\archivelogs\' scope=spfile;
alter system set log_archive_dest_2='LOCATION=e:\archivelogs2\' scope=spfile;
alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=spfile;
archive log list;
to disable one location
alter system set log_archive_dest_state_2=defer scope=both;
change the default location and size limit for the rman backup
SQL> show parameter db_recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string E:\app\Mani\flash_recovery_are
a
db_recovery_file_dest_size big integer 2G
SQL> alter system set db_recovery_file_dest='D:\rmanbackup' scope=both;

System altered.

SQL> show parameter db_recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:\rmanbackup
db_recovery_file_dest_size big integer 2G
SQL> alter system set db_recovery_file_dest_size=20G scope=both;

System altered.

SQL> show parameter db_recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:\rmanbackup
db_recovery_file_dest_size big integer 20G
SQL>