WEB开发网
开发学院数据库Oracle oracle联机热备份的原理 阅读

oracle联机热备份的原理

 2007-05-09 12:11:56 来源:WEB开发网   
核心提示: /u02/oradata/sales/users01.dbf USERSONLINE 545498/u02/oradata/sales/example01.dbf EXAMPLEONLINE 545926/u02/oradata/sales/perfstat.dbfPERFSTAT ONL

/u02/oradata/sales/users01.dbf  USERS   ONLINE           545498

/u02/oradata/sales/example01.dbf EXAMPLE  ONLINE           545926

/u02/oradata/sales/perfstat.dbf PERFSTAT  ONLINE           545926

6 rows selected.

显然,在将users表空间置于backup状态的时候,相应的datafile的文件头的scn就不会再发生改变,

发生检查点也不会改变。

SQL> alter system checkpoint;

System altered.

SQL> select NAME,TABLESPACE_NAME,STATUS,CHECKPOINT_CHANGE# from v$datafile_header;

NAME        TABLESPACE STATUS    CHECKPOINT_CHANGE#

-------------------------------- ---------- -------------- ------------------

/u02/oradata/sales/system01.dbf SYSTEM   ONLINE           546196

/u02/oradata/sales/undotbs01.dbf UNDOTBS1  ONLINE           546196

/u02/oradata/sales/sysaux01.dbf SYSAUX   ONLINE           546196

/u02/oradata/sales/users01.dbf  USERS   ONLINE           545498

/u02/oradata/sales/example01.dbf EXAMPLE  ONLINE           546196

/u02/oradata/sales/perfstat.dbf PERFSTAT  ONLINE           546196

6 rows selected.

下面end backup,看看scn

SQL> alter tablespace users end backup;

Tablespace altered.

SQL> alter system checkpoint;

System altered.

SQL>select NAME,TABLESPACE_NAME,STATUS,CHECKPOINT_CHANGE# from v$datafile_header;

上一页  1 2 3 4 5 6  下一页

Tags:oracle 联机 备份

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接