Prince_jr,

You realy need to take a break for some time, grab the Oracle Concepts manual and read it cover to cover. After you've done that, grab Oracle Admin manual and read it from cover to cover. And after you've done that, grab Backup and Recovery manuals and read them from cover to cover.... Then perhaps things will be clearer.

With the script you showed us it's evident you don't have a clue about what you are doing (BTW, I don't mean anything bad with this remark - noone was born wise). Obviously you are a true beginner in DBA field, so forget about setting events and simmilar advanced stuff. Start with the basics, like understanding what does it mean to take a plain cold backup.

So for start, take away from your backup script two things, as they are totaly useless for what you are doing:

- alter database backup controlfile to '$ARCH_CTRL_DIR/control.ctl' reuse;
- alter session set events '10400 trace name context forever, level 1';