我的STANDBY测试环境建立经验

cheong

Standby database　的　Managed Recovery Mode

Put the standby database in mangaged recovery mode
有可用????????有可分別????

allanliao

原因是下面的参数设置失误：
standby_archive_dest = “location=H:\oradata\standby1\archive”
改成standby_archive_dest = “H:\oradata\standby1\archive”就OK。
谢谢诸位。

allanliao

一、        概要步骤
有了以下的INIT。ORA文件，再按照这里的步骤执行就简单多了。
Task Procedure
1 Either make a new backup of the primary database datafiles or access an old backup.
Creating the Standby Datafiles
2 Connect to the primary database and create the standby control file.
Creating the Standby Control File
3 Copy the backup datafiles and control filefrom the primary site to the standby site.
Transferring Files to the Standby Site
4 Create a service name for the standby database.
Configuring the tnsnames.ora File on the Primary Site
5 Configure the listener on the standby site so that it can receive the archived redo logs from the primary site.
Configuring the listener.ora File on the Standby Site
6 Set the initialization parameters for the primary database.
Configuring the Primary Database Initialization Parameter File
7 Create the standby initialization parameter file and set the initialization parameters for the standby database. Depending on your configuration, you may need to set filename conversion parameters.
Configuring the Standby Database Initialization Parameter File
8 Start the standby instance and mount the standby database.
Starting the Standby Instance
9 Manually change the names of the primary datafiles and redo logs in the standby control file for all files not automatically renamed using DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT in step 7. If step 7 renamed all files, skip this step.
Manually Renaming Standby Files Not Captured by Conversion Parameters
10 Manually enable initialization parameter changes on the primary database so that it can initiate archival to the standby site.
Enabling Changes to the Initialization Parameter Settings

二、        实验环境：
WIN2000 SERVER，NO PACK；
ORACLE 81630；
PRIMARY DATABASE：O816NT
STANDBY DATABASE：STANDBY1

三、        PRIMARY DATABASE的参数：
log_archive_start = true
log_archive_dest_1 = "location=D:\Oracle\oradata\o816nt\archive"
log_archive_dest_2 = "service=STANDBY1 mandatory"
log_archive_dest_state_2 = ENABLE
log_archive_format = O816NTT%TS%S.ARC
db_name = "o816nt"
instance_name = o816nt
service_names = o816nt
db_files = 256
control_files = ("D:\Oracle\oradata\o816nt\control01.ctl",
"D:\Oracle\oradata\o816nt\control02.ctl", "D:\Oracle\oradata\o816nt\control03.ctl"
open_cursors = 100
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 1024
shared_pool_size = 41943040
large_pool_size = 614400
java_pool_size = 20971520
log_checkpoint_interval = 100000
log_checkpoint_timeout = 1800
processes = 50
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240  # limit trace file size to 5M each
oracle_trace_collection_name = ""
background_dump_dest = D:\Oracle\admin\o816nt\bdump
user_dump_dest = D:\Oracle\admin\o816nt\udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
compatible = 8.1.0
sort_area_size = 655360
sort_area_retained_size = 65536
UTL_FILE_DIR = D:\ORACLE\O816NT\RDBMS\ADMIN

四、        STANDBY DATABASE的参数：
control_files = ("H:\oradata\standby1\CONTROL01.CTL"
lock_name_space = lckname
db_file_name_convert = "D:\ORACLE\ORADATA\O816NT","H:\ORADATA\STANDBY1"
log_file_name_convert="D:\ORACLE\ORADATA\O816NT","H:\ORADATA\STANDBY1"

STANDBY_ARCHIVE_DEST = "H:\oradata\standby1\archive"

log_archive_start = true
log_archive_dest = "H:\oradata\standby1\archive"
log_archive_format = O816NTT%TS%S.ARC

db_name = "o816nt"

# instance_name = o816nt
instance_name = standby1

# service_names = o816nt
service_names = standby1

db_files = 256
open_cursors = 100
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 1024
shared_pool_size = 20971520
large_pool_size = 614400
log_checkpoint_interval = 100000
log_checkpoint_timeout = 1800
processes = 50
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240  # limit trace file size to 5M each
# global_names = true

oracle_trace_collection_name = ""
# define directories to store trace and alert files
background_dump_dest = D:\Oracle\admin\standby1\bdump
#Uncomment this parameter to enable resource management for your database.
user_dump_dest = D:\Oracle\admin\standby1\udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
compatible = 8.1.0
sort_area_size = 655360
sort_area_retained_size = 65536
UTL_FILE_DIR = D:\ORACLE\O816NT\RDBMS\ADMIN

五、        相关NT服务：
1、        OracleServiceO816NT、OracleOra816ntTNSListener 为PRIMARY DATABASE O816NT的相关服务；
2、        OracleServicestandby1、OracleOra816ntTNSListenerlistenerstandby1为新的STANDBY DATABASE STANDBY1的相关服务；其中LISTENERSTANDBY1的服务通过配置LISTENER.ORA、然后运行LSNRCTL START LISTENERSTANDBY1命令得到；STANDBY1服务通过ORADIM –NEW –SID STANDBY1 –INTPWD ORACLE –STARTMODE M创建；

六、        启停脚本：
1、        先启动STANDBY数据库（否则要手工ENABLE  STANDBY归档目的地）：
REM  STARTSTANDBY1.BAT
set ORACLE_SID=standby1
oradim -startup -sid standby1
lsnrctl start listenerstandby1
sqlplus /nolog @d:\oracle\startstandby1

REM  STARTSTANDBY1.SQL
connect internal/oracle@standby1
startup nomount pfile=d:\oracle\admin\standby1\pfile\init.ora
alter database mount standby database;
exit
2、        后启动PRIMARY DATABASE：
REM  STARTO816NT.BAT
set ORACLE_SID=o816nt
oradim -startup -sid o816nt
lsnrctl start
REM  namesctl start
sqlplus /nolog @d:\oracle\starto816nt

REM  STARTO816NT.SQL
connect internal/oracle@o816nt
startup pfile=d:\oracle\admin\o816nt\pfile\init.ora
exit
3、        进入MANAGED STANDBY DATABASE模式：
SQL》 RECOVER MANAGED STANDBY DATABASE;

半瓶醋

i have a document about auto-standby database.
you can ask me if you have any question;

bluetooth

我认为standby对系统要求太高，主要指redo log必须完整，一旦primary db 作resetlog standby 只能从作。
还有就是standby切换成primary后就不能再作standby
当数据库很大，而两个database又不再同一地点，需要通过WAN作数据文件的复制，时间的消耗事不可忍受的

基于这种情况，我认为可以采用高级复制来实现异地数据库的镜象
达到备灾的目的

半瓶醋

Oracle 高级复制实在是是太麻烦了，还要去做什么冲突解决方案，我觉得太难用了。如果只是做备份与容灾，用高级复制好象有点得不偿失，但是在分布式数据库应用中，倒是可以考虑用复制技术来实现少量数据的同步，并且现在网络的速度可能会越来越快。

luckyoracle

麻烦发个MAIL吧，你们老做售前也不是个事儿啊。。。。。


lu_xy@sina.com

谢谢。。。

chao_ping

standby的完整配置过程在Oracle 817 Document里面有详细讲述。
包括这种情形下面的配置过程，可以参考。

orange

我个人认为选择standby 不如选择ops ,但是ops 的维护成本较高。
说到oracle的高级复制，我坚决反对使用，我们公司使用该模块，因为数据库关系复杂，冲突过多，造成我们整个系统的半瘫痪状态，而且维护起来十分复杂。我们正在考虑使用类似于db_copy的产品，替换掉高级复制。

chao_ping

quest 公司的产品shareplex也不错，比standby要强不少，也可以作为选择参考对象之一