Oracle完全脱机，部分脱机与部分联机备份(十二)
flash_recovery_area/ORCL/archivelog/2013_06_
02/o1_mf_1_173_8toyq5pz_.arc' no longer needed for this recovery
ORA-00279: change 13229463987395 generated at 06/02/2013 15:57:46 needed for
thread 1
ORA-00289: suggestion :
/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_0
2/o1_mf_1_175_%u_.arc
ORA-00280: change 13229463987395 for thread 1 is in sequence #175
ORA-00278: log file
'/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_
02/o1_mf_1_174_8toyqtt7_.arc' no longer needed for this recovery
ORA-00279: change 13229463987400 generated at 06/02/2013 15:57:50 needed for
thread 1
ORA-00289: suggestion :
/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_0
2/o1_mf_1_176_%u_.arc
ORA-00280: change 13229463987400 for thread 1 is in sequence #176
ORA-00278: log file
'/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_
02/o1_mf_1_175_8toyqyg1_.arc' no longer needed for this recovery
Log applied.
Media recovery complete.
--恢复之后，我们来查看下SCN号：
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229464008626
2 13229464008626
3 13229464008626
4 13229464008626
5 13229464008626
6 13229464008626
7 13229463987420
7 rows selected
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229464008626
2 13229464008626
3 13229464008626
4 13229464008626
5 13229464008626
6 13229464008626
7 0
7 rows selected
--还是0
因为需要把表空间ONLINE才看得到:
ALTER TABLESPACE tbs_lubinsu_data ONLINE;
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229464008626
2 13229464008626
3 13229464008626
4 13229464008626
5 13229464008626
6 13229464008626
7 13229464009374
7 rows selected
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229464008626
2 13229464008626
3 13229464008626
4 13229464008626
5 13229464008626
6 13229464008626
7 13229464009374
7 rows selected
--可见已经恢复成功了。
--当完全检查点实现的时候所有的SCN号都相同了，Oracle把所有的都同步了。有两种方法实现
1.shutdown的时候（也会执行alter SYSTEM CHECKPOINT）
2. ALTER SYSTEM CHECKPOINT
执行：alter SYSTEM CHECKPOINT：
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229464009991
2 13229464009991
3 13229464009991
4 13229464009991
5 13229464009991
6 13229464009991
7 13229464009991
7 rows selected
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ----