部署STANDBY数据库

这个例子是在不同主机服务器部署
1.在备份主机创建相关目录，保持与原数据库相同的目录结构。从原数据库生成init文件，修改实例名和服务名，但一定要保留数据库名不变

oracle@ittest:~/product/dbs> cat initmydb1.ora
*.aq_tm_processes=1
*.background_dump_dest='/u01/ora9/admin/mydb1/bdump'
*.compatible='9.2.0.0.0'
#*.control_files='/u01/ora9/oradata/mydb1/control01.ctl','/u01/ora9/oradata/mydb1/control02.ctl','/u01/ora9/oradata/mydb1/control03.ctl'
*.control_files='/u01/ora9/oradata/mydb1/standby.ctl'
*.core_dump_dest='/u01/ora9/admin/mydb1/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='mydb1'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=mydb1XDB)'
*.fast_start_mttr_target=300
*.global_names=FALSE
*.hash_join_enabled=TRUE
*.instance_name='standby'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.log_archive_dest_1='LOCATION=/u01/ora9/oradata/mydb1/archive'
*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS2'
*.service_names='standby'
*.standby_archive_dest='/u01/ora9/oradata/mydb1/archive'
*.user_dump_dest='/u01/ora9/admin/mydb1/udump'
oracle@ittest:~/product/dbs>

2.创建口令文件
oracle@ittest:~/product/dbs> orapwd file=orapwSTANDBY password=sys entries=3

3.配置服务
oracle@ittest:~/product/network/admin> cat listener.ora
# LISTENER.ORA Network Configuration File: /u01/ora9/product/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /u01/ora9/product)
      (SID_NAME = mydb1)
      (service_name = STANDBY)
    )
  )

oracle@ittest:~/product/network/admin>

PRIMARY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mydb1)
    )
  )

STANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (CONNECT_DATA =
    (service_name = STANDBY)
)
  )

4.备份原数据库，并将生成的文件传递到备份主机，目录与原数据库的目录必须一样

run{
 allocate channel d1 type disk;
 backup  incremental level = 0
 database
 format '/backup/db_%d_%s_%p_%t.dbf'
 tag='whole_inco'
 include current controlfile for standby;
 sql "alter system archive log current";
 sql "alter system archive log current";
 backup archivelog all
 format '/backup/ar_%d_%s_%p_%t.arc';
}

5.创建STANDBY数据库，在备份主机运行

oracle@ittest:~/product/bin>sqlplus /nolog
SQL>connect / as sysdba

SQL>startup nomount pfile='/u01/ora9/product/dbs/initmydb1.ora'

oracle@ittest:~/product/bin>

oracle@ittest:~/product/bin> ./rman

Recovery Manager: Release 9.2.0.6.0 - Production

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

RMAN> connect target sys/sys@PRIMARY

connected to target database: mydb1 (DBID=3061999746)

RMAN> connect auxiliary sys/sys

connected to auxiliary database: mydb1 (not mounted)

run{
   set command id to 'Standby Creation';
   allocate auxiliary channel d1 type disk;
   duplicate target database for standby dorecover nofilenamecheck;
}

6.启动管理恢复，原数据库自动传递日志，standby数据库自动应用日志
SQL>recover managed standby database;

alter system set log_archive_dest_2="SERVICE=STANDBY  optional";--在原数据库运行

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26870952/viewspace-735680/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26870952/viewspace-735680/