Simple on-line backup script (put tablespaces in backup mode and copy out)

是用來產生如下之script


alter tablespace SYSTEM begin backup;
!cp -p /array/oracle/u02/oradata/DB/system01.dbf /array/db_mirror/
alter tablespace SYSTEM end backup;

alter tablespace TEMP begin backup;
!cp -p /array/oracle/u02/oradata/DB/temp01.dbf /array/db_mirror/
alter tablespace TEMP end backup;