Flashcopy与数据库恢复的完美结合(15/20)

1.5.4.10 查询主机A数据库A 的aidu.test04表的数据信息

SQL>select count(1) from aidu.test04;

SQL>select checkpoint_change# from v$database;

1.5.4.11 主机A数据库A进行归档日志切换，记载SEQ#和SCN

col name format a45

set line 200

select count(1) from aidu.test04;

alter system checkpoint;

alter system switch logfile;

select name,sequence#,first_change#,next_change# from v$archived_log;

select checkpoint_change# from v$database;

SQL> col name format a45

SQL> set line 200

SQL> select count(1) from aidu.test04;

90

SQL> alter system checkpoint;

SQL>alter system switch logfile;

select name,sequence#,first_change#,next_change# from v$archived_log;

NAME SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#

/archivelog/1_38_750759569.dbf 38 987740 989361

/archivelog/1_39_750759569.dbf 39 989361 989650

SQL> select checkpoint_change# from v$database;

992427

1.5.4.12 将数据库A设置为online backup模式

SQL> Select count(1) from aidu.test04;

121

SQL> Select checkpoint_change# from v$database;

992427

SQL> Alter database begin backup;

1.5.4.13 在DS8100_B上执行 resyncflash命令，同步flashcopy磁盘组

Dscli>resyncflash -record -persist 5000-5002:8000-8002 5100-5102:8100-8102

Dscli>lsflash –l 5000-9000

1.5.4.14 将数据库A退出online backup模式

SQL>alter database end backup;

上一篇：Flashcopy与数据库恢复的完美结合(14/20)

下一篇：Flashcopy与数据库恢复的完美结合(16/20)