一:环境信息1)主库(单实例)主机平台:AIX6.1数据库版本:11.2.0.3(psu5)2)备库(部署了crs)主机平台:AIX6.1数据库版本:11.2.0.3(psu5)二:方案背景由
一:环境信息
1)主库(单实例)
主机平台:AIX6.1
数据库版本:11.2.0.3(psu5)
2)备库(部署了crs)
主机平台:AIX6.1
数据库版本:11.2.0.3(psu5)
二:方案背景
由于业务量增加,数据库需要由单实例,改成两节点rac。为了减少停机时间,采用DG方式迁移。
三迁移方案:
1.检查数据库是否支持Data Guard(只有企业版才支持DG)
SQL> select * from v$option where parameter = 'Managed Standby'; PARAMETER VALUE ---------------------------------------------------------------- ---------------------------------------------------------------- Managed Standby TRUE2.修改主库为归档模式及force logging状态
1)
2)
SQL> archive log list;
如果未开归档,开启归档模式
3.创建备库pfile文件
在主库上创建pfile,修改,并添加DG备库所有参数,然后传至备库
1)备库需要添加的参数
DB_UNIQUE_NAME;LOG_ARCHIVE_DEST_1;FAL_SERVER;FAL_CLIENT; STANDBY_FILE_MANAGEMENT=AUTO;DB_FILE_NAME_CONVERT;LOG_FILE_NAME_CONVERT
2)根据pfile中涉及到路径需要提前在备库主机上建好(如果主备库路径不一致要修改)
如主库*.audit_file_dest='/apps/oracle/admin/egap/adump'
我们在备库需要建 mkdir -p /apps/oracle/admin/egap/adump
cd /apps/oracle/admin
chown -R oracle:oinstall egap
chmod -R 775 egap
改变前参数文件
*.__db_cache_size=27648851968 *.__java_pool_size=67108864 *.__large_pool_size=67108864 *.__oracle_base='/apps/oracle'#ORACLE_BASE set from environment *.__pga_aggregate_target=10334765056 *.__sga_target=30937186304 *.__shared_io_pool_size=0 *.__shared_pool_size=2952790016 *.__streams_pool_size=0 *.audit_file_dest='/apps/oracle/admin/egap/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/data01/egap/control01.ctl','/data01/egap/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='egap' *.diagnostic_dest='/apps/oracle' *.log_archive_dest_1='location=/archlog/egap' *.log_archive_format='egap_%t_%s_%r.arch' *.open_cursors=300 *.pga_aggregate_target=10307502080 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=30922506240 *.undo_tablespace='UNDOTBS1'改变后参数文件
*.__db_cache_size=27648851968 *.__java_pool_size=67108864 *.__large_pool_size=67108864 *.__oracle_base='/apps/oracle'#ORACLE_BASE set from environment *.__pga_aggregate_target=10334765056 *.__sga_target=30937186304 *.__shared_io_pool_size=0 *.__shared_pool_size=2952790016 *.__streams_pool_size=0 *.audit_file_dest='/apps/oracle/admin/egapdb/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/data01/egapdb/control01.ctl','/data01/egapdb/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='egap' *.diagnostic_dest='/apps/oracle' *.log_archive_dest_1='location=/archlog/egapdb1' *.log_archive_dest_2='SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=egap' *.log_archive_format='egapdb_%t_%s_%r.arch' *.open_cursors=300 *.pga_aggregate_target=10307502080 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=30922506240 *.undo_tablespace='UNDOTBS1' *.DB_UNIQUE_NAME=egapdb *.FAL_SERVER=primary *.FAL_CLIENT=standby1 *.STANDBY_FILE_MANAGEMENT=AUTO *.DB_FILE_NAME_CONVERT='/data01/egap','/data01/egapdb' *.LOG_FILE_NAME_CONVERT='/data01/egap','/data01/egapdb' *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(egap,egapdb)'###注意db_file_name_convert和log_file_name_convert参数指定的路径要存在
4)根据修改后的pfile创建备库spfile
export ORACLE_SID=egapdb1 sqlplus / as sysdba create spfile from pfile;--使用新生成的spfile检查是否能够成功启动实例
4.生成备库的密码文件
scp主库密码文件到备库,并改名
如果主库没有密码文件,需要新建
--主库密码文件传到备库以后要重启备库
5.配置主备库监听及net服务
1)listener
--主库
一般建库后都会配置监听我们无需再配置
--备库(因为安装了cluster,所以用的是cluster的监听)
lsnrctl status 查看监听文件位置,并在监听文件中加入如下类容

1、在旧设备上打开微信app,点击右下角的【我】,选择【设置】功能,点击【聊天】。2、选择【聊天记录迁移与备份】,点击【迁移】,选择要迁移设备的平台。3、点击【择需要迁移的聊天】,点击左下角的【全选】或自主选择聊天记录。4、选择完毕后,点击右下角的【开始】,使用新设备登录此微信账号。5、然后扫描该二维码即可开始迁移聊天记录,用户只需等待迁移完成即可。

oracle asm指的是“自动存储管理”,是一种卷管理器,可自动管理磁盘组并提供有效的数据冗余功能;它是做为单独的Oracle实例实施和部署。asm的优势:1、配置简单、可最大化推动数据库合并的存储资源利用;2、支持BIGFILE文件等。

在Oracle中,可利用lsnrctl命令查询端口号,该命令是Oracle的监听命令;在启动、关闭或重启oracle监听器之前可使用该命令检查oracle监听器的状态,语法为“lsnrctl status”,结果PORT后的内容就是端口号。

Linux和Docker:如何实现容器的跨主机迁移和同步?摘要:Docker是一种流行的容器化技术,它提供了一种轻量级的虚拟化解决方案。在多主机环境中,实现容器的跨主机迁移和同步是非常常见的需求。本文将介绍如何使用Linux和Docker来实现容器的跨主机迁移和同步,并提供一些示例代码供参考。引言容器化技术的兴起使得应用部署和迁移变得更加灵活和高效。在多主机

方法:1、利用“LOWER(字段值)”将字段转为小写,或者利用“UPPER(字段值)”将字段转为大写;2、利用“REGEXP_LIKE(字符串,正则表达式,'i')”,当参数设置为“i”时,说明进行匹配不区分大小写。

如何在GitLab中进行项目迁移和集成引言:在软件开发过程中,项目的迁移和集成是一项重要的任务。GitLab作为一个流行的代码托管平台,提供了一系列方便的工具和功能来支持项目迁移和集成。本文将介绍在GitLab中进行项目迁移和集成的具体步骤,并且提供一些代码示例来帮助读者更好地理解。一、项目迁移项目迁移是将已有的代码库从一个源代码管理系统迁移到GitLab上

1、在旧设备上,依次点击“我”→“设置”→“聊天”→“聊天记录迁移与备份”→“迁移”。2、选择要迁移的目标平台设备,选择需要迁移的聊天记录,点击“开始”。3、在新设备上使用同一微信账号登录并扫描二维码,即可开启聊天记录迁移。

在oracle中,可以利用upper()函数将字符转为大写,该函数的作用就是将指定表中指定字段包含的字母全部转成大写,该函数配合select语句即可进行转换,语法为“select upper(指定字段的名称) from 指定表的名称”。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
