Oracle 11G配置单实例DataGuard(三)
STANDBY LOGFILE ('/oradata/orcl/standbyredo31.dbf','/oradata/orcl/standbyredo32.dbf') SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE ('/oradata/orcl/standbyredo41.dbf','/oradata/orcl/standbyredo42.dbf') SIZE 50M;
启用real-time apply，从而实现real-time query：
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
(alter database recover managed standby database using current logfile disconnect from session)
Database altered.
验证real-time apply和real-time query：(同步时，主库的更改操作，必须加COMMIT生效)
Primary：
SQL> create table dave(id number,name varchar2(20));
Table created.
SQL> insert into dave values(1,'hello');
1 row created.
SQL> commit;
Commit complete.
Standby：
SQL>select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
SQL> select * from dave;
ID NAME
---------- ---------------
1 hello
备注：
select max(sequence#) from v$archived_log;
select dest_id, status, destination from v$archive_dest where status != 'INACTIVE';
select message from v$dataguard_status;
col destination for a10
select dest_id, status,type,database_mode,RECOVERY_MODE,DESTINATION,GAP_STATUS from v$archive_dest_status where dest_id=2;
DEST_ID STATUS TYPE DATABASE_MODE RECOVERY_MODE DESTINATIO GAP_STATUS
---------- --------- -------------- --------------- ----------------------- ---------- ------------------------
2 VALID PHYSICAL OPEN_READ-ONLY MANAGED REAL TIME APPLY standby NO GAP
COLUMN NAME FORMAT A24
COLUMN VALUE FORMAT A16
COLUMN DATUM_TIME FORMAT A24
SELECT NAME, VALUE, DATUM_TIME FROM V$DATAGUARD_STATS;
NAME VALUE DATUM_TIME
------------------------ ---------------- ------------------------
transport lag +00 00:00:00 06/18/2009 12:22:06
apply lag +00 00:00:00 06/18/2009 12:22:06
apply finish time +00 00:00:00.000
estimated startup time 9
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate channel prmy5 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'Chicago','Boston'
set 'db_unique_name'='Boston'
set standby_file_management='AUTO'
set db_create_file_dest='+DATA'
set db_recovery_file_dest='+FLASH'
set DB_RECOVERY_FILE_DEST_SIZE='8G'
set dg_broker_start='TRUE'
set control_files='+DATA/boston/controlfile/control01.ctl'
nofilenamecheck
;
}