Oracle 10g dataguard 物理备库日常维护（一）

秒速五厘米 2022-01-11 16:19 281阅读 0赞

以下操作在物理备机实现

一、日志应用管理

启用日志应用

SQL> alter database recover managed standby database disconnect;

Database altered.

启用实时的日志应用 real time apply，开启日志的实时应用需要备库有备重做日志文件的存在。

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

停止日志应用服务

SQL> alter database recover managed standby database cancel;

Database altered.

判断当前备库是否启用了日志实时应用，使用如下语句：

SQL> select RECOVERY\_MODE from v$archive\_dest\_status;

RECOVERY\_MODE

\-----------------------

MANAGED REAL TIME APPLY

11 rows selected.

如果是没有启用日志的实时应用，recovery\_mode显示的是MANAGED

SQL> alter database recover managed standby database disconnect;

Database altered.

SQL> select RECOVERY\_MODE from v$archive\_dest\_status;

RECOVERY\_MODE

\-----------------------

MANAGED

11 rows selected.

在备机检查当前日志文件应用的情况，使用如下语句

SQL> col name for a50

SQL> set linesize 140

SQL> select name,sequence\#,archived,applied from v$archived\_log order by sequence\#;

NAME SEQUENCE\# ARC APP

\-------------------------------------------------- ---------- --- ---

/u01/app/oracle/archdest/1\_2\_749662393.dbf 2 YES YES

/u01/app/oracle/archdest/1\_3\_749662393.dbf 3 YES YES

/u01/app/oracle/archdest/1\_4\_749662393.dbf 4 YES YES

/u01/app/oracle/archdest/1\_5\_749662393.dbf 5 YES YES

/u01/app/oracle/archdest/1\_6\_749662393.dbf 6 YES YES

/u01/app/oracle/archdest/1\_7\_749662393.dbf 7 YES YES

/u01/app/oracle/archdest/1\_8\_749662393.dbf 8 YES YES

/u01/app/oracle/archdest/1\_9\_749662393.dbf 9 YES YES

/u01/app/oracle/archdest/1\_10\_749662393.dbf 10 YES YES

9 rows selected.

查看dataguard 备机是否启用了日志应用，如果看不到mrp进程，说明没有应用日志。

SQL> select process,status from v$managed\_standby;

PROCESS STATUS

\--------- ------------

ARCH CONNECTED

RFS IDLE

二、oracle dataguard 数据库保护模式的变更

检查当前数据库是处在那种角色，以及现在使用的保护模式，使用如下的查询语句

在主机 primary 192.168.1.90，执行语句

SQL>select DATABASE\_ROLE,PROTECTION\_MODE,PROTECTION\_LEVEL from v$database;

DATABASE\_ROLE PROTECTION\_MODE PROTECTION\_LEVEL

\---------------- -------------------- --------------------

PRIMARY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

在备机 standby 192.168.1.91，执行语句

SQL> select DATABASE\_ROLE,PROTECTION\_MODE,PROTECTION\_LEVEL from v$database;

DATABASE\_ROLE PROTECTION\_MODE PROTECTION\_LEVEL

\---------------- -------------------- --------------------

PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE

升级oracle数据库的保护模式 （MAXIMUM PERFORMANCE-->max availability-->max protection），

如果要升级oracle数据库的保护模式，必须在mount状态下来执行命令

在主机 primary 192.168.1.90，执行如下操作（以下操作只需要在主机操作）

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 218103808 bytes

Fixed Size 1218604 bytes

Variable Size 71305172 bytes

Database Buffers 142606336 bytes

Redo Buffers 2973696 bytes

Database mounted.

SQL> alter database set standby database to maximize availability;

Database altered.

SQL> alter database open;

Database altered.

SQL> select DATABASE\_ROLE,PROTECTION\_MODE,PROTECTION\_LEVEL from v$database;

DATABASE\_ROLE PROTECTION\_MODE PROTECTION\_LEVEL

\---------------- -------------------- --------------------

PRIMARY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

在备机 standby 192.168.1.91，执行语句，确认修改是否生效

SQL> show parameter db\_un

NAME TYPE VALUE

\------------------------------------ ----------- ------------------------------

db\_unique\_name string standby

SQL> select DATABASE\_ROLE,PROTECTION\_MODE,PROTECTION\_LEVEL from v$database;

DATABASE\_ROLE PROTECTION\_MODE PROTECTION\_LEVEL

\---------------- -------------------- --------------------

PHYSICAL STANDBY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY

注：如果降级数据库的保护模式，直接操作就可以，不需要到mount状态。

三.oracle dataguard 数据库切换（switchover）操作测试

切换过程中，主机会首先切换成备机，也就是在同一时间点，在dataguard 配置中有两台备机的存在

在主机 primary 192.168.1.90，执行如下操作

SQL> select database\_role,switchover\_status from v$database;

DATABASE\_ROLE SWITCHOVER\_STATUS

\---------------- --------------------

PRIMARY SESSIONS ACTIVE

SQL> alter database commit to switchover to physical standby;

Database altered.

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 218103808 bytes

Fixed Size 1218604 bytes

Variable Size 71305172 bytes

Database Buffers 142606336 bytes

Redo Buffers 2973696 bytes

Database mounted.

SQL> recover managed standby database disconnect;

Media recovery complete.

SQL> select database\_role,switchover\_status from v$database;

DATABASE\_ROLE SWITCHOVER\_STATUS

\---------------- --------------------

PHYSICAL STANDBY NOT ALLOWED

在备机 standby 192.168.1.91，执行如下语句，完成角色转换

SQL> select database\_role,switchover\_status from v$database;

DATABASE\_ROLE SWITCHOVER\_STATUS

\---------------- --------------------

PHYSICAL STANDBY TO PRIMARY

SQL> alter database commit to switchover to primary;

Database altered.

SQL> select database\_role,switchover\_status from v$database;

DATABASE\_ROLE SWITCHOVER\_STATUS

\---------------- --------------------

PRIMARY TO STANDBY

SQL> select status from v$instance;

STATUS

\------------

MOUNTED

SQL> alter database open;

Database altered.

oracle视频教程请关注:[http://u.youku.com/user\_video/id\_UMzAzMjkxMjE2.html][http_u.youku.com_user_video_id_UMzAzMjkxMjE2.html]

转载于:https://blog.51cto.com/19880614/1261101

[http_u.youku.com_user_video_id_UMzAzMjkxMjE2.html]: http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html

Oracle 10g dataguard 物理备库日常维护（一）

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Oracle 11g Data guard 物理备库故障恢复重建实例

相关 oracle10g 是rac,Oracle10g RAC ASM 环境日常管理

相关 oracle 10g手动建库,Oracle 10g 手动建库

相关 Oracle 11g DataGuard物理standby配置

相关 Oracle DataGuard 一主多备配置

相关 oracle11g dataguard undo恢复

相关 Oracle 10g 下载地址（备忘）

相关 Oracle database DataGuard 日常维护（二）主备切换

相关 oracle 10g 物理Dataguard 日常操作管理（一）

相关 Oracle 10g dataguard 物理备库日常维护（一）