单实例Primary快速搭建Standby RAC参考手册(19.16 ADG)
环境:Single Instance -> RACSingle Instance:db_name=demodb_unique_name=demoinstance_name=demoservice_names=demoRAC(2 nodes):db_name=demodb_unique_name...
ORA-10456:cannot open standby database;media recovery session may be in process
http://neeraj-dba.blogspot.com/2011/10/ora-10456-cannot-open-standby-database.html Once while starting my standby database i found that database is no...
snapshot standby database
快照备库接收和归档主库发送来的redo,但是不会应用;切换成physical standby之后会自动开启redo apply。快照standby不可以参加主备切换;在最大保护性模式下,如果只有一个备库,则不可以将备库转成snapshot standby。将Physical Standby Data...
Standby Redo Log 的设定原则、创建、删除、查看、归档位置
设定:1.每个standby redo log file 至少要和primary database的redo log 一样大,为了方便管理,Oracle 建议主备库的redo log 设置成一样的大小。SQL> SELECT GROUP#, BYTES/1024/1024 M FROM V$L...
查看name的状态,是属于active还是standby
sudo -E -u hadoop /home/hadoop/bin/hdfs haadmin -getServiceState nn1sudo -E -u hadoop /home/hadoop/bin/hdfs haadmin -getServiceState nn2sudo -E 加大E是因为
[Oracle][DATAGUARD] PHYSICAL STANDBY环境里,11.2.0.4 , 也可以使用Pfile来运行Primary和Standby(虽然很少有人用)
####Primary####[oracle@primary ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on 金 10月 13 15:40:32 2017Copyright (c) 1982, 2013, Oracl...
dg端drop standby log报错ORA-00261 ORA-00312
系统:centos 7.9 64位数据库:oracle 11.2.0.4 64位环境:rac(双节点) + dg问题描述:dg端drop standby log报错ORA-00261、ORA-00312,如下所示:SQL> select a.thread#,a.group#,b.member,...
备库状态为read only with apply 但v$managed_standby却未见rfs进程信息
问题描述:备库状态为read only with apply,但查看v$managed_standby视图却未见rfs进程信息,如下所示.SQL> select open_mode from v$database;OPEN_MODE--------------------READ ONLY W...
(摘)DataGuard物理standby管理 - 主备切换
DataGuard物理standby管理 - 主备切换Dataguard的切换分为两种,switchover和failover。switchover一般用于数据库或硬件升级,这时只需要较短时间中断数据库访问,主备库的角色切换完成后,即可打开primary角色的备库来提供数据库访问。failover,...
[Oracle][DataGuard]Standby数据库文件有损坏时的处理方法
需要参考:[Oracle]Recovering the primary database's datafile using the physical standby, and vice versa (Doc ID 453153.1)
11.2 Data Guard Physical Standby Switchover Best Practices u
11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 1304939.1) APPLIES TO: Oracle Database - Enterprise Edition - Versio...
18c & 19c Physical Standby Switchover Best Practices
18c & 19c Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 2485237.1) APPLIES TO: Oracle Database - Enterprise Edition - Version ...
备机大地院系项目dataguard archived_log及standby_log
主库archivelog及standbylog仅仅是测试4天的数据,项目并未正式上线/data/dddb/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/archivelog/data/dddb/DBSoftware/app/oracle/stan...
DataGuard---->物理StandBy的角色切换之switchover
Switchover,无损切换,通常是用户手动触发或者有计划地让其自动触发,如硬件升级等。 步骤: 1、Primary数据库转换为StandBy角色 2、StandBy数据库(之一)转换为Primary角色 准备工作: 1、检查待转换角色的数据库参数配置正确 2、检查即将成为Primay的物理Sta...
Transportable tablespace on standby (Doc ID 788176.1)
APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]Oracle Database - Enterprise Edition - Version 10.2.0.5 ...
Creating a Physical Standby from Primary on Version 12c (Doc
Creating a Physical Standby from Primary on Version 12c (Doc ID 1570958.1) APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOra...
利用Oracle Enterprise Manager Cloud Control 12c创建DataGuard Standby
Oracle Enterprise Manager Cloud Control 12c在对数据库管理(Database Management)的各个方面相比11g Grid Control都有所增强, 具体可以参考《New Features In Oracle Enterprise Manager ...
ORA-16447 Redo apply was not active at the target standby database
CauseALTER SYSTEM FLUSH REDO TO STANDBY failed because redo apply is not active at the target database.ActionStart redo apply at the standby database
18c & 19c Physical Standby Switchover Best Practices
18c & 19c Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 2485237.1) APPLIES TO: Oracle Database - Enterprise Edition - Version ...
Creating a Physical Standby from Primary on Version 12c (Doc
Creating a Physical Standby from Primary on Version 12c (Doc ID 1570958.1) APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOra...