WINDOWS2000下備份ORACLE
set termout off
set echo off head off feedback off pagesize 0spool E:\BACKUPDB\other\backup_ts.sql
select 'ARCHIVE LOG LIST;' || CHR(10) || CHR(10) from dual; select
'ALTER TABLESPACE ' || TABLESPACE_NAME || ' BEGIN BACKUP;' || CHR(10) ||
'host copy ' || FILE_NAME || ' ' || REPLACE(FILE_NAME,'D:','E:') || CHR(10) ||
'ALTER TABLESPACE ' || TABLESPACE_NAME || ' END BACKUP;' || CHR(10)
from dba_data_files;select 'ALTER DATABASE BACKUP CONTROLFILE TO ' || REPLACE(NAME,'D:','E:') || ';' || CHR(10) || CHR(10)
from v$controlfile;select 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE;' || CHR(10) || CHR(10) from dual; select 'ARCHIVE LOG LIST;' || CHR(10) || CHR(10) from dual; select 'ALTER SYSTEM ARCHIVE LOG CURRENT;' || CHR(10) || CHR(10) from dual; select 'ARCHIVE LOG LIST;' from dual;spool offspool E:\BACKUPDB\other\backup.log
@e:\backupdb\other\backup_ts.sql
spool offset termout on
set echo on head on feedback on termout on
set termout off
set echo off head off feedback off pagesize 0spool E:\BACKUPDB\other\backup_ts.sql
select 'ARCHIVE LOG LIST;' || CHR(10) || CHR(10) from dual; select
'ALTER TABLESPACE ' || TABLESPACE_NAME || ' BEGIN BACKUP;' || CHR(10) ||
'host copy ' || FILE_NAME || ' ' || REPLACE(FILE_NAME,'D:','E:') || CHR(10) ||
'ALTER TABLESPACE ' || TABLESPACE_NAME || ' END BACKUP;' || CHR(10)
from dba_data_files;select 'ALTER DATABASE BACKUP CONTROLFILE TO ' || REPLACE(NAME,'D:','E:') || ';' || CHR(10) || CHR(10)
from v$controlfile;select 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE;' || CHR(10) || CHR(10) from dual; select 'ARCHIVE LOG LIST;' || CHR(10) || CHR(10) from dual; select 'ALTER SYSTEM ARCHIVE LOG CURRENT;' || CHR(10) || CHR(10) from dual; select 'ARCHIVE LOG LIST;' from dual;spool offspool E:\BACKUPDB\other\backup.log
@e:\backupdb\other\backup_ts.sql
spool offset termout on
set echo on head on feedback on termout on
解决方案 »
- 关于oracle正则表达式的问题
- 求助一条查询语句!万分感谢!!
- Oracle 9i2中。想导入第三方的Jar包,需要怎么操作呢?
- oracle7的数据如何导入到oracle9i中?
- referencing new as n for each row 表示什么意思??
- Oracle里面 start with connect by 如果取查出来的最后的一个值?
- exp的问题
- oem导入导出备份任务不能执行,提示验证失败!
- 安装Oracle重启后,为何系统登录不进去?(在线等待)
- 请教一个初级问题:我刚装好了Oracle9i,狂耗内存,如何解决啊?
- 新手请教高手,怎样建一个表,数据来自另一个表呢?
- declare问题
看看这
echo 是否现实执行的命令内容
feedback 是否现实 * rows selected
pagesize 页面大小设置可分开写
set echo on/off
set feedback on/off
set pagesize 999