這篇文章主要介紹oracle 11g DataGuad如何修改sys密碼，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！
站在用戶的角度思考問(wèn)題，與客戶深入溝通，找到呼蘭網(wǎng)站設(shè)計(jì)與呼蘭網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗(yàn)，讓設(shè)計(jì)與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個(gè)性化、用戶體驗(yàn)好的作品，建站類型包括：成都做網(wǎng)站、網(wǎng)站制作、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣、域名與空間、虛擬空間、企業(yè)郵箱。業(yè)務(wù)覆蓋呼蘭地區(qū)。
一、環(huán)境描述
database version:11.2.0.4
單實(shí)例DataGuard
rhel 6.6
二、實(shí)驗(yàn)過(guò)程
主庫(kù)修改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.備庫(kù)查看是否正常同步數(shù)據(jù)
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.備庫(kù)取消應(yīng)用后，再啟用mrp進(jìn)程查看
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.重啟備庫(kù)，然后啟用mrp進(jìn)程，再觀察
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 --報(bào)錯(cuò)
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.主庫(kù)同步密碼文件
oracle@roidb02's password:
orapworcl 100% 1536 1.5KB/s 00:00
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密碼”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！
重慶分公司
重慶分公司
