| 网管联盟 | 网管论坛 | 网管u家 | 网管博客 | 网管软件 | 网管求职 | 小游戏 | 网管搜索 | 网管原创 | 网管聚合 | 网管读摘 | 网管焦点 | 世界素材 | 会员投稿 | 会员中心 |
|
| Windows Linux Cisco 网络技术 数据库 黑客攻防 DotNet Java PHP 认证 新闻资讯 服务器 存储资讯 网络设备 网管学堂 技术专题 焦点 网吧频道 |
环境：
Primary 数据库：sun01
Standby 数据库：sun02
Oracle_Sid:bnet
1. 拷贝$ORACLE_BASE 到新机器上
2. 让Primary数据库处于归档模式，对Primary数据库做一个Rman热备份
| startup mount
alter database archivelog;
archive log list;
rman target sys/oracle
backup database format \"/....\"; 网管联盟bitsCN@com |
3.创建Data Guard数据库控制文件
| alter database create standby controlfile as '/....ctl'; |
4.设置监听
| Primary：
bnetguard =
( (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sun02)(PORT = 1522)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bnet) ) )
Standby:
listener.ora
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sun01)(PORT = 1522)) ) ) )
tnsname.ora
bnet =
( (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sun02)(PORT = 1522)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bnet) ) ) 中国网管论坛bbs.bitsCN.com |
|
0
|
评论加载中…
