
说明
:本报告为我公司对贵方数据库所做服务内容的工作记录,同时作为档案留存,为贵方数据库运行提
供历史数据。本文档全面涵盖了应用系统的数据库基本信息,也可能涉及系统中一些重要信息,仅供用户参考,
同时在传阅的过程中应注意安全保密等事宜,杜绝防止不必要的泄密事件发生。
1. 配置 tns(四个节点均配置)
2. 备份数据库
在 RAC 主节点 2 使用 rman 备份数据库
3. 修改主库参数
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zdata01)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = zdata02)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
orcldg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zdata03)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = zdata04)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
rman target / nocatalog <<EOF
run{
configure default device type to disk;
configure device type disk parallelism 16;
backup database filesperset = 10 format '/bak/df_%U';
backup current controlfile format '/bak/ctl_%U';
}
<<EOF
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcldg)' sid='*' scope=both;
alter system set LOG_ARCHIVE_DEST_1='LOCATION=+arch/orcl/ARCHIVELOG
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl' sid='*' scope=both;
alter system set LOG_ARCHIVE_DEST_2='SERVICE=orcldg LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=orcldg' sid='*' scope=both;
alter system set standby_file_management='AUTO' sid='*' scope=both;
alter system set fal_client='orcl' sid='*' scope=both;
alter system set fal_server='orcldg' sid='*' scope=both;
评论