ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dataguard相关配置参数备份

dataguard相关配置参数备份

原创 Linux操作系统 作者:BEANBLACK 时间:2009-05-09 20:49:24 0 删除 编辑

建立备用数据库:

run{
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
allocate auxiliary channel aux3 device type disk;
set until sequence=7 thread=1;
duplicate target database for standby dorecover;
}

 

备份数据库

run{
allocate channel d1 device type disk;
backup as compressed backupset
incremental level=0
format='D:\backup\inc0_%d_%U'
tag='inc0'
channel=d1
database;
sql "alter system switch logfile";
backup as compressed backupset
format='D:\backup\arch_%d_%u'
tag='arch'
channel=d1
archivelog all delete input;
backup as compressed backupset
format='D:\backup\standby.ctl'
tag='standby'
channel=d1
current controlfile for standby reuse;
}

 

STANDBY初始化参数:

*.audit_file_dest='D:\oracle\product\10.2.0/admin/standby/adump'
*.background_dump_dest='D:\oracle\product\10.2.0/admin/standby/bdump'
*.compatible='10.2.0.1.0'
*.control_files='D:\oracle\product\10.2.0\oradata\standby\control01.ctl','D:\oracle\product\10.2.0\oradata\standby\control02.ctl','D:\oracle\product\10.2.0\oradata\standby\control03.ctl'
*.core_dump_dest='D:\oracle\product\10.2.0/admin/standby/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orc1'
*.db_recovery_file_dest='D:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=standbyXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=200278016
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=600834048
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\product\10.2.0/admin/standby/udump'

lock_name_space='standby'
db_file_name_convert=('D:\oracle\product\10.2.0\oradata\orc1','D:\oracle\product\10.2.0\oradata\standby')
log_file_name_convery=('D:\oracle\product\10.2.0\oradata\orc1','D:\oracle\product\10.2.0\oradata\standby')
#切换备库为主库是要应用
*.log_archive_dest_1='location=D:\oracle\product\10.2.0\oradata\standby\archive'
*.log_archive_dest_2='service=standby'
*.standby_archive_dest='D:\oracle\product\10.2.0\oradata\standby\archive'
*.standby_file_management='AUTO'
*.fal_client='standby'
*.fal_server='orc1'
*.service_name='standby'
*.local_listener='(ADDRESS_LIST= (ADDRESS=(PROTOCOL = TCP)(HOST = wangjunliang)(PORT = 1521))(ADDRESS = (PROTOCOL = IPC)(KEY = standby)))'

 

LISTERNER.ORA:

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  (SID_DESC =
      (GLOBAL_NAME = orc1)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (SID_NAME= orc1)
    )
  (SID_DESC =
      (GLOBAL_NAME = standby)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (SID_NAME= standby)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = wangjunliang)(PORT = 1521))
    )
  )

TNSNAMES.ORA:

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = wangjunliang)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orc1)
    )
  )

standby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = wangjunliang)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = standby)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

 

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

请登录后发表评论 登录
全部评论

注册时间:2008-06-16

  • 博文量
    67
  • 访问量
    144069