Purpose: Backup whole database by rman and then compress it by winrar, 
         also delete the old backup sets
Auth: Alex zeng | Skype me: hans9zeng
Date: 2006.03.07

1. How to run?
   run run_rman.bat, also you can add it to your schedule tasks list
   check log files run.sql.log and rman logfile F:\backupdata\poi6\rmanbackup\poi6_"date".log

2. What's the purpose of each file?
   run_rman.bat:     main batch script
   run_sql.txt:      sql script for backup controlfile to trace
   rman_cmf.txt:     rman script for backup database and old archived logs
   run_bak_ctl.txt:  sql script for backup controlfile
   restore_steps.txt:steps for restore whole database from backup files
   
3. What's the processes of this scripts?
   Step1. delete old backup files.
   Step2. create controlfile trace file and then copy it to the backup folder
   Step3. rum rman backup scritps 
   Step4. using winrar compress the backup files

4. Which parameters do you need to modify before using?
   paths in run_rman.bat, rman_cmf.txt, run_bak_ctl.txt
   NowDate, Month, Day definition in run_rman.bat according to your windows system.
   winrar in run_rman.bat. You may need add the path of winrar to system path or use absolute path

@echo on

echo "----------start----------"
set oracle_sid=poi

set bakscrp_base=D:\backup\rman\poi6
set bakdata_base1=F:\backupdata\poi6
set bakdata_base=F:\backupdata\poi6\rmanbackup
set controlfile_trc=E:\Oracle\admin\poi\udump

set cmdfile=%bakscrp_base%\rman_cmf.txt
set logfile=%bakdata_base%\

set NowDate=%DATE:~-10%
set Month=%NowDate:~5,2%
set Day=%NowDate:~8,2%

set logfile=%logfile%POI6_%Month%%Day%.log
set rarfile=F:\backupdata\poi6\%oracle_sid%_%Month%%Day%_rman.rar

del /Q %bakdata_base1%\*
del /Q %bakdata_base%\*
del /Q %controlfile_trc%\*

sqlplus "/ as sysdba" @run_sql.txt > run.sql.log
move %controlfile_trc%\* %bakdata_base%

rman nocatalog target=sys/oracle msglog=%logfile% cmdfile=%cmdfile%
sqlplus "sys/oracle as sysdba" @run_bak_ctl.txt >> run.sql.log
winrar a %rarfile% %bakdata_base%

echo "----------end----------"

alter database backup controlfile to trace;
exit;

set snapshot controlfile name to 'F:\backupdata\poi6\rmanbackup\snap_ctlfile.ctl';
run
 {
  allocate channel c1 type disk format 'F:\backupdata\poi6\rmanbackup\poi6_%U';
  backup filesperset 4 database;
  sql 'alter system archive log current';
  backup current controlfile;
  release channel c1;
 };
run{
allocate channel c1 type disk format 'F:\backupdata\poi6\rmanbackup\poi6_arch_%U';
backup archivelog until time 'trunc(SYSDATE)-7' delete input;
release channel c1;
};

exit;

alter system archive log current;
alter database backup controlfile to 'F:\backupdata\poi6\rmanbackup\poi6_backup.ctl';
exit;

1. copy initpoi.ora file to E:\Oracle\Ora81\DATABASE\initpoi.ora
copy backup controlfile POI6_BACKUP.CTL to E:\Oracle\oradata\poi\CONTROL01.CTL,CONTROL02.CTL,CONTROL03.CTL

2. startup poi service and mount database
startup mount

3.
rman nocatalog target / 
rman> 
run
  {
   allocate channel c1 type disk format 'F:\backupdata\poi6\rmanbackup\poi6_%U';
   restore database;
   recover database;
   release channel c1;
  }
 exit;

RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 28391 scn 496015137 found to restore

4.copy log file to F:\oradata\poi\archive from sequence 28391

5.
SQL> conn / as sysdba
Connected.
SQL> recover database using backup controlfile until cancel;
auto

SQL> recover database using backup controlfile until cancel;
cancel

SQL> alter database open resetlogs;