oracle 11gdataguard搭建切换.pdf

dm5250

196

20页

1次

2024-09-11

25墨值下载

主备库IP 实例名 db_unique_name 版本

10.200.8.38 orcl orcl 11.2.0.4

10.200.40.38 orcl orclbak 11.2.0.4

⼀、主备库信息

⼆、主备库修改sys密码和密码⽂件

三、主库修改归档模式和强制logging模式

四、备库修改db_unique_name

alter user sys identified by "Sys_38";

orapwd file=/home/u01/oracle/product/11.2.0/dbhome_1/dbs/orapworcl password=Sys_38

entries=10

---19c简单密码

orapwd file=orapworadb1 password=oracle force=Y format=12

orapwd file=orapworadb2 password=oracle force=Y format=12

---rac环境中可以从asm中copy

srvctl config database -d orcl

pwcopy +DATA/orcl/PASSWORD/pwdorcl.xxx.xxxxxxxxxx /tmp/oraporcl1【

alter database archivelog;

alter database force logging;

select name, open_mode, log_mode, force_logging from v$database;

alter system set db_unique_name='orclbak' scope=spfile;

alter system set service_names='orcl';

SQL> show parameter name

NAME ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! TYPE ! ! ! VALUE

------------------------------------ ----------- ------------------------------

cell_offloadgroup_name ! ! ! ! ! ! ! string

db_file_name_convert ! ! ! ! ! ! ! ! string

db_name ! ! ! ! ! ! ! ! ! ! ! ! ! ! string ! ! orcl

db_unique_name ! ! ! ! ! ! ! ! ! ! ! string ! ! orclbak

五、主库增加standby redo

六、备库增加tnsnames和静态监听

global_names ! ! ! ! ! ! ! ! ! ! ! ! boolean ! ! FALSE

instance_name ! ! ! ! ! ! ! ! ! ! ! string ! ! orcl

lock_name_space ! ! ! ! ! ! ! ! ! ! string

log_file_name_convert ! ! ! ! ! ! ! string

processor_group_name ! ! ! ! ! ! ! ! string

service_names ! ! ! ! ! ! ! ! ! ! ! string ! ! orcl

alter database add standby logfile group 4 ('/home/u01/oradata/orcl/redo01_sdy.log') size

50M;

alter database add standby logfile group 5 ('/home/u01/oradata/orcl/redo02_sdy.log') size

50M;

alter database add standby logfile group 6 ('/home/u01/oradata/orcl/redo03_sdy.log') size

50M;

alter database add standby logfile group 7 ('/home/u01/oradata/orcl/redo04_sdy.log') size

50M;

---rac环境每个thread多⼀组即可

alter database add logfile thread 1 '+DATA' size 200M;

alter database add logfile thread 2 '+DATA' size 200M;

### tnsnames.ora

ORCL =

(DESCRIPTION =

! (ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.8.38)(PORT = 1521))

! (CONNECT_DATA =

! ! (SERVER = DEDICATED)

! ! (SERVICE_NAME = orcl)

! )

)

orclbak =

(DESCRIPTION =

! (ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.40.38)(PORT = 1521))

! (CONNECT_DATA =

! ! (SERVER = DEDICATED)

! ! (SERVICE_NAME = orcl)

! )

)

### listener.ora

LISTENER =

七、主库配置tnsnames

⼋、主库参数修改

(DESCRIPTION_LIST =

! (DESCRIPTION =

! ! (ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.40.38)(PORT = 1521))

! )

)

SID_LIST_LISTENER =

(SID_LIST =

! (SID_DESC =

! ! (GLOBAL_DBNAME = orcl)

! ! (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) !

! ! (SID_NAME = orcl)

! )

)

ORCL =

(DESCRIPTION =

! (ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.8.38)(PORT = 1521))

! (CONNECT_DATA =

! ! (SERVER = DEDICATED)

! ! (SERVICE_NAME = orcl)

! )

)

orclbak =

(DESCRIPTION =

! (ADDRESS = (PROTOCOL = TCP)(HOST = 10.200.40.38)(PORT = 1521))

! (CONNECT_DATA =

! ! (SERVER = DEDICATED)

! ! (SERVICE_NAME = orcl)

! )

)

of 20

25墨值下载

oracle dataguard配置过程

相关文档

评论