以下 是一般初学者学习过程的记录 如有错误请 各位大侠指正 。谢谢

環境：Vmware  Centos4.5  Oracle9i (9.2.0.4)
主庫：(Primary)IP:10.5.0.1 Dmo9i
備庫：(Standby)IP 10.5.0.2 Dmo9iDg
準備工作：Dmo9i 安裝完整的Oracle db
Dmo9iDg 只安裝 software
主庫配置：
一: tnsnames.ora 配置如下

pri =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10..5.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = misdb)
    )
  )
misdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.0.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = misdb)
    )
  )
二： 參數設置
在（/u01/oradata）建一個存放日誌文件的目錄(arch)
   
在initmisdb.ora 設置如下參數
*.log_archive_dest_1='LOCATION=/u01/oradata/arch'
*.log_archive_dest_2='service=misdg'
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.standby_archive_dest='/u01/oradata/arch'
*.fal_server=misdg
*.fal_client=pri
*.standby_file_management=AUTO
*.log_archive_start=TRUE
設置完成用
create spfile from pfile ;
三： 查看是否為歸檔(如不是歸檔)
SQL> startup mount  
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> alter database archivelog ;

Database altered.
SQL> archive log list ;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oradata/arch
Oldest online log sequence     71
Next log sequence to archive   73
Current log sequence           73

設置主庫為強行日誌處理
SQL> alter database force logging；

備庫配置：  
  1.應為在備庫上只安裝了software 所以要見監聽 （netmgr）
2. 建立目錄文件
[oracle@Dmo9iDg u01]$ mkdir admin
[oracle@Dmo9iDg u01]$ mkdir oradata
[oracle@Dmo9iDg u01]$ cd admin
[oracle@Dmo9iDg admin]$ ls
[oracle@Dmo9iDg admin]$ mkdir misdb
[oracle@Dmo9iDg admin]$ cd misdb
[oracle@Dmo9iDg misdb]$ ls
[oracle@Dmo9iDg misdb]$ mkdir bdump
[oracle@Dmo9iDg misdb]$ mkdir cdump
[oracle@Dmo9iDg misdb]$ mkdir udump
[oracle@Dmo9iDg misdb]$ mkdir pfile
[oracle@Dmo9iDg misdb]$ cd /u01/oradata/
[oracle@Dmo9iDg oradata]$ ls
[oracle@Dmo9iDg oradata]$ ls
[oracle@Dmo9iDg oradata]$ mkdir arch
[oracle@Dmo9iDg oradata]$ ls
arch
[oracle@Dmo9iDg oradata]$ mkdir misdb
3. tnsnames.ora 配置如下

pri =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10..5.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = misdb)
    )
  )
misdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.0.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = misdb)
    )
  )
4. 建立參數文件;
把主庫的initmisdb.ora考到備庫上修改參數如下：
ftp> get initmisdb.ora
local: initmisdb.ora remote: initmisdb.ora
227 Entering Passive Mode (10,5,0,1，95,190)
150 Opening BINARY mode data connection for initmisdb.ora (1239 bytes).
226 File send OK.
1239 bytes received in 0.00088 seconds (1.4e+03 Kbytes/s)
*.log_archive_dest_2='service=pri'
*.fal_server=pri
*.fal_client=misdg
*.standby_file_management=AUTO
*.lock_name_space=' misdg
去掉*.log_archive_start=TRUE
5.建立密碼文件 我一般直接把主庫的密碼文件拷貝到備庫上去
ftp> get orapwmisdb
local: orapwmisdb remote: orapwmisdb
227 Entering Passive Mode (10,5,0,1,72,121)
150 Opening BINARY mode data connection for orapwmisdb (1536 bytes).
226 File send OK.
1536 bytes received in 0.0079 seconds (1.9e+02 Kbytes/s)
ftp>
6.建立sid及spfile
[oracle@Dmo9iDg oradata]$ export ORACLE_SID=misdb
[oracle@Dmo9iDg oradata]$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Aug 16 08:51:53 2011

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
SQL> create spfile from pfile ;

File created.

SQL>
到此配置基本完成。
7.用rman 在主庫備份 ，腳本如下：
run {
crosscheck archivelog all;
crosscheck  backup;
delete noprompt obsolete;
delete noprompt expired backup;
allocate channel c1 type disk maxpiecesize 500M ;
allocate channel c2 type disk maxpiecesize 500M;
backup format '/u01/bk/%T_%d_%s_%p.dat' tag='full_db' database ;
backup format '/u01/bk/%T_%d_%s_%p.arc' tag='full_arc' archivelog all;
backup format '/u01/bk/%T_%d_%s_%p.ctl' tag='full_ctl' current controlfile;
backup format '/u01/bk/%T_%d_%s_%p.dgctl' tag='full_dg' current controlfile for standby;
release channel c1;
release channel c2;
}
把主庫rmna備份拷到備庫上去（注：目錄一定要和主庫目錄一致）
8.在主庫上

rman target / auxiliary sys/password@misdg
run {
sql 'alter system archive log current';
duplicate target database for standby  nofilenamecheck;
}
9.恢復完成，在備庫上
Shutdown immediate
Startup nomount
SQL> alter database  mount standby database ；
啟動redo應用
alter database recover managed standby database disconnect from session;
到此配置完成。


查看是不是配置成功：
在主庫上：
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oradata/arch
Oldest online log sequence     84
Next log sequence to archive   86
Current log sequence           86
SQL> alter system archive log current;

System altered.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oradata/arch
Oldest online log sequence     85
Next log sequence to archive   87
Current log sequence           87

備庫：
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /u01/oradata/arch
Oldest online log sequence     85
Next log sequence to archive   0
Current log sequence           87
SQL>
10.其他
  在配置用到的命令（tail –f   alter.Log在linux下查看 進程）

[ 本帖最后由 pingdanorcale 于 2011-8-16 14:22 编辑 ]