10.0.0.1
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
-------------------- ---------- ----------
ARCH 307200 307103
DATA 2150400 1807373
OCR_VOT 30720 30324
-----------------------------------------
10.0.0.1
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/11.2.0/db/dbs/arch
Oldest online log sequence 1077
Current log sequence 1082
SQL>
--------------------------------------------
10.0.0.1
SQL> show parameter archive
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
archive_lag_target integer
0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
NAME TYPE
------------------------------------ ---------------------------------
10.0.0.1
SQL> alter system set log_archive_dest_1='location=+ARCH' scope=spfile;
System altered.
------------------------------------------------------------------------
10.0.0.1
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
---------------------------
10.0.0.2
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
-----------------------------
10.0.0.1
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.0055E+10 bytes
Fixed Size 2261888 bytes
Variable Size 2013269120 bytes
Database Buffers 8019509248 bytes
Redo Buffers 19742720 bytes
Database mounted.
-------------------------------------
10.0.0.2
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.0055E+10 bytes
Fixed Size 2261888 bytes
Variable Size 2013269120 bytes
Database Buffers 8019509248 bytes
Redo Buffers 19742720 bytes
Database mounted.
------------------------------------------
10.0.0.1
SQL> alter database archivelog;
Database altered.
-------------------------------------
10.0.0.1
SQL> alter database open；
-------------------------------
10.0.0.2
SQL> alter database open;
Database altered.
--------------------------------
10.0.0.1
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 1077
Next log sequence to archive 1082
Current log sequence 1082
SQL>
---------------------------------
10.0.0.2
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 932
Next log sequence to archive 937
Current log sequence 937
-----------------------------------
10.0.0.1
alter system switch logfile;
