If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Thanks Jeff and Sam. I solved the problem! I had tried to look for a solution for a while before I put my message on the web site. I am so glad that you guys help me out. In case of someone who has the same question as I did. I would like to share my experience with them. If there is anything incorrect, please feel free to correct me. The following are what I did:
1. Create RMAN script use Notepad and save the work as xxxxx.rman file. Example:
run {allocate channel c1 type disk;
backup database
tag ='rman_offline_backup'
format '\oracle\orabkup\tech\rmbkup\db_t%t_s%s_p%p'
(database);
backup current controlfile
tag='tech_contrlfile';
backup archivelog all;
release channel c1;
sql 'alter database open';}
2 Create Command file that will run the xxxxx.rman file. example:
sqlplus/nolog @ startrmbkup.sql ----- (execute the startrmbkup.sql to shutdown the target database and restart it in mount mode in order to perform consistent full database backup.)
rman rcvcat rmanuser/rmanuserpwd@recatalogname target dbusername/password @ targetdbname cmdfile=mytest.rman ------ (mytest.rman is the file I created in step one)
3 Schedule your job at the Command Prompt with the Ďatí command.

Thank you very much for your suggestions. Your last suggestion is exactly what I am looking for but donít know what to do yet. It would be greatly appreciated if you could give me some clue on how to clean up the backup file both from the recovery catalog and disk and how often should I do it. Thanks again.