pdg configuration

1.primary host:
archive log list;

alter database force logging;

select FORCE_LOGGING from v$database;

alter system switch logfile;

select * from v$logfile;

alter database add standby logfile group 4 ('?/redo04.log') size 5m;
alter database add standby logfile group 5 ('?/redo05.log') size 5m;
alter database add standby logfile group 6 ('?/redo06.log') size 5m;

select * from v$logfile;

show parameter spfile;

create pfile='/u01/pfile.ora' from spfile;

vi  pfile.ora
############################################################################
*.db_unique_name='10gpri'
*.fal_client='10gstandby'
*.fal_server='10gpri'
*.log_archive_config='DG_CONFIG=(10gpri,10gstandby)'
*.log_archive_dest_1='LOCATION=/u01/oradata/log VALID_FOR=(all_logfiles,all_roles) db_unique_name=10gpri'
*.log_archive_dest_2='service=10gstandby arch async valid_for=(online_logfiles,primary_role) db_unique_name=10gstandby'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.undo_management='AUTO'
############################################################################

startup pfile='/u01/pfile.ora' nomount;

create spfile from pfile='/home/db/oracle/10g/dbs/initora.ora';

shutdown immediate;

startup

############################################################################

网络配置：

vmdw1->cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
10GPRI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
VMDP1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmdp1)
    )
  )
10GSTANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.186)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
vmdw1->cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = vmdp1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = vmdp1)
    )
  )
vmdw1->

############################################################################

vmdw2->cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
10GPRI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
VMDP1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmdp1)
    )
  )
10GSTANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.186)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
vmdw2->cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.186)(PORT = 1521))
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = vmdp1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = vmdp1)
    )
  )
vmdw2->

############################################################################

lsnrctl start

sqlplus sys/orcl@10gpri as sysdba 测试监听是否正常。

shutdown immediate;

startup mount;

alter database create standby controlfile as '/u01/standby.ctl';

scp -r $ORACLE_BASE/admin/ oradata orapwd pfile.ora

 

2.standby host:

vi pfile.ora

controlfile='/u01/standby.ctl'

############################################################################

*.db_unique_name='10gstandby'
*.fal_client='10gpri'
*.fal_server='10gstandby'
*.log_archive_config='DG_CONFIG=(10gpri,10gstandby)'
*.log_archive_dest_1='LOCATION=/u01/oradata/log VALID_FOR=(all_logfiles,all_roles) db_unique_name=10gstandby'
*.log_archive_dest_2='service=10gpri arch async valid_for=(online_logfiles,primary_role) db_unique_name=10gpri'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.undo_management='AUTO'

############################################################################

startup nomount pfile='/u01/pfile.ora';

create spfile from pfile='/u01/pfile.ora';

shutdown immediate;

vi tnsnames.ora listener.ora

lsnrctl start

sqlplus sys/orcl@10gstandby as sysdba

3.primary host:

lsnrctl start

startup

4.
startup nomount;

alter database mount standby database;

alter database recover managed standby database disconnect from session;

select switchover_status from v$database;

select name from v$archived_log;

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archive/log1_87_676393126.arc';