Monday, October 4, 2010

RMAN: how to duplicate a non-ASM active database to an ASM database

My goal is to duplicate a production database where all datafiles are on file system to an auxiliary database based on ASM.
According on the same steps performed on this previous post http://dbaworkshop.blogspot.com/2010/09/rman-how-to-duplicate-database-on-same.html I've used the following settings:

[oracle@plutone admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DB11G)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = DB11G)
)
(SID_DESC =
(GLOBAL_DBNAME = DUP11G)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = DUP11G)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.172.130)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@plutone admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DUP11G =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = plutone)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = DUP11G)
)
)

DB11G =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = plutone)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB11G)
)
)


I needed of course to add at least an ASM instance and a diskgroup. After I added 10GB of a virtual hard disk to my virtual machine I completed the following steps:
[root@plutone ~]# fdisk -l

Disk /dev/sda: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 25 200781 83 Linux
/dev/sda2 26 286 2096482+ 82 Linux swap / Solaris
/dev/sda3 287 2610 18667530 83 Linux

Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 1305 10482381 83 Linux

Disk /dev/sdc: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 1305 10482381 83 Linux

Disk /dev/sdd: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdd doesn't contain a valid partition table
[root@plutone ~]# fdisk /dev/sdd
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

The number of cylinders for this disk is set to 1305.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1305, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305):
Using default value 1305

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

[root@plutone ~]# fdisk -l

Disk /dev/sda: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 25 200781 83 Linux
/dev/sda2 26 286 2096482+ 82 Linux swap / Solaris
/dev/sda3 287 2610 18667530 83 Linux

Disk /dev/sdb: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 1305 10482381 83 Linux

Disk /dev/sdc: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 1305 10482381 83 Linux

Disk /dev/sdd: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdd1 1 1305 10482381 83 Linux

[root@plutone ~]# mkfs.ext3 /dev/sdd1
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
1310720 inodes, 2620595 blocks
131029 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=2684354560
80 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632

Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 34 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.

[root@plutone ~]# more /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
/dev/sdb1 /u02 ext3 defaults 1 1
#/dev/sdc1 /u03 ext3 defaults 1 1
[root@plutone ~]# mkdir /u04

[root@plutone ~]# more /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sda2 swap swap defaults 0 0
/dev/sdb1 /u02 ext3 defaults 1 1
#/dev/sdc1 /u03 ext3 defaults 1 1
/dev/sdd1 /u04 ext3 defaults 1 1

[root@plutone ~]# mount /u04
[root@plutone tmp]# mkdir -p /u04/app/oracle/product/11.2.0/grid
[root@plutone tmp]# chown -R oracle.oinstall /u04


Now it's time to install the ASM drivers. Download them from OTN. For my machine they were:
[root@plutone rpm]# ls
oracleasm-2.6.18-194.11.3.el5-2.0.5-1.el5.x86_64.rpm oracleasmlib-2.0.4-1.el5.x86_64.rpm oracleasm-support-2.1.3-1.el5.x86_64.rpm
[root@plutone rpm]# rpm -Uvh oracleasm*

Preparing...########################################## [100%]
1:oracleasm-support################################### [ 33%]
2:oracleasm-2.6.18-194.11############################# [ 67%]
3:oracleasmlib######################################## [100%]

ASMLib software packages are now installed successfully.

Configure the ASM library, with the following command:
/etc/init.d/oracleasm configure
Type oracle and oinstall as user and group name that own the driver interface; type y to configure starting ASM library on boot and again y to scan ASM disks on boot.

Create the diskgroup:
/etc/init.d/oracleasm createdisk DG_DATA_DUP11G /dev/sdd1


Download/extract the grid software from oracle website and create the ASM Instance as root user:
./runInstaller




























Perform the post installation task

[root@plutone tmp]# /u04/app/oracle/product/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u04/app/oracle/product/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2010-10-01 16:11:18: Checking for super user privileges
2010-10-01 16:11:18: User has super user privileges
2010-10-01 16:11:18: Parsing the host name
Using configuration parameter file: /u04/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
CRS-4664: Node plutone successfully pinned.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
ADVM/ACFS is not supported on centos-release-5-5.el5.centos

plutone 2010/10/01 16:11:48 /u04/app/oracle/product/11.2.0/grid/cdata/plutone/backup_20101001_161148.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
Updating inventory properties for clusterware
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 2047 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.



The ASM instance is now running:
[root@plutone tmp]# !ps
ps -ef|grep smon
oracle 15904 1 0 16:14 ? 00:00:00 asm_smon_+ASM
root 16204 5028 0 16:22 pts/0 00:00:00 grep smon


Create or copy the orapwd file for the duplicated database
[oracle@plutone ~]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs
[oracle@plutone dbs]$ orapwd password=oracle file=orapwDUP11G entries=20
or
[oracle@plutone dbs]$ cp orapwDB11G orapwDUP11G


Startup the listener and the two databases (target DB11G in open mode, auxiliary DUP11G in nomount mode). Then start rman with the following command:
[oracle@plutone ~]$ rman target sys/oracle@DB11G auxiliary sys/oracle@DUP11G

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 4 15:11:36 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: DB11G (DBID=197032563)
connected to auxiliary database: DUP11G (not mounted)

RMAN> duplicate target database to DUP11G from active database spfile parameter_value_convert '/DATA/DB11G/','+DATA/' set db_create_file_dest='+DATA';

Starting Duplicate Db at 2010-10-04:15:11:47
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=97 device type=DISK

contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/spfileDB11G.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/db_1/dbs/spfileDUP11G.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfileDUP11G.ora''";
}
executing Memory Script

Starting backup at 2010-10-04:15:11:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=16 device type=DISK
Finished backup at 2010-10-04:15:11:55

sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfileDUP11G.ora''

contents of Memory Script:
{
sql clone "alter system set db_name =
''DUP11G'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set control_files =
''+DATA/control01.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set db_create_file_dest =
''+DATA'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

sql statement: alter system set db_name = ''DUP11G'' comment= ''duplicate'' scope=spfile

sql statement: alter system set control_files = ''+DATA/control01.ctl'' comment= '''' scope=spfile

sql statement: alter system set db_create_file_dest = ''+DATA'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 263049216 bytes

Fixed Size 2212448 bytes
Variable Size 201330080 bytes
Database Buffers 54525952 bytes
Redo Buffers 4980736 bytes

contents of Memory Script:
{
sql clone "alter system set db_name =
''DB11G'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''DUP11G'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format '+DATA/control01.ctl';
alter clone database mount;
}
executing Memory Script

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

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

Oracle instance shut down

Oracle instance started

Total System Global Area 263049216 bytes

Fixed Size 2212448 bytes
Variable Size 209718688 bytes
Database Buffers 46137344 bytes
Redo Buffers 4980736 bytes

Starting backup at 2010-10-04:15:13:55
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_DB11G.f tag=TAG20101004T151355 RECID=4 STAMP=731517240
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 2010-10-04:15:14:11

database mounted

contents of Memory Script:
{
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
backup as copy reuse
datafile 1 auxiliary format new
datafile 2 auxiliary format new
datafile 3 auxiliary format new
datafile 4 auxiliary format new
datafile 5 auxiliary format new
datafile 6 auxiliary format new
;
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

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 2010-10-04:15:14:18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/DATA/DB11G/soe.dbf
output file name=+DATA/dup11g/datafile/soe.257.731517261 tag=TAG20101004T151418
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:58
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/DATA/DB11G/system01.dbf
output file name=+DATA/dup11g/datafile/system.258.731517499 tag=TAG20101004T151418
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/DATA/DB11G/undotbs01.dbf
output file name=+DATA/dup11g/datafile/undotbs1.259.731517565 tag=TAG20101004T151418
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/DATA/DB11G/sysaux01.dbf
output file name=+DATA/dup11g/datafile/sysaux.260.731517621 tag=TAG20101004T151418
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/DATA/DB11G/example01.dbf
output file name=+DATA/dup11g/datafile/example.261.731517665 tag=TAG20101004T151418
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/DATA/DB11G/users01.dbf
output file name=+DATA/dup11g/datafile/users.262.731517681 tag=TAG20101004T151418
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2010-10-04:15:21:21

sql statement: alter system archive log current

contents of Memory Script:
{
backup as copy reuse
archivelog like "/u02/FRA11G/DB11G/archivelog/2010_10_04/o1_mf_1_58_6bmo6m11_.arc" auxiliary format
"/u02/FRA11G/DUP11G/archivelog/2010_10_04/o1_mf_1_58_%u_.arc" ;
catalog clone recovery area;
switch clone datafile all;
}
executing Memory Script

Starting backup at 2010-10-04:15:21:25
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=58 RECID=7 STAMP=731517683
output file name=/u02/FRA11G/DUP11G/archivelog/2010_10_04/o1_mf_1_58_0elpk4nm_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 2010-10-04:15:21:27

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: /u02/FRA11G/DUP11G/archivelog/2010_10_04/o1_mf_1_58_0elpk4nm_.arc
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u02/FRA11G/DUP11G/archivelog/2010_10_04/o1_mf_1_58_0elpk4nm_.arc

datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=731517689 file name=+DATA/dup11g/datafile/system.258.731517499
datafile 2 switched to datafile copy
input datafile copy RECID=5 STAMP=731517689 file name=+DATA/dup11g/datafile/sysaux.260.731517621
datafile 3 switched to datafile copy
input datafile copy RECID=6 STAMP=731517689 file name=+DATA/dup11g/datafile/undotbs1.259.731517565
datafile 4 switched to datafile copy
input datafile copy RECID=7 STAMP=731517689 file name=+DATA/dup11g/datafile/users.262.731517681
datafile 5 switched to datafile copy
input datafile copy RECID=8 STAMP=731517689 file name=+DATA/dup11g/datafile/example.261.731517665
datafile 6 switched to datafile copy
input datafile copy RECID=9 STAMP=731517689 file name=+DATA/dup11g/datafile/soe.257.731517261

contents of Memory Script:
{
set until scn 1325144;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 2010-10-04:15:21:31
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=13 device type=DISK

starting media recovery

archived log for thread 1 with sequence 58 is already on disk as file /u02/FRA11G/DUP11G/archivelog/2010_10_04/o1_mf_1_58_0elpk4nm_.arc
archived log file name=/u02/FRA11G/DUP11G/archivelog/2010_10_04/o1_mf_1_58_0elpk4nm_.arc thread=1 sequence=58
media recovery complete, elapsed time: 00:00:02
Finished recover at 2010-10-04:15:21:40

contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
sql clone "alter system set db_name =
''DUP11G'' 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

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 263049216 bytes

Fixed Size 2212448 bytes
Variable Size 226495904 bytes
Database Buffers 29360128 bytes
Redo Buffers 4980736 bytes

sql statement: alter system set db_name = ''DUP11G'' 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 263049216 bytes

Fixed Size 2212448 bytes
Variable Size 226495904 bytes
Database Buffers 29360128 bytes
Redo Buffers 4980736 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUP11G" 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
'+DATA/dup11g/datafile/system.258.731517499'
CHARACTER SET WE8MSWIN1252


contents of Memory Script:
{
set newname for clone tempfile 1 to new;
switch clone tempfile all;
catalog clone datafilecopy "+DATA/dup11g/datafile/sysaux.260.731517621",
"+DATA/dup11g/datafile/undotbs1.259.731517565",
"+DATA/dup11g/datafile/users.262.731517681",
"+DATA/dup11g/datafile/example.261.731517665",
"+DATA/dup11g/datafile/soe.257.731517261";
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATA in control file

cataloged datafile copy
datafile copy file name=+DATA/dup11g/datafile/sysaux.260.731517621 RECID=1 STAMP=731517731
cataloged datafile copy
datafile copy file name=+DATA/dup11g/datafile/undotbs1.259.731517565 RECID=2 STAMP=731517731
cataloged datafile copy
datafile copy file name=+DATA/dup11g/datafile/users.262.731517681 RECID=3 STAMP=731517731
cataloged datafile copy
datafile copy file name=+DATA/dup11g/datafile/example.261.731517665 RECID=4 STAMP=731517731
cataloged datafile copy
datafile copy file name=+DATA/dup11g/datafile/soe.257.731517261 RECID=5 STAMP=731517731

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=731517731 file name=+DATA/dup11g/datafile/sysaux.260.731517621
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=731517731 file name=+DATA/dup11g/datafile/undotbs1.259.731517565
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=731517731 file name=+DATA/dup11g/datafile/users.262.731517681
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=731517731 file name=+DATA/dup11g/datafile/example.261.731517665
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=731517731 file name=+DATA/dup11g/datafile/soe.257.731517261

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 2010-10-04:15:22:39

RMAN> exit


Recovery Manager complete


Let's see where are the datafiles for DUP11G instance:
[oracle@plutone ~]$ export ORACLE_SID=DUP11G
[oracle@plutone ~]$ SQL

SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 4 15:28:11 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

sys@DUP11G> col NAME format a50
sys@DUP11G> select FILE#, NAME from V$DATAFILE;

FILE# NAME
---------- --------------------------------------------------
1 +DATA/dup11g/datafile/system.258.731517499
2 +DATA/dup11g/datafile/sysaux.260.731517621
3 +DATA/dup11g/datafile/undotbs1.259.731517565
4 +DATA/dup11g/datafile/users.262.731517681
5 +DATA/dup11g/datafile/example.261.731517665
6 +DATA/dup11g/datafile/soe.257.731517261

6 rows selected.


That's all.

46 comments:

Anonymous said...

xnu [url=http://www.beatsbydrename.com]Beats By Dre[/url] qys http://www.beatsbydrename.com zzp [url=http://www.cheapbeatsbydrelo.com]Cheap Beats By Dre[/url] xhi http://www.cheapbeatsbydrelo.com kjq [url=http://www.drdrebeatswe.com]Dr Dre Beats[/url] sda http://www.drdrebeatswe.com ocf [url=http://www.cheapbeatsbydrewe.com]Dr Dre Beats[/url] mzs http://www.cheapbeatsbydrewe.com yeb [url=http://www.beatsbydrewe.com]Beats By Dre[/url] fkm http://www.beatsbydrewe.com vks [url=http://www.celineluggagetotediscount.com]Celine Bag[/url] gaw http://www.celineluggagetotediscount.com teq [url=http://www.celinehandbagsdiscount.com]Celine Bag[/url] bdg http://www.celinehandbagsdiscount.com hst

Anonymous said...

roc [url=http://www.hollisteroutletnamee.com]Hollister Outlet[/url] wnp http://www.hollisteroutletnamee.com rsc [url=http://www.hollisterjeansname.com]Hollister Outlet[/url] orf http://www.hollisterjeansname.com xmj [url=http://www.hollisteroutletname.com]Hollister Clothing[/url] lmf http://www.hollisteroutletname.com lgs [url=http://www.hollisterjeanswe.com]Hollister Jeans[/url] csi http://www.hollisterjeanswe.com mtr [url=http://www.cheapbeatsbydrename.com]Hollister Clothing[/url] sku http://www.cheapbeatsbydrename.com pmm [url=http://www.celineluggagetotediscount.com]Celine Handbags[/url] cby http://www.celineluggagetotediscount.com lap [url=http://www.celinehandbagsdiscount.com]Celine Bags[/url] jdz http://www.celinehandbagsdiscount.com ahp

Anonymous said...

jdp [url=http://www.celineluggagetotediscount.com]Celine Handbags[/url] kla http://www.celineluggagetotediscount.com xcm [url=http://www.celinehandbagsdiscount.com]Celine Bag[/url] dus http://www.celinehandbagsdiscount.com aep [url=http://www.celinebagxiao.com]Celine Bags[/url] avv http://www.celinebagxiao.com feb [url=http://www.celinehandbagswe.com]Celine Bags[/url] sdv http://www.celinehandbagswe.com cmy [url=http://www.drdrebeatsname.com]Beats By Dre[/url] xaa http://www.drdrebeatsname.com szh

Anonymous said...

These are truly wonderful ideas in about blogging. You have touched some good points here.

Any way keep up wrinting.

Feel free to surf to my web blog healthy waist to height ratio

Anonymous said...

Hello to all, the contents present at this web site are actually remarkable for
people knowledge, well, keep up the nice work fellows.


My blog post; how do i get out of a payday loans

oakleyses said...

louis vuitton, longchamp handbags, longchamp outlet, michael kors outlet, louboutin, michael kors outlet, michael kors outlet online, oakley sunglasses cheap, louis vuitton handbags, gucci outlet, michael kors outlet store, oakley vault, chanel handbags, prada outlet, kate spade handbags, louboutin outlet, louis vuitton outlet online, prada handbags, nike air max, polo ralph lauren outlet online, coach purses, michael kors outlet online, coach outlet, nike free, nike shoes, louis vuitton outlet, burberry outlet online, tiffany and co, michael kors outlet online, tory burch outlet, coach factory outlet, ray ban sunglasses, louboutin shoes, polo ralph lauren outlet, oakley sunglasses, coach outlet, jordan shoes, kate spade outlet, coach outlet store online, christian louboutin shoes, longchamp handbags, burberry outlet online, louis vuitton outlet, air max, ray ban outlet

oakleyses said...

louis vuitton, longchamp handbags, longchamp outlet, michael kors outlet, louboutin, michael kors outlet, michael kors outlet online, oakley sunglasses cheap, louis vuitton handbags, gucci outlet, michael kors outlet store, oakley vault, chanel handbags, prada outlet, kate spade handbags, louboutin outlet, louis vuitton outlet online, prada handbags, nike air max, polo ralph lauren outlet online, coach purses, michael kors outlet online, coach outlet, nike free, nike shoes, louis vuitton outlet, burberry outlet online, tiffany and co, michael kors outlet online, tory burch outlet, coach factory outlet, ray ban sunglasses, louboutin shoes, polo ralph lauren outlet, oakley sunglasses, coach outlet, jordan shoes, kate spade outlet, coach outlet store online, christian louboutin shoes, longchamp handbags, burberry outlet online, louis vuitton outlet, air max, ray ban outlet

oakleyses said...

hogan sito ufficiale, mulberry, montre femme, new balance pas cher, hollister, karen millen, lululemon, hollister, hollister, louis vuitton, oakley pas cher, ralph lauren, burberry, longchamp soldes, louis vuitton uk, nike roshe, air force, nike trainers, nike free pas cher, timberland, ray ban uk, nike air max, longchamp, north face pas cher, nike huarache, north face, nike roshe run, tn pas cher, vans outlet, vans pas cher, hermes pas cher, ralph lauren pas cher, lacoste, michael kors, michael kors, nike free, vanessa bruno, michael kors, barbour, sac guess, sac louis vuitton, air max, sac louis vuitton, longchamp, louboutin, air jordan, ray ban pas cher, abercrombie and fitch, nike blazer, converse pas cher

oakleyses said...

hogan sito ufficiale, mulberry, montre femme, new balance pas cher, hollister, karen millen, lululemon, hollister, hollister, louis vuitton, oakley pas cher, ralph lauren, burberry, longchamp soldes, louis vuitton uk, nike roshe, air force, nike trainers, nike free pas cher, timberland, ray ban uk, nike air max, longchamp, north face pas cher, nike huarache, north face, nike roshe run, tn pas cher, vans outlet, vans pas cher, hermes pas cher, ralph lauren pas cher, lacoste, michael kors, michael kors, nike free, vanessa bruno, michael kors, barbour, sac guess, sac louis vuitton, air max, sac louis vuitton, longchamp, louboutin, air jordan, ray ban pas cher, abercrombie and fitch, nike blazer, converse pas cher

oakleyses said...

moncler outlet, ghd, uggs on sale, canada goose pas cher, lululemon outlet, canada goose, moncler, celine handbags, canada goose outlet, juicy couture outlet, ugg boots, herve leger, north face jackets, nfl jerseys, soccer jerseys, mac cosmetics, instyler ionic styler, rolex watches, ugg outlet, valentino shoes, canada goose outlet, p90x3, beats by dre, birkin bag, babyliss pro, moncler, marc jacobs, ugg boots, abercrombie and fitch, moncler, mont blanc, north face outlet, mcm handbags, wedding dresses, canada goose outlet, chi flat iron, supra shoes, juicy couture outlet, ugg, insanity, reebok outlet, new balance shoes, roshe run, bottega veneta, asics shoes, giuseppe zanotti, ferragamo shoes, jimmy choo shoes, soccer shoes, canada goose uk

oakleyses said...

moncler outlet, ghd, uggs on sale, canada goose pas cher, lululemon outlet, canada goose, moncler, celine handbags, canada goose outlet, juicy couture outlet, ugg boots, herve leger, north face jackets, nfl jerseys, soccer jerseys, mac cosmetics, instyler ionic styler, rolex watches, ugg outlet, valentino shoes, canada goose outlet, p90x3, beats by dre, birkin bag, babyliss pro, moncler, marc jacobs, ugg boots, abercrombie and fitch, moncler, mont blanc, north face outlet, mcm handbags, wedding dresses, canada goose outlet, chi flat iron, supra shoes, juicy couture outlet, ugg, insanity, reebok outlet, new balance shoes, roshe run, bottega veneta, asics shoes, giuseppe zanotti, ferragamo shoes, jimmy choo shoes, soccer shoes, canada goose uk

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

yanmaneee said...

kyrie 5 shoes
yeezy boost 350 v2
nike air force
stephen curry shoes
nhl jerseys
adidas ultra
kyrie shoes
yeezy
longchamp handbags
golden goose

leadmirror said...

Nice article
Thanks for sharing the information
Please visit leadmirror to know your blog rank
https://www.leadmirror.com/aboutus

Training for IT and Software Courses said...

Wow it is really wonderful and awesome thus it is veWow, it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot.aws training in bangalore

iuwekjhbr said...

Please refer below if you are looking for Online Job Support and Proxy support from India

Java Online Job Support and Proxy support from India | AWS Online Job Support and Proxy Support From India | Python Online Job Support and Proxy Support From India | Angular Online Job Support from India | Android Online Job Support and Proxy Support from India

Thank you for excellent article.

KARTHIK said...

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
http://chennaitraining.in/bi-bw-training-in-chennai/
http://chennaitraining.in/solidworks-training-in-chennai/
http://chennaitraining.in/autocad-training-in-chennai/
http://chennaitraining.in/ansys-training-in-chennai/
http://chennaitraining.in/revit-architecture-training-in-chennai/
http://chennaitraining.in/primavera-training-in-chennai/

Florahmelda said...

Psychology coursework writing services are essential and they have become very popular for those seeking psychology research writing help services since most of them seek Psychology Research Writing Services.

werwer said...

Microsoft Office Professional Plus 2010 Product Key Crack will be to aid distinct features and accomplish office linked functions. Its major aim is to make the office do the job easier. Different tools for making ready the document, shows, excel sheets, notes etc. are supplied under the software. These tools verify for being useful in distinct office, university, or online business affiliated will work. It's become a necessity to the current occasions. Still, many individuals lack the awareness of its perks and don't activate it. https://freeprosoftz.com/microsoft-office-2010-product-key-full-version/

shoaib said...

Hello there I am so delighted I found your webpage, I really found you by mistake, while I was looking on Askjeeve for
something else, Anyhow I am here now and would just like
to say many thanks for a remarkable post and an all round
thrilling blog.
windows 10 crack
wondershare vedio convertor ultimate crack
itrash crack
driver checker crack serial key

Crack said...

Hey, can you consider telling which web host you are using?
I uploaded your blog to 3 different browsers and I had to.
Let's say this blog loads much faster than most. Can you recommend a good one?
Who provides hosting for a fair price? Bravo!
I appreciate it!
reason crack
wondershare video converter ultimate crack
total av antivirus crack
kaspersky internet security crack

jasonbob said...

lebron shoes
kd 12
supreme
stone island t shirt
kd shoes
canada goose jacket
moncler outlet
lebron 18
moncler
bape

sovevis118 said...


https://seeratpc.com/
Winzip Crack is an advanced version of WinZip which is the latest tool of the software series. It is a very advanced tool that can be used to extracting or unzip your files. It is used to extract and unzip many files. You can use this software with many files combine with the zip files. If you want to send many files at a time in a short time then you can use this software. It can use the length of your big files. It can use to decrease the size of your heavy files.






Adeel Nawaz said...

I'm really impressed with your writing skills, as smart as the structure of your weblog.
Is this a paid topic or do you change it yourself?
However, stopping by with great quality writing, it's hard to see any good blog today.

glary utilities pro crack
minitool power data recovery crack
avast driver updater crack
driver navigator crack

Shoaib Amin said...


Please let me know if you’re looking for an author for your weblog.
You have some really good posts and I believe I would be a good asset.
If you ever want to take some of the load off, I’d love to
write some content for your blog in exchange for a link back to mine.
Please send me an email if interested. Thanks!
wavepad sound editor crack
unhackme crack
steinberg padshop pro crack
cyberlink powerdirector crack

Unknown said...

I know this site offers high quality content and other information,
is there any other site that presents these things qualitatively?
vmware workstation pro

Abdullah said...

I really love your blog.. Great colors & theme.
Did you develop this website yourself? Please reply
back as I’m hoping to create my own site and would love to know
where you got this from or just what the theme is named.
Thank you!
iobit start menu crack
melody sauce vst crack
serato sample vst crack
iexplorer crack
guitar pro crack
wondershare dr fone crack

Asif Raza said...


This is very attention-grabbing, You’re an overly skilled blogger.
I’ve joined your feed and look ahead to seeking more of your great post.
Additionally, I have shared your site in my social networks
magix sound forge pro crack
hide my ip
wap zap apk

Taha Rao said...

Write more, thats all I have to say. Literally, it seems as though you relied
on the video to make your point. You definitely know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something
informative to read?
avast internet security crack

werwer said...

If you've got at any time considered about laying your own personal hardwood floors yourself, it's important to cease for a moment. The problem is what a hardwood floor nailer is. Let's look at by making use of a Flooring Nailer Reviews, as you get used to it, it should make the work easy. This tool is made to take a seat on high of the tongue of the hardwood and drive the nails into it. It positions by itself so that you can not produce a miscalculation with it. This is often the one tool in existence that may be built to nail hardwood floors.
The majority of folks do not private a hardwood floor nailer, or have any concept what this tool is until you happen to be inside the design company. There are many local merchants that you simply can discover these tools for hire. In case you rent the nail gun, you can expect to also demand to hire the air compressor to operate the nail gun. Rental is from the day or through the week. You lease as reported by the size of the job you have.

werwer said...

There will be dozens of options to cook food, but today, the entire argument is as to how to receive essentially the most yummy food in significantly less number of time. This argument may very well be received by owning the best possible electric smokers at disposal. Best Electric Smokers Consumer Reports is essentially used to grill, BBQ, smoke, bake and sear food. The good factor about an electric smoker is always that the complete process of cooking silent and less messy, as there isn't a involvement of any gas, wood pellets or charcoal.
Electric smokers are widely utilized in all pieces of the earth, therefore if you are looking to acquire one, then there is absolutely no ideal time than now. But, before you move forward aided by the getting of an electric smoker, it's important that you choose to go via comments of 7 most effective electric smokers by consumer reviews

Ansari Cracks King said...

This article is indeed a satisfying article that can help new Internet users.
Who needs help with blogging?You can also visit my website. I hope to help you
draftsight crack
freemake video converter
radioboss crack
edraw max crack

sheikhdilawar said...

Excellent post. I was checking constantly this blog and I am impressed!
Extremely helpful info specifically the last part
I care for such info much. I was seeking this particular info for a very long time.
Thank you and good luck.
express vpn crack
iobit uninstaller crack
avast file server security crack
tableau desktop crack
radmin vpn crack
dvdfab crack

zain said...

Hi there it’s me, I am also visiting this web page on a regular
basis, this web site is actually good and the users are truly
sharing fastidious thoughts.
isobuster crack
datakit crossmanager
savefrom net apk

Unknown said...

Your source for fun, free mobile and PC download games. Thousands of free ... Download or play free online! ... Here is the Exact Arcade Version of Dig Dug!
blood trail vr free download

Unknown said...

Your source for fun, free mobile and PC download games. Thousands of free ... Download or play free online! ... Here is the Exact Arcade Version of Dig Dug!
need for speed no limits pc game download highly compressed

werwer said...

4K Downloader Crack will be the recognized and uncomplicated Video downloader which enables you to definitely download movies from Facebook, Metacafe, Vimeo, YouTube, and Dailymotion in addition to other 50 plus well-liked web-sites. Originally, you possess to repeat the URL of your preferred video on to your clipboard, hit “Paste URL,” and this system will problem just what it is usually that you just want to download. It supports downloading of all formats for example MP4, MKV, FLV, 3GP and also Ultra High definition video quality like 1080p, 720p and 2K, 4K films.

Jordan Leonard said...

After reviewing blog posts on your website
I really like your blog posts. I have added this to my list of my favorite sites and will see soon.
Also, feel free to visit our website and let us know what you think.
file viewer plus crack
antares autotune pro crack
bs player pro crack
little snitch crack
iobit malware fighter crack
flvto youtube downloader crack
corel draw x8 free download full version with crack

Unknown said...

Get help installing PC software on your computer, including installing software on Windows 10 devices, in this free lesson.
how to use clownfish voice changer on mobile

ahmadkanju said...

Would you be interested in exchanging links?
fullcrackedpc.com
vsthomes.com
AlterPDF Pro Crack
Nitro Pro Crack
Mirillis Action Crack
DriverMax Pro Crack

Crack Software said...

I am very impressed with your post because this post is very beneficial for me and provide a new knowledge to me
https://vstmania.net/arturia-prophet-crack/
https://installcrack.net/hot-door-cadtools-crack/
https://softwarecrack.org/asc-timetables-crack/
https://vstbank.net/origin-pro-crack/

unknown said...





it is the best website for all of us. it provides all types of software which we need. you can visit this website.
https://cracksmad.com/

vipcracks said...

The Tally ERP 9 Crack latest version of TeleERP9 Creek is very popular and smart software. Business governance decisions for more than 1 million people in 140 countries
Tally ERP 9 Crack

best crack site said...

I really appriciate your work. thanks for giving us information .keep it up. / Antivirus zap pro crack /

software cracks said...

Attractive section of content. I just stumbled upon your website and in accession capital to assert that I
acquire in fact enjoyed account your blog posts. Anyway I’ll be subscribing to your feeds and even I
achievement you access consistently fast.
Express VPN Pro Crack 10.0.92

yanmaneee said...

lebron 18
golden goose
lebron james shoes
kyrie irving shoes
off white hoodie
supreme clothing
kyrie shoes
bape outlet
yeezys
kobe shoes