oracle 11g DataGuad如何修改sys密碼

這篇文章主要介紹oracle 11g DataGuad如何修改sys密碼，文中介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們一定要看完！

一、環境描述

    database version:11.2.0.4

    單實例DataGuard

    rhel 6.6

二、實驗過程

1. 主庫修改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
SQL> alter system switch logfile;

System 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     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

APPLIED    SEQUENCE#
--------- ----------
YES              117
YES              118
YES              119
YES              120
YES              121
YES              122
YES              123
YES              124
YES              125
YES              126
YES              127

APPLIED    SEQUENCE#
--------- ----------
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;

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

APPLIED    SEQUENCE#
--------- ----------
YES              107
YES              108
YES              109
YES              110
YES              111
YES              112
YES              113
YES              114
YES              115
YES              116
YES              117

APPLIED    SEQUENCE#
--------- ----------
YES              118
YES              119
YES              120
YES              121
YES              122
YES              123
YES              124
YES              125
YES              126
YES              127
YES              128

APPLIED    SEQUENCE#
--------- ----------
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.
SQL> alter database recover managed standby database using current logfile disconnect from session;

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

MESSAGE
--------------------------------------------------------------------------------
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>$

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

MESSAGE
--------------------------------------------------------------------------------
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery starting Real Time Apply
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

MESSAGE
--------------------------------------------------------------------------------
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.

以上是“oracle 11g DataGuad如何修改sys密碼”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注億速云行業資訊頻道！