I can outline the procedure, If you want including the syntax etc., I have to do that tomorrow from my desk:

1) bkup_begin.sql ( main script calls 2 script)

Setup the environment, meaning ORACLE_SID and ORACLE_HOME and call cr_tslistbegin.sql

2)cr_tslistbegin.sql (calls 3 script)

Use SQL to build SQL commnd 'ALTER tablespace xyz BEGIN BACKUP' from DBA_TABLESPACES view and spool it to tslistbegin.sql

3)tslistbegin.sql (Which contains striped out ALTER TABLESPACE Bacup BEGIN commands)

3a)tslistend.sql (Which contains striped out ALTER TABLESPACE Backup END commands)

2a)cr_tslistend.sql (calls 3a script)

Use SQL to build SQL commnad 'ALTER tablespace xyz END BACKUP ONLINE' using DBA_TABLESPACES view and spool it to tslistend.sql

1a)bkup_end.sql ( main end script calls 2a script)

Setup the environment, meaning ORACLE_SID and ORACLE_HOME and call cr_tslistend.sql

In simple terms:
1:Set environment
2,3: tablespace for backup and back it up
2a,3a:END backup.

Finally dump controlfile to trace using:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

I know the syntax what I typed in z wrong. Check for syntax.

Thanks for correcting me.




[Edited by sreddy on 02-07-2001 at 03:35 PM]