Setup RMAN User, Catalog & Register
----------------------------------------------------------------------
MAKE SURE ALL DATABASE have PASSWORD FILE
sqlplus system/manager@rman <<__1
drop user rman_TEST cascade;
create user rman_TEST identified by rman_TEST
default tablespace users
temporary tablespace ts_temp
quota unlimited on users
quota unlimited on ts_temp ;
grant connect , resource, recovery_catalog_owner to rman_TEST;
exit
__1
# create the catalog
rman catalog rman_TEST/rman_TEST@rman << __2
create catalog;
exit
__2
rman target \"sys/pass9999@TEST as sysdba\" \
catalog rman_TEST/rman_TEST@rman << __3
register database ;
EXIT
__3 |
 |
Incremental Backup Script
---------------------------------------------------------------
resync catalog;
change archivelog all validate;
run{
allocate channel c1 type 'SBT_TAPE';
allocate channel c2 type 'SBT_TAPE';
backup
format '/intr/cf_t%t_s%s_p%p'
(current controlfile);
backup
incremental level 0
tag db_intr_0
filesperset 5
format '/intr/df_t%t_s%s_p%p'
(database);
sql 'alter system archive log current';
backup
filesperset 20
format '/intr/rl_t%t_s%s_p%p'
(archivelog all delete input);
release channel c1;
release channel c2;
} |
Full Backup Script – Hot Backup – Target DB in Archivelog Mode
------------------------------------------------------------------------------
run {
allocate channel c1 type disk;
set limit channel c1 kbytes 500000;
backup full
filesperset 2
(database format '/rman_backup/BACKUP/TEST_data_%U');
sql "alter system archive log current";
backup filesperset 10
format '/rman_backup/BACKUP/TEST_arch%U'
(archivelog all );
release channel c1;
}
exit; |
|
Full Backup Script – To Tape
-------------------------------------------------------
run {
allocate channel t1 type 'SBT_TAPE';
backup
format 'db_%d_t%t_s%s_p%p'
(database);
sql 'alter system archive log current';
backup
format 'arch_%d_t%t_s%s_p%p'
(archivelog all delete input);
} |
