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

Today, I will talk to you about the example analysis of oracle11g RAC start-up archiving mode, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following for you. I hope you can get something from this article.

According to customer requirements, archive logs need to be stored on ASM. Therefore, you need to build an archive path in ASM.

ASMCMD > mkdir arch

ASMCMD > cd arch

ASMCMD > pwd

+ data1/kdcs/arch

Modify archive path parameters

SQL > alter system set log_archive_dest_1='location=+data1/kdcs/arch' scope=spfile sid='*'

System altered.

Shut down the database. All nodes must be closed.

[grid@zhcs-db1] $srvctl stop database-d kdcs

Check the status of the database after shutdown

[grid@zhcs-db1] $crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA1.dg

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.LISTENER.lsnr

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.OCR_DISK.dg

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.asm

ONLINE ONLINE zhcs-db1 Started

ONLINE ONLINE zhcs-db2 Started

Ora.gsd

OFFLINE OFFLINE zhcs-db1

OFFLINE OFFLINE zhcs-db2

Ora.net1.network

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.ons

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.registry.acfs

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE zhcs-db1

Ora.cvu

1 OFFLINE OFFLINE

Ora.kdcs.db

1 OFFLINE OFFLINE Instance Shutdown

2 OFFLINE OFFLINE Instance Shutdown

Ora.kdcs.ser_scanip.svc

1 OFFLINE OFFLINE

2 OFFLINE OFFLINE

Ora.oc4j

1 ONLINE ONLINE zhcs-db2

Ora.scan1.vip

1 ONLINE ONLINE zhcs-db1

Ora.zhcs-db1.vip

1 ONLINE ONLINE zhcs-db1

Ora.zhcs-db2.vip

1 ONLINE ONLINE zhcs-db2

Start a node database to the mount state

[grid@zhcs-db1] $srvctl start instance-d kdcs-I kdcs1-o mount

Modify the archiving mode of the database and start the database

SQL > alter database archivelog

Database altered.

SQL > alter database open

Database altered.

Check statu

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination + DATA1/kdcs/arch

Oldest online log sequence 86

Next log sequence to archive 87

Current log sequence 87

SQL >

Start the 2-node database

[grid@zhcs-db1] $srvctl start instance-d kdcs-I kdcs2

Check cluster status

[grid@zhcs-db1] $crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA1.dg

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.LISTENER.lsnr

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.OCR_DISK.dg

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.asm

ONLINE ONLINE zhcs-db1 Started

ONLINE ONLINE zhcs-db2 Started

Ora.gsd

OFFLINE OFFLINE zhcs-db1

OFFLINE OFFLINE zhcs-db2

Ora.net1.network

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.ons

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Ora.registry.acfs

ONLINE ONLINE zhcs-db1

ONLINE ONLINE zhcs-db2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE zhcs-db1

Ora.cvu

1 OFFLINE OFFLINE

Ora.kdcs.db

1 ONLINE ONLINE zhcs-db1 Open

2 ONLINE ONLINE zhcs-db2 Open

Ora.kdcs.ser_scanip.svc

1 ONLINE ONLINE zhcs-db1

2 ONLINE ONLINE zhcs-db2

Ora.oc4j

1 ONLINE ONLINE zhcs-db2

Ora.scan1.vip

1 ONLINE ONLINE zhcs-db1

Ora.zhcs-db1.vip

1 ONLINE ONLINE zhcs-db1

Ora.zhcs-db2.vip

1 ONLINE ONLINE zhcs-db2

[grid@zhcs-db1 ~] $

After reading the above, do you have any further understanding of the example analysis of oracle11g RAC startup archiving mode? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.