?
Copyright (c) 1982, 2013, Oracle.? All rights reserved.
?
Connected to an idle instance.
?
SQL> startup
ASM instance started
?
Total System Global Area 1135747072 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2260728 bytes
Variable Size? ? ? ? ? ? 1108320520 bytes
ASM Cache? ? ? ? ? ? ? ? ? 25165824 bytes
ORA-15110: no diskgroups mounted
?
SQL> select status from v$instance;
STATUS
------------------------
STARTED? ? ? ? ? ?
?
col description for a35
col process for a35
set linesize 120
select sid, serial#, process, name, description from v$session join v$bgprocess using(paddr);
?
col path for a45
col name for a30? ? ? ? ? ?
select group_number, disk_number, mount_status, name, path from v$asm_disk order by group_number, disk_number;
?GROUP_NUMBER DISK_NUMBER MOUNT_STATUS? NAME? ? ? ? ? ? ? ? ? ? ? ? ? PATH
------------ ----------- -------------- ------------------------------ ---------------------------------------------
? ? ? ? ? 0? ? ? ? ? 0 CLOSED? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? /dev/mapper/ora_vg-lv_asm3
? ? ? ? ? 0? ? ? ? ? 1 CLOSED? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? /dev/mapper/ora_vg-lv_asm2
? ? ? ? ? 0? ? ? ? ? 2 CLOSED? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? /dev/mapper/ora_vg-lv_asm1
?
查看A机器的磁盘组信息：
select group_number, name, type, total_mb, free_mb from v$asm_diskgroup
?GROUP_NUMBER NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? ? TOTAL_MB? ? FREE_MB
------------ ------------------------------------------------------------ ------------ ---------- ----------
? ? ? ? ? 1 DATA1? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? EXTERN? ? ? ? ? ? 30708? ? ? 29017
?
B机器创建ASM磁盘组DATA1：
select group_number, name, type, total_mb, free_mb from v$asm_diskgroup;
?no rows selected
?
CREATE DISKGROUP data1 EXTERNAL REDUNDANCY DISK '/dev/mapper/ora*';
Diskgroup created.
?
select group_number, name, type, total_mb, free_mb from v$asm_diskgroup;
?
GROUP_NUMBER NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? ? TOTAL_MB? ? FREE_MB
------------ ------------------------------------------------------------ ------------ ---------- ----------
? ? ? ? ? 1 DATA1? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? EXTERN? ? ? ? ? ? 30708? ? ? 30654
至此，准备工作结束。
二、DG部署配置
1. primary database 配置
确保将数据库的force_logging打开，设置为归档模式，数据库闪回打开
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA1/jyzhao/datafile/system.256.874084601
+DATA1/jyzhao/datafile/sysaux.257.874084601
+DATA1/jyzhao/datafile/undotbs1.258.874084601
+DATA1/jyzhao/datafile/users.259.874084601
?
SQL> select force_logging from v$database;
FOR
---
NO
?
SQL> alter database force logging;
?Database altered.
?
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
?
SQL> startup mount
ORACLE instance started.
?Total System Global Area 1620115456 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2253704 bytes
Variable Size? ? ? ? ? ? 1006636152 bytes
Database Buffers? ? ? ? ? 603979776 bytes
Redo Buffers? ? ? ? ? ? ? ? 7245824 bytes
Database mounted.
SQL> alter database archivelog;
?Database altered.
?
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38709: Recovery Area is not enabled.
?
SQL> archive log list
Database log mode? ? ? ? ? ? ? Archive Mode
Automatic archival? ? ? ? ? ? Enabled
Archive destination? ? ? ? ? ? /u01/app/oracle/product/11.2.0/db_1/dbs/arch
Oldest online log sequence? ? 12
Next log sequence to archive? 14
Current log sequence? ? ? ? ? 14
?
$ mkdir -p /u01/app