# Example

## Requirement

1. Create the spfile for the auxiliary database
2. Start the auxiliary database on the level nomount
3. Add the parameter db\_create\_file\_dest , db\_create\_online\_log\_dest\_1 and db\_create\_online\_log\_dest\_2 in the spfile of the new database
4. Create the directories in oradata
5. Configure the Listener and the Tnsnames on the both sides

## Listener

### On the target database

```
# listener.ora Network Configuration File:
D:\\oracle\\grid\\network\\admin\\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = srvoraclewinasm)(PORT = 1521))
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 )
 )

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET # line added by Agent
```

### On the auxiliary database

```
# listener.ora Network Configuration File:
/u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = srvoracle)(PORT = 1521))
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 )
 )
SID_LIST_LISTENER =
```

## Tnsnames

### On the target database

```
DB1 =
(DESCRIPTION =
 (ADDRESS= (PROTOCOL = TCP)(HOST = srvoraclewinasm )(PORT = 1521))
 (CONNECT_DATA =
 (SID = DB1)
 )
)
DBTEST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.102)(PORT = 1521))
 (CONNECT_DATA =
 (SID = DBTEST)
 )
)
```

### On the auxiliary database

```
DBTEST =
(DESCRIPTION =
 (ADDRESS= (PROTOCOL = TCP)(HOST = srvoracle )(PORT = 1521))
 (CONNECT_DATA =
 (SID = DBTEST)
 )
)
DB1 =
(DESCRIPTION =
 (ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.56.109 )(PORT = 1521))
 (CONNECT_DATA =
 (SERVICE_NAME = DB1_SITE1.it.dbi-services.com)
 )
)
```

## Configuration File

```
# the SID of the source database (the database to clone from)
SSID=DB1
# the SID of the target/auxiliary database (the database to clone to)
TSID=DBTEST
# database connect string to clone from
SSID_CONNECT=sys/manager@DB1
# database connect string to clone to
TSID_CONNECT=sys/manager@DBTEST
# Connect string to the rman catalog, if any
RMAN_CATALOG_CONNECT=
# CLONE_MODE mode can be either ACTIVE or BACKUP
CLONE_MODE=ACTIVE
# the backup location for duplicates from backup
# this must be accessible from the host where
# the auxiliary instance is hosted
BACKUP_LOCATION=
# the type of backup which is used for backing up the databases
# can be either DISK or TAPE
BACKUP_TYPE=
# when the backup_type is tape we need to know the sbt
# parameters
SBT_TAPE_PARMS='SBT_LIBRARY=oracle.disksbt
ENV=(BACKUP_DIR=/u90/backup/DB122/)'
# specifiy the nofilenamecheck parameter for the duplicate
# <http://docs.oracle.com/database/121/RCMRF/rcmsynta020.htm#RCMRF126>
# The value of this parameter can be either YES or NO
NOFILENAMECHECK=YES
# a post script to run on the auxiliary database
# after the duplicate completed
# this can e.g. be useful for disabling archive log
# once the duplicate completed
POSTSCRIPT=
```

## Execution

```
dbdupli.cmd -f D:\oracle\local\dmk_dbduplicate\etc\refresh_DBTEST.cfg
```