oracle9204(physical dg)配置_指南

首先強調一點，9204dg配置同10g差不多，就是區別在以下幾點上：
1,備庫spfile(pfile)
      *.log_archive_start=TRUE
       lock_name_space=second --其值為：sid(異於主庫喲）
       instance_name=second --同上理
*.remote_archive_enable='TRUE'



2,構建dg三大部件，注意事項如下:
    a,shutdown immediate主庫，cp或tar（select name from v$datafile)的資料檔案到指定地
    b,startup 主庫，alter database create standby controlfile as '';注意是open,而非10g中的執行在mount狀態
    c,構建用於備庫pfile
    d,啟動備庫時，先：startup mount,後：alter database mount standby database;
3，對於密碼檔案（主備庫），在備庫$ORACLE_HOME/dbs，請構建orapw,而非同於10g的orapw$ORACLE_SID，呵，，不然你試下，提示找不到密碼檔案（此出錯是在alter database mount standby database,你親愛的備庫喲）

3,如果你備庫各對應的dump目錄建立不全或不準確，會在startup nomount備庫，報如下錯誤：
[oracle@9istandby centos]$ sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Feb 4 14:46:29 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/oracle/oradata/centos/init9istandby.ora'
ORA-00444: background process "RECO" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL> host oerr ora 00444
00444, 00000, "background process \"%s\" failed while starting"
// *Cause:  Usually due to a bad (or non-existent) background process image.
// *Action: Get a good background process image.

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> exit
Disconnected
[oracle@9istandby centos]$ sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Feb 4 14:48:19 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/oracle/oradata/centos/init9istandby.ora'

SQL> startup nomount pfile='/oracle/oradata/centos/init9istandby.ora'
ORA-00444: background process "CKPT" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL> host oerr ora 07446
07446, 00000, "sdnfy: bad value '%s' for parameter %s."
// *Cause:  The directory specified as the value for the stated parameter could
//          not be used.
// *Action: Make sure the directory you have specified is a valid
//          directory/file specification.

SQL> exit