oracle查看灾备状态,Oracle灾备系统-DATAGUARD

5配置备库参数

LOG_ARCHIVE_DEST_2=‘SERVICE=standby LGWR ASYNC --此处为备库网络连接串VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby‘–备库的DB_UNIQUE_NAME

6.查看LOG_ARCHIVE_DEST_STATE状态

SQL> show parameter archive;

8.查看remote

SQL> show parameter remote;REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

9

备库相当于服务端主库相当于客户端主库不断相备库请求连接

FAL_SERVER=standby

FAL_CLIENT=primary

10查看主库和备库的数据文件路径和日志文件路径

SQL> select file_name from dba_data_files;

主库

备库

说明:‘/oracle/app/oradata/NANA’为主库数据\日志文件路径; ‘/oradata/STANDBY ‘为备库数据\日志文件路径

DB_FILE_NAME_CONVERT='/oracle/app/oradata/NANA ','/oradata/STANDBY‘

LOG_FILE_NAME_CONVERT='/oracle/app/oradata/NANA ','/oradata/STANDBY‘

11STANDBY_FILE_MANAGEMENT=AUTO

主库的初始化参数

*.audit_file_dest='/oracle/app/admin/NANA/adump'

*.background_dump_dest='/oracle/app/admin/NANA/bdump'

*.compatible='10.2.0.1.0'

*.control_files='/oracle/app/oradata/NANA/control01.ctl','/oracle/app/oradata/NANA/control02.ctl','/oracle/app/oradata/NANA/control03.ctl'

*.core_dump_dest='/oracle/app/admin/NANA/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16