- 상황
SDB1 : Single on ASM DB으로 DB OPEN 되어 있는 상태
SDB2 : Grid + DB 엔진만 설치되어 있는 상태
ADG를 설정하기전에 DB 복제를 위하여 RMAN을 사용합니다.(ASM 방식에서 DATAFILE 방식으로 Convert)
RMAN DB 복제 방식에는
- 백업을 이용한 Duplicate (OFFLINE)
- Open 되어 있는 DB를 이용한 Active Duplicate (ONLINE)
방식이 있는데 여기에서는 2번을 사용하겠습니다.
ADG를 위한 force logging, archivelog 설정
[oracle@sdb1 ~]$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 4 15:12:11 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> alter database force logging;
Database altered.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/app/oracle/product/11.2/dbs/arch
Oldest online log sequence 166
Current log sequence 168
SQL> !
[oracle@sdb1 ~]$ ps -ef|grep pmon
grid 4085 1 0 May11 ? 00:04:08 asm_pmon_+ASM
oracle 4322 1 0 May11 ? 00:04:16 ora_pmon_SDB
oracle 28271 28225 0 15:16 pts/3 00:00:00 grep pmon
[oracle@sdb1 ~]$ srvctl stop database -d SDB
[oracle@sdb1 ~]$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 4 15:51:29 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 507513936 bytes
Database Buffers 322961408 bytes
Redo Buffers 2371584 bytes
Database mounted.
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 /oracle/app/oracle/product/11.2/dbs/arch
Oldest online log sequence 166
Next log sequence to archive 168
Current log sequence 168
SDB2(Target) 접속하여 아래 내용 추가
vi /etc/hosts
192.168.56.55 sdb1.localdomain sdb1
192.168.56.57 sdb1-vip.localdomain sdb1-vip
192.168.56.56 sdb2.localdomain sdb2
SDB2(Target)에 디렉토리 생성
mkdir -p /oracle/admin/oracle/admin/sdb2
mkdir -p /oracle/admin/oracle/admin/sdb2/adump
mkdir -p /oracle/admin/oracle/admin/sdb2/dpdump
mkdir -p /oracle/admin/oracle/admin/sdb2/pfile
mkdir -p /oracle/admin/oradata/sdb2
mkdir -p /oracle/admin/oradata/recovery_area/sdb2
chmod -R 777 /oracle/admin/oradata/sdb2
chmod -R 777 /oracle/admin/oradata/recovery_area/sdb2
SDB2(Target) 네트워크 관련 설정
Source, Tagert 모두 tnsnames.ora에 아래 정보 기입
[oracle@sdb2 ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora
SDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sdb1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SDB)
)
)
SDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sdb2.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SDB2)
)
)
Tagert listener.ora에 아래 정보 기입
[oracle@sdb2 ~]$ vi $ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=/oracle/app/oracle/product/11.2)
(SID_NAME=SDB2))
)
)
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=sdb2.localdomain)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
ADR_BASE_LISTENER = /u01/app/oracle
[oracle@sdb2 ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 04-JUN-2015 16:56:21
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/11.2/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.2.0.4.0 – Production
Log messages written to /oracle/diag/tnslsnr/sdb2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sdb2.localdomain)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 – Production
Start Date 04-JUN-2015 16:56:22
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /oracle/diag/tnslsnr/sdb2/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sdb2.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
SDB1의 pfile을 생성해 SDB2에 복사합니다.
내용은 아래와 같이 수정합니다.(*로 수정)
*.__db_cache_size=385875968
*.__java_pool_size=4194304
*.__large_pool_size=8388608
*.__oracle_base=’/oracle’#ORACLE_BASE set from environment
*.__pga_aggregate_target=293601280
*.__sga_target=545259520
*.__shared_io_pool_size=0
*.__shared_pool_size=138412032
*.__streams_pool_size=0
*.audit_file_dest=’/oracle/admin/oracle/admin/sdb2/adump’
*.audit_trail=’db’
*.compatible=’11.2.0.4.0′
*.control_files=’+DATA/sdb/controlfile/current.260.878568075′
*.db_block_size=8192
*.db_create_file_dest=’+DATA’
*.db_domain=”
*.db_name=’SDB2′
*.diagnostic_dest=’/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SDBXDB)’
*.memory_target=838860800
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.statistics_level=’ALL’
*.undo_tablespace=’UNDOTBS1′
*.sec_case_sensitive_logon=’false’
SDB2(Targer) pfile을 이용하여 nomount로 시작
[oracle@sdb2 dbs]$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 9 10:42:19 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> startup nomount pfile=’/oracle/app/oracle/product/11.2/dbs/initSDB2.ora’;
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 507513936 bytes
Database Buffers 322961408 bytes
Redo Buffers 2371584 bytes
SDB1(Source)에서 rman을 이용한 Duplicate 시작(Source DB OPEN 상태에서 진행)
RMAN 스크립트에 대한 설명 참조 : http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126
[oracle@sdb1 ~]$ rman target sys/oracle@SDB auxiliary sys/oracle@SDB2
Recovery Manager: Release 11.2.0.4.0 – Production on Thu Jun 11 10:29:24 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: SDB (DBID=2394535691)
connected to auxiliary database: SDB2 (not mounted)
RMAN>
run {
SET NEWNAME FOR DATAFILE 1 TO ‘/oracle/admin/oradata/sdb2/system01.dbf’;
SET NEWNAME FOR DATAFILE 2 TO ‘/oracle/admin/oradata/sdb2/sysaux01.dbf’;
SET NEWNAME FOR DATAFILE 3 TO ‘/oracle/admin/oradata/sdb2/undo01.dbf’;
SET NEWNAME FOR DATAFILE 4 TO ‘/oracle/admin/oradata/sdb2/users01.dbf’;
SET NEWNAME FOR TEMPFILE 1 TO ‘/oracle/admin/oradata/sdb2/temp01’;
DUPLICATE TARGET DATABASE TO SDB2 FROM ACTIVE DATABASE
spfile
parameter_value_convert ‘SDB’,’SDB2′
set db_unique_name=’SDB2′
set cluster_database=’false’
set control_files=’/oracle/admin/oradata/sdb2/control01.ctl’,’/oracle/admin/oradata/sdb2/control02.ctl’
set db_recovery_file_dest=’/oracle/admin/oradata/recovery_area/sdb2′
set db_recovery_file_dest_size=’18446744073709551614′
set db_create_file_dest=’/oracle/admin/oradata/sdb2/’
set audit_trail=’none’
set audit_file_dest=’/oracle/admin/oracle/admin/sdb2/adump’
set log_archive_max_processes=’5′
set standby_file_management=’AUTO’
nofilenamecheck
;
}
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting Duplicate Db at 12-JUN-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=21 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile ‘+DATA/sdb/spfilesdb.ora’ auxiliary format
‘/oracle/app/oracle/product/11.2/dbs/spfileSDB2.ora’ ;
sql clone “alter system set spfile= ”/oracle/app/oracle/product/11.2/dbs/spfileSDB2.ora””;
}
executing Memory Script
Starting backup at 12-JUN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=47 device type=DISK
Finished backup at 12-JUN-15
sql statement: alter system set spfile= ”/oracle/app/oracle/product/11.2/dbs/spfileSDB2.ora”
contents of Memory Script:
{
sql clone “alter system set db_name =
”SDB2” comment=
”duplicate” scope=spfile”;
sql clone “alter system set dispatchers =
”(PROTOCOL=TCP) (SERVICE=SDB2XDB)” comment=
”” scope=spfile”;
sql clone “alter system set db_unique_name =
”SDB2” comment=
”” scope=spfile”;
sql clone “alter system set cluster_database =
false comment=
”” scope=spfile”;
sql clone “alter system set control_files =
”/oracle/admin/oradata/sdb2/control01.ctl”, ”/oracle/admin/oradata/sdb2/control02.ctl” comment=
”” scope=spfile”;
sql clone “alter system set db_recovery_file_dest =
”/oracle/admin/oradata/recovery_area/sdb2” comment=
”” scope=spfile”;
sql clone “alter system set db_recovery_file_dest_size =
18446744073709551614 comment=
”” scope=spfile”;
sql clone “alter system set db_create_file_dest =
”/oracle/admin/oradata/sdb2/” comment=
”” scope=spfile”;
sql clone “alter system set audit_trail =
”none” comment=
”” scope=spfile”;
sql clone “alter system set audit_file_dest =
”/oracle/admin/oracle/admin/sdb2/adump” comment=
”” scope=spfile”;
sql clone “alter system set log_archive_max_processes =
5 comment=
”” scope=spfile”;
sql clone “alter system set standby_file_management =
”AUTO” comment=
”” scope=spfile”;
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ”SDB2” comment= ”duplicate” scope=spfile
sql statement: alter system set dispatchers = ”(PROTOCOL=TCP) (SERVICE=SDB2XDB)” comment= ”” scope=spfile
sql statement: alter system set db_unique_name = ”SDB2” comment= ”” scope=spfile
sql statement: alter system set cluster_database = false comment= ”” scope=spfile
sql statement: alter system set control_files = ”/oracle/admin/oradata/sdb2/control01.ctl”, ”/oracle/admin/oradata/sdb2/control02.ctl” comment= ”” scope=spfile
sql statement: alter system set db_recovery_file_dest = ”/oracle/admin/oradata/recovery_area/sdb2” comment= ”” scope=spfile
sql statement: alter system set db_recovery_file_dest_size = 18446744073709551614 comment= ”” scope=spfile
sql statement: alter system set db_create_file_dest = ”/oracle/admin/oradata/sdb2/” comment= ”” scope=spfile
sql statement: alter system set audit_trail = ”none” comment= ”” scope=spfile
sql statement: alter system set audit_file_dest = ”/oracle/admin/oracle/admin/sdb2/adump” comment= ”” scope=spfile
sql statement: alter system set log_archive_max_processes = 5 comment= ”” scope=spfile
sql statement: alter system set standby_file_management = ”AUTO” comment= ”” scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 541068368 bytes
Database Buffers 289406976 bytes
Redo Buffers 2371584 bytes
contents of Memory Script:
{
sql clone “alter system set db_name =
”SDB” comment=
”Modified by RMAN duplicate” scope=spfile”;
sql clone “alter system set db_unique_name =
”SDB2” comment=
”Modified by RMAN duplicate” scope=spfile”;
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format ‘/oracle/admin/oradata/sdb2/control01.ctl’;
restore clone controlfile to ‘/oracle/admin/oradata/sdb2/control02.ctl’ from
‘/oracle/admin/oradata/sdb2/control01.ctl’;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ”SDB” comment= ”Modified by RMAN duplicate” scope=spfile
sql statement: alter system set db_unique_name = ”SDB2” comment= ”Modified by RMAN duplicate” scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 541068368 bytes
Database Buffers 289406976 bytes
Redo Buffers 2371584 bytes
Starting backup at 12-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/oracle/app/oracle/product/11.2/dbs/snapcf_SDB.f tag=TAG20150612T103404 RECID=4 STAMP=882182045
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 12-JUN-15
Starting restore at 12-JUN-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=18 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 12-JUN-15
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
“/oracle/admin/oradata/sdb2/system01.dbf”;
set newname for datafile 2 to
“/oracle/admin/oradata/sdb2/sysaux01.dbf”;
set newname for datafile 3 to
“/oracle/admin/oradata/sdb2/undo01.dbf”;
set newname for datafile 4 to
“/oracle/admin/oradata/sdb2/users01.dbf”;
backup as copy reuse
datafile 1 auxiliary format
“/oracle/admin/oradata/sdb2/system01.dbf” datafile
2 auxiliary format
“/oracle/admin/oradata/sdb2/sysaux01.dbf” datafile
3 auxiliary format
“/oracle/admin/oradata/sdb2/undo01.dbf” datafile
4 auxiliary format
“/oracle/admin/oradata/sdb2/users01.dbf” ;
sql ‘alter system archive log current’;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 12-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATA/sdb/datafile/users.259.878567899
output file name=/oracle/admin/oradata/sdb2/users01.dbf tag=TAG20150612T103415
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/sdb/datafile/system.256.878567899
output file name=/oracle/admin/oradata/sdb2/system01.dbf tag=TAG20150612T103415
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+DATA/sdb/datafile/sysaux.257.878567899
output file name=/oracle/admin/oradata/sdb2/sysaux01.dbf tag=TAG20150612T103415
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+DATA/sdb/datafile/undotbs1.258.878567899
output file name=/oracle/admin/oradata/sdb2/undo01.dbf tag=TAG20150612T103415
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
Finished backup at 12-JUN-15
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like “/oracle/app/oracle/product/11.2/dbs/arch1_208_878568082.dbf” auxiliary format
“/oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_208_%u_.arc” ;
catalog clone recovery area;
switch clone datafile all;
}
executing Memory Script
Starting backup at 12-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=208 RECID=41 STAMP=882182386
output file name=/oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_208_0mq9a27i_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 12-JUN-15
searching for all files in the recovery area
List of Files Unknown to the Database
=====================================
File Name: /oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_208_0mq9a27i_.arc
File Name: /oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_207_0gq9a1mm_.arc
cataloging files…
cataloging done
List of Cataloged Files
=======================
File Name: /oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_208_0mq9a27i_.arc
File Name: /oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_207_0gq9a1mm_.arc
datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=882182893 file name=/oracle/admin/oradata/sdb2/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=5 STAMP=882182893 file name=/oracle/admin/oradata/sdb2/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=6 STAMP=882182893 file name=/oracle/admin/oradata/sdb2/undo01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=7 STAMP=882182893 file name=/oracle/admin/oradata/sdb2/users01.dbf
contents of Memory Script:
{
set until scn 2900288;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 12-JUN-15
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 208 is already on disk as file /oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_208_0mq9a27i_.arc
archived log file name=/oracle/admin/oradata/recovery_area/sdb2/SDB2/archivelog/2015_06_12/o1_mf_1_208_0mq9a27i_.arc thread=1 sequence=208
media recovery complete, elapsed time: 00:00:00
Finished recover at 12-JUN-15
Oracle instance started
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 541068368 bytes
Database Buffers 289406976 bytes
Redo Buffers 2371584 bytes
contents of Memory Script:
{
sql clone “alter system set db_name =
”SDB2” comment=
”Reset to original value by RMAN” scope=spfile”;
sql clone “alter system reset db_unique_name scope=spfile”;
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ”SDB2” comment= ”Reset to original value by RMAN” scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 835104768 bytes
Fixed Size 2257840 bytes
Variable Size 541068368 bytes
Database Buffers 289406976 bytes
Redo Buffers 2371584 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “SDB2” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 50 M ,
GROUP 2 SIZE 50 M ,
GROUP 3 SIZE 50 M
DATAFILE
‘/oracle/admin/oradata/sdb2/system01.dbf’
CHARACTER SET AL32UTF8
contents of Memory Script:
{
set newname for tempfile 1 to
“/oracle/admin/oradata/sdb2/temp01”;
switch clone tempfile all;
catalog clone datafilecopy “/oracle/admin/oradata/sdb2/sysaux01.dbf”,
“/oracle/admin/oradata/sdb2/undo01.dbf”,
“/oracle/admin/oradata/sdb2/users01.dbf”;
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /oracle/admin/oradata/sdb2/temp01 in control file
cataloged datafile copy
datafile copy file name=/oracle/admin/oradata/sdb2/sysaux01.dbf RECID=1 STAMP=882182906
cataloged datafile copy
datafile copy file name=/oracle/admin/oradata/sdb2/undo01.dbf RECID=2 STAMP=882182906
cataloged datafile copy
datafile copy file name=/oracle/admin/oradata/sdb2/users01.dbf RECID=3 STAMP=882182906
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=882182906 file name=/oracle/admin/oradata/sdb2/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=882182906 file name=/oracle/admin/oradata/sdb2/undo01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=882182906 file name=/oracle/admin/oradata/sdb2/users01.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 12-JUN-15
Duplicate 잘 되었는지 확인
[oracle@sdb2 ~]$ sqlplus “/as sysdba”
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 12 10:52:08 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
—————- ————
SDB2 OPEN