Shulou(Shulou.com)06/01 Report--

Recently, we have been building ORACLE 12C ADG, including stand-alone to stand-alone ADG, RAC to RAC ADG, and RAC to stand-alone ADG. I have encountered a lot of minor problems, so make a note here.

Oracle 12c R1 RAC modifies startup mode

$srvctl modify database-d orcldg-s nomount orcldg is the database name

$srvctl modify database-d orcldg-s mount

$srvctl modify database-d orcldg-s open

After setting DATAGUARD, the default is mount, but we need to automatically start to ADG mode, here we need to make a small change.

1. Check the startup mode

$srvctl config database-d orcldg

Database unique name: orcldg

Database name:

Oracle home: / u01/app/oracle/product/12.1.0/dbhome_1

Oracle user: oracle

Spfile: + DATADG/orcldg/spfileorcldg.ora

Password file: + DATADG/orcldg/PASSWORD/pworcldg

Domain:

Start options: mount

Stop options: immediate

Database role: PHYSICAL_STANDBY

Management policy: AUTOMATIC

Disk Groups: DATADG

Services:

OSDBA group:

OSOPER group:

Database instance: orcldg

two。 Modify the startup mode

$srvctl modify database-db orcldg-startoption open

3. Verify the startup mode here

$srvctl config database-d orcldg

Database unique name: orcldg

Database name:

Oracle home: / u01/app/oracle/product/12.1.0/dbhome_1

Oracle user: oracle

Spfile: + DATADG/orcldg/spfileorcldg.ora

Password file: + DATADG/orcldg/PASSWORD/pworcldg

Domain:

Start options: open

Stop options: immediate

Database role: PHYSICAL_STANDBY

Management policy: AUTOMATIC

Disk Groups: DATADG

Services:

OSDBA group:

OSOPER group:

Database instance: orcldg

4. Start the database and check that open_mode has been started in ADG mode

SQL > startup

ORACLE instance started.

Total System Global Area 1174405120 bytes

Fixed Size 2923680 bytes

Variable Size 436208480 bytes

Database Buffers 721420288 bytes

Redo Buffers 13852672 bytes

Database mounted.

Database opened.

SQL > select open_mode from v$database

OPEN_MODE

-

READ ONLY WITH APPLY

SQL >

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.