Example Analysis of oracle11g RAC starting Archive Mode
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.
