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.