Oracle10gr2rac + ASM changed to archive status

Source: Internet
Author: User
The Oracle10gr2rac database is modified and archived to ASM1, and the related Space Directory exportORACLE_SID + ASM1asmcmdmkdirarch1arch2ASMCMDgt; p is created on asm.

Oracle 10g r2 rac database modification archive to ASM1, asm create related Space Directory export ORACLE_SID = + ASM1asmcmdmkdir arch1 arch2ASMCMDgt; p

Oracle 10g r2 rac database modification archive to ASM

1. Create related space directories on asm
Export ORACLE_SID = + ASM1
Asmcmd
Mkdir arch1 arch2

ASMCMD> pwd
+ DATA/RACDB/archive
ASMCMD> ls
Arch1/
Arch2/
ASMCMD>

2. modify a node in the mount status

[Oracle @ rac1 software] $ export ORACLE_SID = racdb1
[Oracle @ rac1 software] $ sqlplus "/as sysdba"

SQL * Plus: Release 10.2.0.1.0-Production on Thu Dec 30 10:21:41 2010

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 1218556 bytes
Variable Size 100665348 bytes
Database Buffers 104857600 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination/u01/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence 14
Current log sequence 15
SQL> alter system set log_archive_dest_1 = 'location = + DATA/RACDB/archive/arch1' sid = 'racdb1 ';

System altered.

SQL> alter system set log_archive_dest_1 = 'location = + DATA/RACDB/archive/arch2' sid = 'racdb2 ';

System altered.

SQL> show parameter cluster_database

NAME TYPE VALUE
-----------------------------------------------------------------------------
Cluster_database boolean TRUE
Cluster_database_instances integer 2

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination + DATA/racdb/archive/arch1
Oldest online log sequence 14
Next log sequence to archive 15
Current log sequence 15
SQL> exit

3. Start another node
[Oracle @ rac1 software] $ crs_start ora. racdb. racdb2.inst
Attempting to start 'ora. racdb. racdb2.inst 'on member 'rac2'
Start of 'ora. racdb. racdb2.inst 'on member 'rac2' succeeded.

4. Check whether the verification is successful.
Node2 execution

SQL> alter system archive log current;

System altered.

[Oracle @ rac2 ~] $ Export ORACLE_SID = + ASM2
[Oracle @ rac2 ~] $ Asmcmd
ASMCMD> ls
DATA/
ASMCMD> cd + DATA/racdb/archive/arch2
ASMCMD> ls
2_7_738946915.dbf

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.