Oracle 11gR2 物理备库的搭建及切换

在同一台机器上搭建物理备用数据库的步骤实验环境：Linux环境 Oracle 11.2.0.1主库：orcl备库：stby
1 检查监听是否启动2 配置主备数据库的初始化参数文件
sqlplus "/as sysdba"
create pfile="/home/Oracle/initprim.ora" from spfile;
cp /home/oracle/initprim.ora /home/oracle/initstby.ora
vi /home/oracle/initprim.oraorcl.__db_cache_size=104857600
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__oracle_base="/oracle"#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=155189248
orcl.__sga_target=268435456
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=142606336
orcl.__streams_pool_size=4194304
*.audit_file_dest="/oracle/admin/orcl/adump"
*.audit_trail="db"
*.compatible="11.2.0.0.0"
*.control_files="/oradata/orcl/control01.ctl","/oradata/flash_recovery_area/orcl/control02.ctl"
*.db_block_size=8192
*.db_domain=""
*.db_name="orcl"
*.db_recovery_file_dest="/oradata/flash_recovery_area"
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest="/oracle"
*.dispatchers="（PROTOCOL=TCP）（SERVICE=orclXDB）"
*.memory_target=422576128
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile="EXCLUSIVE"
*.undo_tablespace="UNDOTBS1" *.fal_client="prim"
*.fal_server="stby"
*.standby_file_management=auto
*.log_archive_dest_1="location=/oradata/arch/orcl valid_for=（all_logfiles,all_roles） db_unique_name=prim"
*.log_archive_dest_2="service=stby valid_for=（online_logfiles,primary_role） db_unique_name=stby"
*.DB_UNIQUE_NAME=prim
*.log_archive_config="dg_config=（prim,stby）" 编辑备库的参数文件:
vi /home/oracle/initstby.ora
stby.__db_cache_size=104857600
stby.__java_pool_size=4194304
stby.__large_pool_size=4194304
stby.__oracle_base="/oracle"#ORACLE_BASE set from environment
stby.__pga_aggregate_target=155189248
stby.__sga_target=268435456
stby.__shared_io_pool_size=0
stby.__shared_pool_size=142606336
stby.__streams_pool_size=4194304
*.audit_file_dest="/oracle/admin/stby/adump"
*.audit_trail="db"
*.compatible="11.2.0.0.0"
*.control_files="/oradata/stby/control01.ctl","/oradata/flash_recovery_area/stby/control02.ctl"
*.db_block_size=8192
*.db_domain=""
*.db_name="orcl" --在同一台机器上搭建dg 要与主库的一样否则ORA-01103
*.db_recovery_file_dest="/oradata/flash_recovery_area"
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest="/oracle"
*.dispatchers="（PROTOCOL=TCP）（SERVICE=stbyXDB）"
*.memory_target=622576128
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile="EXCLUSIVE"
*.undo_tablespace="UNDOTBS1"
*.DB_FILE_NAME_CONVERT="/oradata/orcl","/oradata/stby"
*.LOG_FILE_NAME_CONVERT="/oradata/orcl","/oradata/stby"
*.fal_client="stby"
*.fal_server="prim"
*.standby_file_management=auto
*.log_archive_dest_1="location=/oradata/arch/stby valid_for=（all_logfiles,all_roles） db_unique_name=stby"
*.log_archive_dest_2="service=prim valid_for=（online_logfiles,primary_role） db_unique_name=prim"
*.DB_UNIQUE_NAME="stby"
*.log_archive_config="dg_config=（prim,stby）"

备份主库:
rman target /
backup database format "/u01/oradata/dbfull%U";

Solaris下安装MySQL_启动停止MySQL_创建远程用户Oracle 11g 11.2.0.1 环境逻辑备库搭建相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）