Backup and Recovery Tips

Helpful statement to end the backup for the tablespaces

which are in the online backup mode:

1- Create a script through the following commands:
svrmgrl> spool endhotbackup.sql
svrmgrl> select 'ALTER DATABASE DATAFILE '''||name||''' END BACKUP ' FROM V$DATAFILE;

2- Cleanup endhotbackup.sql through vi

3- svrmgrl> @endhotbackup.sql

4- startup the database