Backup and Recovery Tip 1
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
Also you can use the following statement:
Select 'alter tablespace '||tablespace_name||' end backup' from dba_tablespaces;