你做个批处理,定时exp,添加到任务计划里就行了
解决方案 »
- 急急急,linux,sqlplus 命名出错 ORA-12547: TNS:lost contact
- 请教大侠,在oracle中,什么是machine arithmetic,什么是library arithmetic啊
- ORACLE外连接分组问题
- 为何 rownum 后很慢!!!
- proc 程序连接数据库 ORA-01034: ORACLE not available
- 把SQL server存储过程改成oracle存储过程。。
- oracle9.0数据库导入导出问题
- 如果操作系统崩溃,安装的oracle数据库不能使用,但有备份文件,重装操作系统后如何才能恢复原来的数据库?
- 公交换乘问题
- 请问怎么样把一SELECT语句造型成一个表,从而取的表的rowtype?
- 如何进行UTL_FILE的异常捕捉
- OCP
rem script:hotbak.sql
rem creater:chenjiping
rem date:4.4.2002
rem desc:backup database datafile in archive--connect database
connect internal/virpure;--archive
alter system checkpoint;
alter system archive log all;
alter system switch logfile;
--start
alter tablespace afis_remote begin backup;
!xcopy e:\orant\database\remote_data1.ora e:\databak/H/R;
!xcopy e:\orant\database\remote_data2.ora e:\databak/H/R;
alter tablespace afis_remote end backup;alter tablespace afis_rmtafis begin backup;
!xcopy e:\orant\database\rmtafis_data1.ora e:\databak/H/R;
!xcopy e:\orant\database\rmtafis_data2.ora e:\databak/H/R;
alter tablespace afis_rmtafis end backup;alter tablespace afis_lquser begin backup;
!xcopy e:\orant\database\lquser_data.ora e:\databak/H/R;
alter tablespace afis_lquser end backup;alter tablespace afis_transf begin backup;
!xcopy e:\orant\database\transf1_data.ora e:\databak/H/R;
!xcopy e:\orant\database\transf2_data.ora e:\databak/H/R;
alter tablespace afis_transf end backup;alter tablespace system begin backup;
!xcopy e:\orant\database\sys1afis.ora e:\databak/H/R;
alter tablespace system end backup;alter tablespace rbs begin backup;
!xcopy e:\orant\database\rbs1afis.ora e:\databak/H/R;
alter tablespace rbs end backup;alter tablespace usr begin backup;
!xcopy e:\orant\database\usr1afis.ora e:\databak/H/R;
alter tablespace usr end backup;
alter tablespace temporary begin backup;
!xcopy e:\orant\database\tmp1afis.ora e:\databak/H/R;
alter tablespace temporary end backup;
--end--bak control file
--bin
alter database backup controlfile to 'e:\databak\controlbinbak.000';
--ascii
alter database backup controlfile to trace;alter system switch logfile;
alter system switch logfile;
-------------------------------
以下是805中调用备份的批处理文件,可以加到任务计划中
rem script:hotbak.bat
rem creater:chenjiping
rem date:4.4.2002
rem desc:backup database datafile in archiveecho del old temp backup file
del f:\datatmp\*.*/q
del e:\datatmp\*.*/q
echo bak backup file to temp
move e:\databak\*.* e:\datatmp\
move f:\Archive\*.* f:\datatmp\
echo start new bak to f:\databak
svrmgr30 @e:\sql\hotbak.sql
---------------------------
需要你自己稍微修改一下,以上的做法是先保留上一次的备份到临时目录,再进行本次的备份,如果备份正确,就可以用本次的备份了,上次的临时备份在下次备份是自动被删除。
一直再用