Category Archives: RMAN

login in rman rman target sys/pass@production catalog rmancat/rman spool log to ‘mytext.log’; LIST BACKUP; spool log off;  

1. TO LIST ALL RMAN  stored script RMAN>LIST  SCRIPT NAMES;

1. First login to RMAN 2. create script yearly_backup comment “yearly backup of 2011 of Whole Database” { allocate channel t1 type ‘sbt_tape’ parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; sql “alter system switch logfile”; backup incremental level 0 database tag ‘year_closing_2011’ keep until time … Continue reading →

run { allocate channel t1 type ‘sbt_tape’ parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; #sql “alter system switch logfile”; backup incremental level 1 database; backup archivelog all; delete noprompt archivelog until time ‘sysdate -3’; }

run { allocate channel t1 type ‘sbt_tape’ parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; sql “alter system switch logfile”; backup incremental level 0 database; backup archivelog all; delete noprompt archivelog until time ‘sysdate -3’; }

Create Catalog Database and User 1. First Create a catalog database. 2.Log in as sys and create tablespace for RMAN backup; SQL> create tablespace rman_ts datafile ‘/cityfs/test/rman_ts01.dbf’ size 100M; Tablespace created. 3.Create the Recovery Catalog Owner in the database CREATE … Continue reading →

How to free flash recovery area ? Answer : delete the file manually from the operating system (using the ‘rm’ command) , the files should location should be known by the parameter db_recovery_file_dest For Example if db_recovery_file_dest = /data/recover Then … Continue reading →