11g DataGuad正确修改sys密碼的方法

一、環境描述

    database version:11.2.0.4

    單執行個體DataGuard

    rhel 6.6

二、實驗過程

主庫修改sys密碼

SQL> alter user sys identified by oracle321;

User altered.

SQL> alter system switch logfile;

System altered.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /arch

Oldest online log sequence     125

Next log sequence to archive   127

Current log sequence           127

Oldest online log sequence     127

Next log sequence to archive   129

Current log sequence           129

2.備庫檢視是否正常同步資料

SQL> select applied,sequence# from v$archived_log order by 2;

APPLIED    SEQUENCE#

--------- ----------

YES              106

YES              107

YES              108

YES              109

YES              110

YES              111

YES              112

YES              113

YES              114

YES              115

YES              116

YES              117

YES              118

YES              119

YES              120

YES              121

YES              122

YES              123

YES              124

YES              125

YES              126

YES              127

IN-MEMORY        128

3.備庫取消應用後，再啟用mrp程序檢視

SQL> alter database recover managed standby database cancel;

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

YES              128

YES              129

IN-MEMORY        130

4.重新開機備庫，然後啟用mrp程序，再觀察

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size                  2253784 bytes

Variable Size            1526729768 bytes

Database Buffers          117440512 bytes

Redo Buffers                7094272 bytes

Database mounted.

Database opened.

Database altered.

SQL> select message from v$dataguard_status;

MESSAGE

--------------------------------------------------------------------------------

ARC0: Archival started

ARC1: Archival started

ARC2: Archival started

ARC3: Archival started

ARC1: Becoming the 'no FAL' ARCH

ARC2: Becoming the heartbeat ARCH

ARC2: Becoming the active heartbeat ARCH

Error 1017 received logging on to the standby

FAL[client, ARC3]: Error 16191 connecting to orcl for fetching gap sequence  --報錯

ARC4: Archival started

Attempt to start background Managed Standby Recovery process

MRP0: Background Managed Standby Recovery process started

Managed Standby Recovery starting Real Time Apply

13 rows selected.

5.主庫同步密碼檔案

<roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/dbs>$scp orapworcl roidb02:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcldg

oracle@roidb02's password: 

orapworcl                                                                                          100% 1536     1.5KB/s   00:00    

<roidb01:orcl:/u01/app/oracle/product/11.2.0/dbhome_1/dbs>$

FAL[client, ARC3]: Error 16191 connecting to orcl for fetching gap sequence

RFS[1]: Assigned to RFS process 2723

RFS[2]: Assigned to RFS process 2725

RFS[3]: Assigned to RFS process 2727

RFS[4]: Assigned to RFS process 2729

ARC4: Beginning to archive thread 1 sequence 131 (1137893-1138457)

ARC4: Completed archiving thread 1 sequence 131 (0-0)

Media Recovery Log /arch/1_132_955700418.dbf

Media Recovery Log /arch/1_133_955700418.dbf

Media Recovery Log /arch/1_134_955700418.dbf

Media Recovery Waiting for thread 1 sequence 135

Primary database is in MAXIMUM PERFORMANCE mode

RFS[5]: Assigned to RFS process 2731

ARC1: Beginning to archive thread 1 sequence 135 (1139616-1140903)

ARC1: Completed archiving thread 1 sequence 135 (0-0)

Media Recovery Log /arch/1_135_955700418.dbf

Media Recovery Waiting for thread 1 sequence 136 (in transit)

ARC4: Beginning to archive thread 1 sequence 136 (1140903-1141035)

ARC4: Completed archiving thread 1 sequence 136 (0-0)

Media Recovery Waiting for thread 1 sequence 137 (in transit)

32 rows selected.

二、小結

DataGuard 是通過sys使用者進行驗證的。

修改sys密碼需要同步密碼檔案即可。

本文轉自 roidba 51CTO部落格，原文連結：http://blog.51cto.com/roidba/1971847，如需轉載請自行聯系原作者