Online Backup Oracle 7.3

Hi DBA's

It is not a problem to write a script, which performs online backup. But I want my backup dynamic, so if an ekstra datafile is added, it is automatically added to the backup routine.

The platform is Digital Alpha NT, but thats not important. I had in mind, that the script out of the DBA_TABLESPACES and DBA_DATA_FILES using dynamic SQL should create another SQL script like this:

alter tablespace SYSTEM begin backup;
!ntbackup /a /v c:\orant\database\system01.dbf
!ntbackup /a /v c:\orant\database\system02.dbf
alter tablespace SYSTEM end backup;
alter tablespace TABSPC1 begin backup;
!ntbackup /a /v c:\orant\database\tabspc01.dbf
!ntbackup /a /v c:\orant\database\tabspc02.dbf
alter tablespace TABSPC1 end backup;

and so on for each for each tablespace and datafile..... Unfortunately my PL/SQL is not that good, so I hope that you can help me!

Henrik Ørsted Hansen Received on Thu May 28 1998 - 05:13:38 CDT