双机dataguad备份容灾实施,慢慢完成

[@more@]

FAL_CLIENT
Parameter typeString
SyntaxFAL_CLIENT =string
Default valueThere is no default value.
Parameter classDynamic:ALTER SYSTEM
FAL_CLIENT specifies the FAL (fetch archive log) client name that is used by the
FAL service, configured through theFAL_SERVER parameter, to refer to the FAL
client. The value is an Oracle Net service name, which is assumed to be configured
properly on the FAL server system to point to the FAL client (standby database).
Given the dependency ofFAL_CLIENT onFAL_SERVER, the two parameters
should be configured or changed at the same time.
See Also:Oracle9i Data Guard Concepts and Administration for
more information about FAL server

FAL_SERVER
Parameter typeString
SyntaxFAL_SERVER =string
Default valueThere is no default value.
Parameter classDynamic:ALTER SYSTEM
FAL_SERVER specifies the FAL (fetch archive log) server for a standby database.
The value is an Oracle Net service name, which is assumed to be configured
properly on the standby database system to point to the desired FAL server.
See Also:Oracle9i Data Guard Concepts and Administration for
more information about FAL server

注意:

主库上面,只要设置log_archive_dest_n='SERVICE=从库服务名'
log_archive_dest_state_n=true;

从库上配置
fal_client;--指向自己
fal_server--指向主库服务名
standby_archive_dest路径

standby_file_management=auto;
就应该差不多能够运行了
当然要是从库
alter database recover managed standby database disconnect;置于数据库日志恢复模式运行才好

SQL> select dbid,name,log_mode,protection_mode,database_role,switchover_status
from v$database;
--查看数据库运行在何种模式下面，是否可以switchover切换
failover故障转移
SQL> col machine for a20
SQL> col program for a20
SQL> select sid,serial#,machine,program from v$session;

SQL> select process,status,client_process,group#,thread#,sequence# from v$managed_standby;
--standby database 上面会有Media Recovery Process,RFS(remote file server) 进程
PROCESS GROUP# THREAD# SEQUENCE#
------- ---------------------------------------- ---------- ----------
MRP0 N/A 1 54
RFS N/A 1 53

SQL> select name,description from v$bgprocess where paddr<>'00';--后台进程运行状况

SQL> select process,client_process,pid,status,thread#,sequence#
from v$managed_standby --主库只会有归档进程,注意仅针对physical standby database

SQL> select group#,thread#,sequence# from v$log;当前日志组统计

SQL> select group#,thread#,sequence#,used,archived,status from v$standby_log;

SQL>select dest_name,status,name_space,target,archiver,process,error,register,transmit_mode
from v$archive_dest where status='VALID';
--检查归档目的地是否有效,注册过的归档日志会应用到managed recovery operations
同步传输，还是异步的

SQL>select dest_name,status,type,database_mode,recovery_mode,protection_mode,destination
from v$archive_dest_status where status='VALID'

SQL>select name,dest_id,thread#,sequence#,registrar,applied
from v$archived_log ;--如果applied='YES'表明已经将归档日志应用到standby database上

以上语句用于检测是否正常工作,等下把switchover 和 failover 实验做好,再发

ITPub博客

双机dataguad备份容灾实施

最新文章