ACTIVE DATABASE DUPLICATION IN SAME SERVER (11g).pdf

(1)

RMAN CLONING IN SAME SERVER

RMAN has the ability duplicate a database from a backup or from an active database. Using RMAN possible to create a duplicate database on a remote server with the same directory structure and different directory structure or else the local server with a different directory structure.

Oracle 11g has introduced active database duplication, we can create a duplicate of the target database without any backups. Duplication is performed over the network. Let us do active database duplication in same server with different directory structure.

Source database name : crms Auxiliary database name : hrms

Source database path : /u01/app/oracle/oradata/crms/ Auxiliary database path : /u01/app/oracle/oradata/hrms/

SOURCE DATABASE  192.168.1.130  (SERVER1.ORACLE.COM)  SERVER1  PRODUCTION AUXILIARY DATABASE  192.168.1.130  (SERVER1.ORACLE.COM)  SERVER1  DEVELOPMENT

CREATING DIRECTORY STRUCTURE FOR AUXILIARY DATABASE $ mkdir -p /u01/app/oracle/oradata/hrms/

$ mkdir -p /u01/app/oracle/admin/hrms/adump $ mkdir -p /u01/app/oracle/admin/hrms/dpdump

$ mkdir -p /u01/app/oracle/flash_recovery_area/hrms #(for control file)

CONNECTING SOURCE DATABASE

SYS> select name, dbid from v$database;

NAME DBID --- --- CRMS 1570419964

SYS> show parameter service_names;

NAME TYPE VALUE

--- --- --- service_names string crms.server1.com

PARAMETER FILE BACKUP FOR AUXILIARY DATABASE SYS> show parameter pfile;

NAME TYPE VALUE

--- --- --- spfile string /u01/app/oracle/product/10.2.0/db_1/dbs/spfilecrms.ora

SYS> create pfile from spfile;

(2)

[oracle@SERVER1 dbs]$ mv initcrms.ora inithrms.ora [oracle@SERVER1 dbs]$ vi inithrms.ora

Create an init.ora from the source database & rename the pfile (init.ora) file. Make all necessary changes the new init.ora file as per clone database such as, Changing db_name, location of

audit_file_dest, control_files, etc...

AUXILIARY DATABASE PFILE

hrms.__db_cache_size=503316480 hrms.__java_pool_size=16777216 hrms.__large_pool_size=16777216

hrms.__oracle_base='/u02/app/oracle' # ORACLE_BASE set from environment

hrms.__pga_aggregate_target=503316480 hrms.__sga_target=754974720 hrms.__shared_io_pool_size=0 hrms.__shared_pool_size=201326592 hrms.__streams_pool_size=0 *.audit_file_dest='/u02/app/oracle/admin/hrms/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u02/app/oracle/oradata/hrms/control01.ctl','/u02/app/oracle/flash_recovery_area/hrms/control02.ctl' *.db_block_size=8192 *.db_domain='server1.com' *.db_name='hrms' *.db_recovery_file_dest='/u02/app/oracle/flash_recovery_area' *.db_recovery_file_dest_size=4404019200 *.diagnostic_dest='/u02/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=hrmsXDB)' *.log_archive_format='%t_%s_%r.dbf' *.memory_target=1244659712 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1'

# Below parameters are used for from where to where the DATAFILES & LOGFILES will be cloned

db_file_name_convert=('/u02/app/oracle/oradata/crms/', '/u02/app/oracle/oradata/hrms') log_file_name_convert=('/u02/app/oracle/oradata/crms/', '/u02/app/oracle/oradata/hrms')

If the source database directory structure & clone database directory structure differs, then need to use db_file_name_convert & log_file_name_convert parameters.

(3)

TARGET DATABASE PFILE

crms.__db_cache_size=503316480 crms.__java_pool_size=16777216 crms.__large_pool_size=16777216

crms.__oracle_base='/u02/app/oracle' # ORACLE_BASE set from environment

crms.__pga_aggregate_target=503316480 crms.__sga_target=754974720 crms.__shared_io_pool_size=0 crms.__shared_pool_size=201326592 crms.__streams_pool_size=0 *.audit_file_dest='/u02/app/oracle/admin/crms/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u02/app/oracle/oradata/crms/control01.ctl','/u02/app/oracle/flash_recovery_area/crms/control02.ctl' *.db_block_size=8192 *.db_domain='server1.com' *.db_name='crms' *.db_recovery_file_dest='/u02/app/oracle/flash_recovery_area' *.db_recovery_file_dest_size=4404019200 *.diagnostic_dest='/u02/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=crmsXDB)' *.log_archive_format='%t_%s_%r.dbf' *.memory_target=1244659712 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1'

CREATING PASSWORD FILE FOR AUXILIARY DATABASE $ export ORACLE_SID=hrms

$ cd $ORACLE_HOME/dbs/

$ orapwd file=orapwhrms password=racdba force=y entries=3

Password must be same on Target database & Auxiliary database. When you connect RMAN to the Source database as TARGET, must specify a password, even if RMAN uses OS authentication.

SET THE SAME PASSWORD OF CLONE DATABASE INTO THE TARGET DATABASE SYS> alter user sys identified by racdba; # In crms database

(4)

LISTETENER.ORA FILE CONFIGURATION

# listener.ora Network Configuration File: /u02/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST = (DESCRIPTION =

(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.1.130)(PORT=1521)) ) ) ADR_BASE_LISTENER = /u02/app/oracle SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME=crms) (ORACLE_HOME=/u02/app/oracle/product/11.2.0/dbhome_1) # (GLOBAL_DBNAME=crms) ) (SID_DESC = (SID_NAME=hrms) (ORACLE_HOME=/u02/app/oracle/product/11.2.0/dbhome_1) # (GLOBAL_DBNAME=hrms) ) )

TNSNAMES.ORA FILE CONFIGURATION

# tnsnames.ora Network Configuration File: /u02/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

CRMSDB = (DESCRIPTION = (ADDRESS_LIST =

(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.241.130)(PORT=1521))

) FOR TARGET DB (CONNECT_DATA = (SERVER=DEDICATED) (SERVICE_NAME=crms) ) )

(5)

HRMSDB =

(DESCRIPTION = (ADDRESS_LIST =

(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.241.130)(PORT=1521))

) FOR AUXILIARY DB (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hrms) ) ) STARTING LISTENER $ lsnrctl start LISTENER

Starting /u02/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /u02/app/oracle/product/11.2.0/dbhome_1/network/admin/listene r.ora Log messages written to /u02/app/oracle/diag/tnslsnr/SERVER1/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.130)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.130)(PORT=1521))) STATUS of the LISTENER

---

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 12-JAN-2015 18:22:42

Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off

Security ON: Local OS Authentication SNMP OFF

Listener Parameter File /u02/app/oracle/product/11.2.0/dbhome_1/network/admin/listen er.ora Listener Log File /u02/app/oracle/diag/tnslsnr/SERVER1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.130)(PORT=1521))) Services Summary...

Service "crms" has 1 instance(s).

(6)

Service "hrms" has 1 instance(s).

Instance "hrms", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully

CHECKING TNS CONNECTIVITY ON TARGET SEVER $ tnsping crmsdb

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.130) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = crms)))OK (30 msec)

$ tnsping hrmsdb

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.130) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hrms))) OK (20 msec)

STARTUP AUXILIARY DATABASE AT NOMOUNT STAGE & EXIT $ export ORACLE_SID=hrms

$ sqlplus “/as sysdba”

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1255473152 bytes Fixed Size 1336232 bytes Variable Size 754977880 bytes Database Buffers 486539264 bytes Redo Buffers 12619776 bytes

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

Once I started my auxiliary instance in NOMOUNT state, i have disconnected SYS as ‘NO SESSION’ before duplicating a database. It is must & should.

(7)

DUPLICATING TARGET DATABASE

In order to clone with the source database open and must be on archivelog mode. From 11g we can clone databases using the “from active” database option. In this case we do NOT require an existing backup, the active datafiles will be used as the source for the clone.

CONNECT TO THE TARGET (SOURCE) & AUXILIARY (NEW CLONE) DATABASES USING RMAN $ export ORACLE_SID=crms

$ rman target sys/racdba@CRMSDB auxiliary sys/racdba@HRMSDB

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jan 12 21:32:05 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: CRMS (DBID=1570419964)

connected to auxiliary database: HRMS (not mounted)

ISSUE THE RMAN DUPLICATE COMMAND TO START THE CLONING PROCESS RMAN> duplicate target database to 'hrms' from active database;

Starting Duplicate Db at 12-JAN-15

using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 device type=DISK contents of Memory Script:

{

sql clone "create spfile from memory"; }

executing Memory Script

sql statement: create spfile from memory executing Memory Script

sql statement: create spfile from memory contents of Memory Script:

{

shutdown clone immediate; startup clone nomount; }

executing Memory Script Oracle instance shut down

connected to auxiliary database (not started) Oracle instance started

(8)

contents of Memory Script: {

sql clone "alter system set db_name = ''CRMS'' comment=

''Modified by RMAN duplicate'' scope=spfile"; sql clone "alter system set db_unique_name = ''HRMS'' comment=

''Modified by RMAN duplicate'' scope=spfile"; shutdown clone immediate;

startup clone force nomount

backup as copy current controlfile auxiliary format '/u02/app/oracle/oradata/hrms/control01.ctl';

restore clone controlfile to '/u02/app/oracle/flash_recovery_area/hrms/control02.ctl' from '/u02/app/oracle/oradata/hrms/control01.ctl';

alter clone database mount; }

sql statement: alter system set db_name = ''CRMS'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set db_unique_name = ''HRMS'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down Oracle instance started

Total System Global Area 1255473152 bytes Fixed Size 1336232 bytes Variable Size 754977880 bytes Database Buffers 486539264 bytes Redo Buffers 12619776 bytes Starting backup at 12-JAN-15

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=17 device type=DISK channel ORA_DISK_1: starting datafile copy copying current control file

output file name=/u02/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_crms.f tag=TAG20150112T215240 RECID=17 STAMP=868830761

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 12-JAN-15

Starting restore at 12-JAN-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-JAN-15

(9)

set newname for datafile 1 to

"/u02/app/oracle/oradata/hrms/system01.dbf"; set newname for datafile 2 to

"/u02/app/oracle/oradata/hrms/sysaux01.dbf"; set newname for datafile 3 to

"/u02/app/oracle/oradata/hrms/undotbs01.dbf"; set newname for datafile 4 to

"/u02/app/oracle/oradata/hrms/users01.dbf"; backup as copy reuse

datafile 1 auxiliary format

"/u02/app/oracle/oradata/hrms/system01.dbf" datafile 2 auxiliary format "/u02/app/oracle/oradata/hrms/sysaux01.dbf" datafile 3 auxiliary format "/u02/app/oracle/oradata/hrms/undotbs01.dbf" datafile 4 auxiliary format "/u02/app/oracle/oradata/hrms/users01.dbf" ; sql 'alter system archive log current';

}

executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting backup at 12-JAN-15 using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u02/app/oracle/oradata/crms/system01.dbf output file name=/u02/app/oracle/oradata/hrms/system01.dbf tag=TAG20150112T215248 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

input datafile file number=00002 name=/u02/app/oracle/oradata/crms/sysaux01.dbf output file name=/u02/app/oracle/oradata/hrms/sysaux01.dbf tag=TAG20150112T215248 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:26

input datafile file number=00003 name=/u02/app/oracle/oradata/crms/undotbs01.dbf output file name=/u02/app/oracle/oradata/hrms/undotbs01.dbf tag=TAG20150112T215248 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07

input datafile file number=00004 name=/u02/app/oracle/oradata/crms/users01.dbf output file name=/u02/app/oracle/oradata/hrms/users01.dbf tag=TAG20150112T215248 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01

(10)

sql statement: alter system archive log current contents of Memory Script:

{

backup as copy reuse archivelog like

"/u02/app/oracle/flash_recovery_area/CRMS/archivelog/2015_01_12/o1_mf_1_35_bc7x8mnq_.arc" auxiliary format

"/u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_35_%u_.arc" ; catalog clone recovery area;

switch clone datafile all; }

Starting backup at 12-JAN-15 using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=35 RECID=34 STAMP=868830827 output file

name=/u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_35_2spsijjc_.arc RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 Finished backup at 12-JAN-15

searching for all files in the recovery area List of Files Unknown to the Database

===================================== File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_32_2apsii46_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_29_1opsif4n_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_31_24psihao_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_26_16psidmc_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_25_10psict2_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_33_2gpsiieh_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_35_2spsijjc_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_30_1upsigs5_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_28_1ipsiepl_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_27_1cpsie5u_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_34_2mpsij0t_.arc

(11)

cataloging files... cataloging done

List of Cataloged Files ======================= File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_32_2apsii46_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_29_1opsif4n_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_31_24psihao_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_26_16psidmc_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_25_10psict2_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_33_2gpsiieh_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_35_2spsijjc_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_30_1upsigs5_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_28_1ipsiepl_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_27_1cpsie5u_.arc File Name: /u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_34_2mpsij0t_.arc datafile 1 switched to datafile copy

input datafile copy RECID=17 STAMP=868830829 file name=/u02/app/oracle/oradata/hrms/system01.dbf datafile 2 switched to datafile copy

input datafile copy RECID=18 STAMP=868830829 file name=/u02/app/oracle/oradata/hrms/sysaux01.dbf datafile 3 switched to datafile copy

input datafile copy RECID=19 STAMP=868830829 file name=/u02/app/oracle/oradata/hrms/undotbs01.dbf datafile 4 switched to datafile copy

input datafile copy RECID=20 STAMP=868830829 file name=/u02/app/oracle/oradata/hrms/users01.dbf contents of Memory Script:

{ set until scn 1159256; recover clone database delete archivelog ; }

(12)

Starting recover at 12-JAN-15 using channel ORA_AUX_DISK_1 starting media recovery

archived log for thread 1 with sequence 35 is already on disk as file

/u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_35_2spsijjc_.arc archived log file

name=/u02/app/oracle/flash_recovery_area/HRMS/archivelog/2015_01_12/o1_mf_1_35_2spsijjc_.arc thread=1 sequence=35

media recovery complete, elapsed time: 00:00:00 Finished recover at 12-JAN-15

shutdown clone immediate; startup clone nomount;

sql clone "alter system set db_name = ''HRMS'' 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 database dismounted

Oracle instance shut down

sql statement: alter system set db_name = ''HRMS'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset db_unique_name scope=spfile Oracle instance shut down

(13)

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "HRMS" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE

GROUP 1 ( '/u02/app/oracle/oradata/hrmsredo01.log' ) SIZE 50 M REUSE, GROUP 2 ( '/u02/app/oracle/oradata/hrmsredo02.log' ) SIZE 50 M REUSE, GROUP 3 ( '/u02/app/oracle/oradata/hrmsredo03.log' ) SIZE 50 M REUSE DATAFILE

'/u02/app/oracle/oradata/hrms/system01.dbf' CHARACTER SET WE8MSWIN1252

set newname for tempfile 1 to

"/u02/app/oracle/oradata/hrms/temp01.dbf"; switch clone tempfile all;

catalog clone datafilecopy "/u02/app/oracle/oradata/hrms/sysaux01.dbf", "/u02/app/oracle/oradata/hrms/undotbs01.dbf",

"/u02/app/oracle/oradata/hrms/users01.dbf"; switch clone datafile all;

}

executing command: SET NEWNAME

renamed tempfile 1 to /u02/app/oracle/oradata/hrms/temp01.dbf in control file cataloged datafile copy

datafile copy file name=/u02/app/oracle/oradata/hrms/sysaux01.dbf RECID=1 STAMP=868830846 cataloged datafile copy

datafile copy file name=/u02/app/oracle/oradata/hrms/undotbs01.dbf RECID=2 STAMP=868830846 cataloged datafile copy

datafile copy file name=/u02/app/oracle/oradata/hrms/users01.dbf RECID=3 STAMP=868830846 datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=868830846 file name=/u02/app/oracle/oradata/hrms/sysaux01.dbf datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=868830846 file name=/u02/app/oracle/oradata/hrms/undotbs01.dbf datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=868830846 file name=/u02/app/oracle/oradata/hrms/users01.dbf contents of Memory Script:

{

Alter clone database open resetlogs; }

executing Memory Script database opened

(14)

$ ps -ef | grep pmon

oracle 9406 1 0 22:09 ? 00:00:00 ora_pmon_hrms oracle 9842 30123 0 22:37 pts/3 00:00:00 grep pmon oracle 31598 1 0 19:26 ? 00:00:02 ora_pmon_crms

CONNECTING AUXILIARY DATABASE $ export ORACLE_SID=hrms

$ rlsqlplus "/as sysdba"

$ rlsqlplus "/as sysdba"

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS>select name, log mode, dbid from v$database;

NAME LOG_MODE DBID --- --- ---