11g RAC changed archive mode. archive files are stored in the ASM disk group (reprinted)

11g RAC change archive mode ASM

This experiment has two nodes: tip01 and tip02.
Oracle_sid: tips1, tips2

1. Run the command on node 1 tip01.
[[Email protected] ~] # Su-grid
[[Email protected] ~] $ Sqlplus/As sysasm

SQL> select name from V $ asm_diskgroup;

Name
------------------------------
Data
OCR

SQL> alter diskgroup data add directory '+ Data/arc1 ';

Diskgroup altered.

2. Run the command on node 1 tip02.
[[Email protected] ~] # Su-grid
[[Email protected] ~] $ Sqlplus/As sysasm

SQL> select name from V $ asm_diskgroup;

Name
------------------------------
Data
OCR

SQL> alter diskgroup data add directory '+ Data/arc2 ';

Diskgroup altered.

After the execution is complete, exit the ASM instance.

3. Run tip01
[[Email protected] ~] $ Su-Oracle
[[Email protected] ~] $ Sqlplus/As sysdba

SQL> select instance_name from V $ instance;

Instance_name
----------------
Tips1

SQL> alter system set log_archive_dest_1 = 'location = + Data/arc1 'scope = spfile SID = 'tips1 ';

System altered.

SQL> alter system set log_archive_dest_1 = 'location = + Data/arc2 'scope = spfile SID = 'tips2 ';

System altered.

4. Disable tips1 and tips2 services for all node instances

Run on node tip01

SQL> shutdown immediate

Run on node tip02

SQL> shutdown immediate

5. Change archive Mode

Run on node tip01

SQL> startup Mount
SQL> alter database archivelog;
Database altered.

SQL> archive log list
Archive log list
Database Log mode archive Mode
Automatic Archival Enabled
Archive destination + Data/arc1
Oldest online log sequence 255
Next log sequence to archive 256
Current Log sequence 256

Node tip01 has been changed

Run on node tip02

SQL> startup Mount
SQL> alter database archivelog;
Database altered.

SQL> archive log list
Archive log list
Database Log mode archive Mode
Automatic Archival Enabled
Archive destination + Data/arc2
Oldest online log sequence 255
Next log sequence to archive 256
Current Log sequence 256

6. Open the database

Run the commands on the tip01 and tip02 nodes respectively.
SQL> alter database open

7. Verify the archive file

Run on node tip01

SQL> alter system switch logfile;

System altered.

[[Email protected] ~] $ Su-grid
[[Email protected] ~] $ Asmcmd
Asmcmd> ls
Data/
OCR/
Asmcmd> Cd data
Asmcmd> Cd arc1
Asmcmd> ls
2017256_784611206.dbf

 

The tip01 node has an archive file generated.

Http://blog.csdn.net/evils798/article/details/7717844

11g RAC changed archive mode. archive files are stored in the ASM disk group (reprinted)