Shulou(Shulou.com)05/31 Report--

This article mainly introduces oracle 11g DataGuad how to change the sys password, the article is very detailed, has a certain reference value, interested friends must read it!

I. description of the environment

Database version:11.2.0.4

Single instance DataGuard

Rhel 6.6

Second, the experimental process

Main library modifies sys password

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

two。 Standby database to check whether the data is synchronized normally

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. After the slave library cancels the application, enable mrp process to view

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. Restart the library, then enable the mrp process, and then observe

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-error report

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. The main library synchronizes the password file

$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

$

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.

The above is all the contents of the article "how to change the sys password of oracle 11g DataGuad". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.