Oracle数据库热备数据文件.doc

Oracle数据库热备数据文件oracle数据库实现热备数据文件的方法oraclerhel5 jia$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 7 20:33:50 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionssysJSL select name,checkpoint_change# from v$datafile;NAME CHECKPOINT_CHANGE#- -/jia/system01.dbf 1886900/jia/undotbs01.dbf 1886900/jia/sysaux01.dbf 1886900/jia/users01.dbf 1886900/jia/stone01.dbf 1886900所有的checkpoint_change#都是一样的。sysJSL select * from v$backup; FILE# STATUS CHANGE# TIME- - - - 1 NOT ACTIVE 0 2 NOT ACTIVE 0 3 NOT ACTIVE 0 4 NOT ACTIVE 0 5 NOT ACTIVE 0没有处于备份状态的文件,这些文件都是正常的.非备份ACTIVE状态.sysJSL select tablespace_name from dba_tablespaces;TABLESPACE_NAME-SYSTEMUNDOTBS1SYSAUXTEMPUSERSTS_STONEsysJSL alter tablespace ts_stone begin backup;Tablespace altered.sysJSL select * from v$backup; FILE# STATUS CHANGE# TIME- - - - 1 NOT ACTIVE 0 2 NOT ACTIVE 0 3 NOT ACTIVE 0 4 NOT ACTIVE 0 5 ACTIVE 1889512 20101207 20:42:31sysJSL select name,checkpoint_change# from v$datafile;NAME CHECKPOINT_CHANGE#- -/jia/system01.dbf 1886900/jia/undotbs01.dbf 1886900/jia/sysaux01.dbf 1886900/jia/users01.dbf 1886900/jia/stone01.dbf 1889512stone01.dbf号最大，因为它单独存盘了。发生完全检查点sysJSL alter system checkpoint;System altered.sysJSL select name,checkpoint_change# from v$datafile;NAME CHECKPOINT_CHANGE#- -/jia/system01.dbf 1889562/jia/undotbs01.dbf 1889562/jia/sysaux01.dbf 1889562/jia/users01.dbf 1889562/jia/stone01.dbf 1889512stone01.dbf的scn号没有变化,因为它存盘了,但是没有写文件头,文件头被冷冻了.其它文件头都写入了最新的scn,使得stone01.dbf的scn号变为最小了.sysJSL host cp /jia/stone01.dbf /bak/stone01.dbf拷贝这个文件,但不保证完整性,因为有交易存在,所以拷贝的是一个垃圾文件.sysJSL alter tablespace ts_stone end backup;Tablespace altered.sysJSL select * from v$backup; FILE# STATUS CHANGE# TIME- - - - 1 NOT ACTIVE 0 2 NOT ACTIVE 0 3 NOT ACTIVE 0 4 NOT ACTIVE 0 5 NOT ACTIVE 1889512 20101207 20:42:31sysJSL select name,checkpoint_change# from v$datafile;NAME CHECKPOINT_CHANGE#- -/jia/system01.dbf 1889562/jia/undotbs01.dbf 1889562/jia/sysaux01.dbf 1889562/jia/users01.dbf 1889562/jia/stone01.dbf 1889562所有文件头又一致了,文件头解冻了,一切正常了.我们书写一个脚本来完成备份的工作.select alter tablespace |tablespace_name| begin backup;|chr(10)|host c