Oracle dataguard之备库切换（failover）

oracle 11g中有一个新特性叫flush redo，就是说如果主库挂了，只要能mount，就可以将没传到备库的online redo log信息刷到备库去，这样就不会有数据丢失。

1.在主库flush redo到备库

这里强调只有在mount的时候才能flush redo，看实验。

SQL> alter system flush redo to orcl_pd;
alter system flush redo to orcl_pd
                           *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> alter system flush redo to 'orcl_pd';--这里记住名字得加上引号，并且这个名字是tnsname中的备库连接名。
alter system flush redo to 'orcl_pd'
*
ERROR at line 1:
ORA-16445: Database has to be mounted and cannot be open


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size		    2253784 bytes
Variable Size		 1006636072 bytes
Database Buffers	  637534208 bytes
Redo Buffers		    7094272 bytes
Database mounted.
SQL> alter system flush redo to '