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

Oracle数据库热备数据文件 oracle数据库实现热备数据文件的方法 [oracle@rhel5 jia]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 7 20:33:50 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options sys@JSL 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#都是一样的。 sys@JSL 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状态. sys@JSL select tablespace_name from dba_tablespaces; TABLESPACE_NAME -------------------- SYSTEM UNDOTBS1 SYSAUX TEMP USERS TS_STONE sys@JSL alter tablespace ts_stone begin backup; Tablespace altered. sys@JSL 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 188951220:42:31 sys@JSL select name,checkpoint_change# from v$datafile; NAME CHECKPOINT_CHANGE# ------------------------------ ------------------ /jia/system01.dbf 1886900 /jia/undotbs01.dbf 1886900 /jia/sysaux01.dbf