使用LINUX的AT命令:比如在一天的某个时间定时备份。 运行脚本:./sqlplus internal/oracle @/oracle/home/hotbackup hotbackup脚本内容:alter tablespace tablespacename1 begin backup host cp yourdatafile /backup/yourbackup1datafile alter tablespace tablespacename1 end backupalter tablespace tablespacename2 begin backup host cp yourdatafile /backup/yourbackup2datafile alter tablespace tablespacename end backup . . . . alter tablespace tablespacenameN begin backup host cp yourdatafile /backup/yourbackupNdatafile alter tablespace tablespacenameN end backup
运行脚本:./sqlplus internal/oracle @/oracle/home/hotbackup
hotbackup脚本内容:alter tablespace tablespacename1 begin backup
host cp yourdatafile /backup/yourbackup1datafile
alter tablespace tablespacename1 end backupalter tablespace tablespacename2 begin backup
host cp yourdatafile /backup/yourbackup2datafile
alter tablespace tablespacename end backup
.
.
.
.
alter tablespace tablespacenameN begin backup
host cp yourdatafile /backup/yourbackupNdatafile
alter tablespace tablespacenameN end backup