ORACLE 11G SNAPSHOT STANDBY实例(二)
不允许的
查看日志传输状态
在SNAPSHOT STANDBY模式下，日志正常传输但不应用，下面语句进行确认
SQL> select to_char(SYSDATE,'yyyymmdd hh24:mi:ss') CTIME,NAME,VALUE,DATUM_TIME
from V$DATAGUARD_STATS
WHERE NAME LIKE '%lag'; 2 3
CTIME NAME VALUE DATUM_TIME
---------------- -------------------- -------------------- ------------------------------
20131030 11:34:35 transport lag +00 00:00:00 10/30/2013 11:34:34
20131030 11:34:35 apply lag +00 00:26:34 10/30/2013 11:34:34
transport lag 时间为0
apply lag 时间为26分34秒
我们将现在时间20131030 11:34:35 与之前 guaranteed restore point SNAPSHOT_STANDBY_REQUIRED_10/30/2013 11:08:18
时间对比，刚好将近26分钟
转换回PHYSICAL STADNBY
现在我们转换会PHYSICAL STANDBY ，确认在SANPSHOT STANDBY模式下所做的修改已经恢复，
必须在mount模式下进行操作
将
数据库切换到mount状态
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount;
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1365740 bytes
Variable Size 318769428 bytes
Database Buffers 197132288 bytes
Redo Buffers 5840896 bytes
Database mounted.
SQL> select database_role,db_unique_name,open_mode from v$database;
DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE
---------------- ------------------------------ --------------------
SNAPSHOT STANDBY ogg MOUNTED
convert to physical standby
SQL> alter database convert to physical standby;
Database altered.
查看alter log 可以看到
数据库进行falshback restore完成，并将闪回恢复区的文件delete
Wed Oct 30 11:40:36 2013
alter database convert to physical standby
ALTER DATABASE CONVERT TO PHYSICAL STANDBY (ogg)
Flashback Restore Start
Flashback Restore Complete
Drop guaranteed restore point
Stopping background process RVWR
Deleted
Oracle managed file /u01/arch/flasharch/OGG/flashback/o1_mf_970y12xh_.flb
Deleted Oracle managed file /u01/arch/flasharch/OGG/flashback/o1_mf_970y15og_.flb
Guaranteed restore point dropped
Clearing standby activation ID 2931571730 (0xaebc3c12)
SQL> ! ls -lt /u01/arch/flasharch/OGG/flashback
total 0
重启数据库到mount状态
SQL> select database_role,db_unique_name,open_mode from v$database;
select database_role,db_unique_name,open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00750: database has been previously mounted and dismounted
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1365740 bytes
Variable Size 318769428 bytes
Database Buffers 197132288 bytes
Redo Buffers 5840896 bytes
Database mounted.
确认PHYSICAL STANDBY状态
SQL> select database_role,db_unique_name,open_mode from v$database;
DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE
---------------- ------------------------------ --------------------
PHYSICAL STANDBY ogg MOUNTED
开启为READ ONLY-- REAL TIME APPLY状态
SQL> alter database open;
Database a