点击上方“IT那活儿”公众号,关注后了解更多内容,不管IT什么活儿,干就完了!!!
SQL> ALTER DATABASE FORCE LOGGING;
SQL> ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog1.rdo) SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog2.rdo) SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog3.rdo) SIZE 500M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE (/oracle/dbs/slog4.rdo) SIZE 500M;
*.audit_file_dest=/u01/app/oracle/admin/PROD5/adump
*.audit_trail=db
*.compatible=12.1.0.2.0
*.control_files=/u01/app/oracle/oradata/PROD5/control01.ctl,/u01/app/oracle/fast_recovery_area/PROD5/control02.ctl
*.db_block_size=8192
*.db_domain=example.com
*.db_name=PROD5
*.db_recovery_file_dest=/u01/app/oracle/fast_recovery_area
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest=/u01/app/oracle
*.memory_target=1160m
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile=EXCLUSIVE
*.undo_tablespace=UNDOTBS1
DB_UNIQUE_NAME=PROD5H1
LOG_ARCHIVE_CONFIG=DG_CONFIG=(PROD5H1,PROD5H2)
LOG_ARCHIVE_DEST_1=
LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=PROD5H1
LOG_ARCHIVE_DEST_2=
SERVICE=PROD5H2 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=PROD5H2
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
FAL_SERVER=PROD5H2
DB_FILE_NAME_CONVERT=/PROD5H2/,/PROD5H1/
LOG_FILE_NAME_CONVERT=/PROD5H2/,/PROD5H1/
STANDBY_FILE_MANAGEMENT=AUTO
Shutdown immediate
Startup nomount pfile=’/home/oracle/pfile.ora’
Create spfile from pfile=’/home/oracle/pfile.ora’
Shutdown immediate
Startup
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD5H1.example.com)
(SID_NAME=PROD5)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD5H2.example.com)
(SID_NAME=PROD5)
(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
)
)
PROD5H1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host01.example.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD5H1.example.com)
)
)
PROD5H2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host02.example.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD5H2.example.com)
)
)
PROD5H1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host01.example.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD5H1.example.com)
)
)
PROD5H2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host02.example.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD5H2.example.com)
)
)
*.audit_file_dest=/u01/app/oracle/admin/PROD5/adump
*.audit_trail=db
*.compatible=12.1.0.2.0
*.control_files=/u01/app/oracle/oradata/PROD5/control01.ctl,/u01/app/oracle/fast_recovery_area/PROD5/control02.ctl
*.db_block_size=8192
*.db_domain=example.com
*.db_name=PROD5
*.db_recovery_file_dest=/u01/app/oracle/fast_recovery_area
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest=/u01/app/oracle
*.memory_target=1160m
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile=EXCLUSIVE
*.undo_tablespace=UNDOTBS1
DB_UNIQUE_NAME=PROD5H2
LOG_ARCHIVE_CONFIG=DG_CONFIG=(PROD5H2,PROD5H1)
LOG_ARCHIVE_DEST_1=
LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=PROD5H2
LOG_ARCHIVE_DEST_2=
SERVICE=PROD5H1 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=PROD5H1
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
FAL_SERVER=PROD5H1
DB_FILE_NAME_CONVERT=/PROD5H1/,/PROD5H2/
LOG_FILE_NAME_CONVERT=/PROD5H1/,/PROD5H2/
STANDBY_FILE_MANAGEMENT=AUTO
Mkdir -p /u01/app/oracle/oradata/PROD5
Mkdir -p /u01/app/oracle/fast_recovery_area/PROD5
Shutdown immediate
Startup nomount pfile=’/home/oracle/pfile.ora’
Create spfile from pfile=’/home/oracle/pfile.ora’
Shutdown immediate
Startup nomount
Rman target sys/oracle@prod5h1 auxiliary sys/oracle@prod5h2
Duplicate tartget database for standby from active database nofilenamecheck
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。
转载请注明本文地址:https://www.ucloud.cn/yun/129194.html
RAC补丁日常更新成功反遇异常处理 img{ display:block; margin:0 auto !important; width:100%; } body{ width:75%; m...
摘要:但作为阿里云的用户,您仍有可能会收到这样的消息通知,提醒您的实例由于所在物理服务器存在故障风险需要维护,阿里云设定了一个实例重启的系统计划事件,将在天后重启该实例并迁移至安全的物理机运行。 摘要: 阿里云会针对ECS实例发布系统事件,当您收到阿里云计划维护的通知时,可以利用ECS系统计划事件了解与实例相关的计划维护操作,并根据您的业务特性选择合适的时间安排运维操作进行故障转移,减少对系...
摘要:但作为阿里云的用户,您仍有可能会收到这样的消息通知,提醒您的实例由于所在物理服务器存在故障风险需要维护,阿里云设定了一个实例重启的系统计划事件,将在天后重启该实例并迁移至安全的物理机运行。 摘要: 阿里云会针对ECS实例发布系统事件,当您收到阿里云计划维护的通知时,可以利用ECS系统计划事件了解与实例相关的计划维护操作,并根据您的业务特性选择合适的时间安排运维操作进行故障转移,减少对系...
手动搭建vue+node单页面(二) 环境搭建好了,开始写业务和后端接口代码,这一篇讲的内容也比较简单,只适合小白参考; 环境搭建请参考 《手动搭建vue+node单页面(一)》:https://segmentfault.com/a/11... 项目地址:https://github.com/liubingyan... 内容提要:1.jsonp获取baidu搜索框内容;2.node调用juejin...
阅读 1235·2023-01-11 13:20
阅读 1543·2023-01-11 13:20
阅读 996·2023-01-11 13:20
阅读 1651·2023-01-11 13:20
阅读 3958·2023-01-11 13:20
阅读 2456·2023-01-11 13:20
阅读 1290·2023-01-11 13:20
阅读 3454·2023-01-11 13:20