dataguard参数文件笔记


dataguard参数文件笔记
 
环境：
#####################################################
主库：192.168.220.3
备库：192.168.220.4
主库和备库版本一致
 
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
主库db_name、sid
 
SQL> select instance_name from v$instance; 
INSTANCE_NAME
----------------
orcl
 
SQL>  show parameter db_name        
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      ice
 
##listener#################################################
主库：
# listener.ora Network Configuration File: /home/app/oracle10/product/10.2.0.1/network/admin/listener.ora
# Generated by Oracle configuration tools.
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/app/oracle10/product/10.2.0.1)
      (PROGRAM = extproc)
     )
      (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME =  /home/app/oracle10/product/10.2.0.1)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.3)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
 
"listener.ora" 24L, 617C
备库：
# listener.ora Network Configuration File: /home/app/oracle10/product/10.2.0.1/network/admin/listener.ora
# Generated by Oracle configuration tools.
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/app/oracle10/product/10.2.0.1)
      (PROGRAM = extproc)
     )
      (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME =  /home/app/oracle10/product/10.2.0.1)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.4)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
 
"listener.ora" 24L, 617C
 
###tnsnames################################################
主库：
# tnsnames.ora Network Configuration File: /home/app/oracle10/product/10.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
 
orcl  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
orcl2204  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.4)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
 
 
orcl  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
orcl2204  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.4)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
 
备库：
[oracle@localhost admin]$ vi tnsnames.ora
 
# tnsnames.ora Network Configuration File: /home/app/oracle10/product/10.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
 
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
 
orcl2204 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.4)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
##pfile#################################################
参数解释：此缓冲区是以512字节为单位的，可以在async参数中设置，比如async=20480,说明缓冲区为10M。
主库：/home/app/oracle10/product/10.2.0.1/dbs/initorcl.ora
[oracle@localhost dbs]$ cat initorcl.ora
orcl.__db_cache_size=92274688
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=62914560
orcl.__streams_pool_size=0
*.audit_file_dest='/home/app