>  Operating System
>  VMWARE
>  Installations - Apps11i
>  R12 Topics
>  Installations - Apps R12
>  Patching
>  Cloning
>  Oracle Apps Upgrades
>  System Administration - R11/R12
>  Advance Features - Oracle Apps R12
>  Want to Become an Apps DBA ?
>  Certification - Apps DBA
>  Apps Performance
>  Oracle Apps DBA Interview Questions
>  Apps Day to Day Queries

Home

Username

Password

Remember Me







Installation
RMAN - Backup & Recovery
Replication
Convert DB Character Set
DATAPUMP
Recoveries
Oracle 11g Topics
Oracle 11g DBA course

   Installation

Duplication to the same Server Using Disk Backups


Step 1. Build your auxiliary database directory structures:

mkdir /oracle/oradata/aux1
mkdir /oracle/oradata/aux1/arch
cd /oracle/admin
mkdir aux1
cd aux1
mkdir pfile dbump udump cdump
ls


Step 2. Copy the target init.ora file to the auxiliary location. if your
target database uses an spfile, you need to create a pfile from the spfile
in order capture parameters to move over
if you use an spfile at your target, enter the following

sql> connect / as sysdba
create pfile='/oracle/admin/aux1/init.ora' from spfile;

cp initprod.ora /oracle/admin/aux1/pfile/init.ora

Step 3. Make all necessary changes to your aux1 init.ora file:


db_name=aux1

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/oracle/admin/aux1/bdump
core_dump_dest=/oracle/admin/aux1/cdump
timed_statistics=TRUE
user_dump_dest=/oracle/admin/aux1/udump

###########################################
# File Configuration
###########################################
control_files=("/oracle/oradata/aux1/control01.ctl")
instance_name=aux1


db_file_name_convert=('HMDEV','aux1')
log_file_name_convert=('HMDEV','aux1')

remote_login_passwordfile=exclusive

Step 4. Build your aux1 password file


Step 5. start the aux1 instance in nomount mode:

ORACLE_SID=aux1;export ORACLE_SID
sqlplus /nolog
sql> connect / as sysdba
sql> startup nomount pfile=/oracle/admin/aux1/pfile/initaux1.ora

Step 6. Configure your network files for connection to aux1. After making any
changes to your listener.ora file, be sure that you bounce your listener, or the
change will not take effect

lsnrctl stop
lsnrctl start


tnsnames.ora

aux1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 190.2.12.113)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aux1)
)
)


listener.ora


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/920 )
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = hmdev)
(ORACLE_HOME = /oracle/product/920)
(SID_NAME = hmdev)
)
(SID_DESC =
(GLOBAL_DBNAME = aux1)
(ORACLE_HOME = /oracle/product/920)
(SID_NAME = aux1)
)
)


STep 7. From RMAN, connect to the target and auxiliary instance and run the duplicate
command

ORACLE_SID=HMDEV; export ORACLE_SID

rman

RMAN> connect target /

connected to target database: HMDEV (DBID=289711392)

RMAN> connect auxiliary sys/oracle@aux1

connected to auxiliary database: aux1 (not mounted)

RMAN> duplicate target database to aux1 pfile=/oracle/product/920/dbs/initaux1.o
ra
2> ;

Starting Duplicate Db at 04-MAY-04
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=11 devtype=DISK

printing stored script: Memory Script
{
set until scn 17929284;
set newname for datafile 1 to
"/oracle/oradata/aux1/system01.dbf";
set newname for datafile 2 to
"/oracle/oradata/aux1/undotbs01.dbf";
set newname for datafile 3 to
"/oracle/oradata/aux1/cwmlite01.dbf";
set newname for datafile 4 to
"/oracle/oradata/aux1/drsys01.dbf";
set newname for datafile 5 to
"/oracle/oradata/aux1/example01.dbf";
set newname for datafile 6 to
"/oracle/oradata/aux1/indx01.dbf";
set newname for datafile 7 to
"/oracle/oradata/aux1/odm01.dbf";
set newname for datafile 8 to
"/oracle/oradata/aux1/tools01.dbf";
set newname for datafile 9 to
"/oracle/oradata/aux1/users01.dbf";
set newname for datafile 10 to
"/oracle/oradata/aux1/xdb01.dbf";
set newname for datafile 11 to
"/oracle/oradata/aux1/T_HEALTH.dbf";
restore
check readonly
clone database
;
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

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 restore at 04-MAY-04

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/aux1/system01.dbf
restoring datafile 00002 to /oracle/oradata/aux1/undotbs01.dbf
restoring datafile 00003 to /oracle/oradata/aux1/cwmlite01.dbf
restoring datafile 00004 to /oracle/oradata/aux1/drsys01.dbf
restoring datafile 00005 to /oracle/oradata/aux1/example01.dbf
restoring datafile 00006 to /oracle/oradata/aux1/indx01.dbf
restoring datafile 00007 to /oracle/oradata/aux1/odm01.dbf
restoring datafile 00008 to /oracle/oradata/aux1/tools01.dbf
restoring datafile 00009 to /oracle/oradata/aux1/users01.dbf
restoring datafile 00010 to /oracle/oradata/aux1/xdb01.dbf
restoring datafile 00011 to /oracle/oradata/aux1/T_HEALTH.dbf
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/rman_backups/bkup_HMDEV_14_1 tag=TAG20040505T043000 params=NULL
channel ORA_AUX_DISK_1: restore complete
Finished restore at 04-MAY-04
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "aux1" RESETLOGS ARCHIVELOG

MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 ( '/oracle/oradata/aux1/redo01.log' ) SIZE 104857600 REUSE,
GROUP 2 ( '/oracle/oradata/aux1/redo02.log' ) SIZE 104857600 REUSE,
GROUP 3 ( '/oracle/oradata/aux1/redo03.log' ) SIZE 104857600 REUSE
DATAFILE
'/oracle/oradata/aux1/system01.dbf'
CHARACTER SET AL32UTF8


printing stored script: Memory Script
{
switch clone datafile all;
}
executing script: Memory Script

datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=525293003 filename=/oracle/oradata/aux1/undotbs
01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=525293003 filename=/oracle/oradata/aux1/cwmlite
01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=525293003 filename=/oracle/oradata/aux1/drsys01
.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=525293003 filename=/oracle/oradata/aux1/example
01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=525293003 filename=/oracle/oradata/aux1/indx01.
dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=525293003 filename=/oracle/oradata/aux1/odm01.d
bf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=525293003 filename=/oracle/oradata/aux1/tools01
.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=525293003 filename=/oracle/oradata/aux1/users01
.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=525293003 filename=/oracle/oradata/aux1/xdb01.d
bf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=525293003 filename=/oracle/oradata/aux1/T_HEAL
TH.dbf

printing stored script: Memory Script
{
set until scn 17929284;
recover
clone database
delete archivelog
;
}
executing script: Memory Script

executing command: SET until clause

Starting recover at 04-MAY-04
using channel ORA_AUX_DISK_1

starting media recovery

archive log thread 1 sequence 55 is already on disk as file /oracle/product/920/
dbs/arch1_55.dbf
archive log filename=/oracle/product/920/dbs/arch1_55.dbf thread=1 sequence=55
media recovery complete
Finished recover at 04-MAY-04

printing stored script: Memory Script
{
shutdown clone;
startup clone nomount pfile= '/oracle/product/920/dbs/initaux1.ora';
}
executing script: Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 139954912 bytes

Fixed Size 731872 bytes
Variable Size 121634816 bytes
Database Buffers 16777216 bytes
Redo Buffers 811008 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "aux1" RESETLOGS ARCHIVELOG

MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 ( '/oracle/oradata/aux1/redo01.log' ) SIZE 104857600 REUSE,
GROUP 2 ( '/oracle/oradata/aux1/redo02.log' ) SIZE 104857600 REUSE,
GROUP 3 ( '/oracle/oradata/aux1/redo03.log' ) SIZE 104857600 REUSE
DATAFILE
'/oracle/oradata/aux1/system01.dbf'
CHARACTER SET AL32UTF8


printing stored script: Memory Script
{
catalog clone datafilecopy "/oracle/oradata/aux1/undotbs01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/cwmlite01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/drsys01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/example01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/indx01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/odm01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/tools01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/users01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/xdb01.dbf";
catalog clone datafilecopy "/oracle/oradata/aux1/T_HEALTH.dbf";
switch clone datafile all;
}
executing script: Memory Script

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/undotbs01.dbf recid=1 stamp=52529631
9

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/cwmlite01.dbf recid=2 stamp=52529631
9

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/drsys01.dbf recid=3 stamp=525296319

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/example01.dbf recid=4 stamp=52529631
9

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/indx01.dbf recid=5 stamp=525296319

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/odm01.dbf recid=6 stamp=525296319

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/tools01.dbf recid=7 stamp=525296319

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/users01.dbf recid=8 stamp=525296320

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/xdb01.dbf recid=9 stamp=525296320

cataloged datafile copy
datafile copy filename=/oracle/oradata/aux1/T_HEALTH.dbf recid=10 stamp=52529632
0

datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=525296319 filename=/oracle/oradata/aux1/undotbs
01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=525296319 filename=/oracle/oradata/aux1/cwmlite
01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=525296319 filename=/oracle/oradata/aux1/drsys01
.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=525296319 filename=/oracle/oradata/aux1/example
01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=525296319 filename=/oracle/oradata/aux1/indx01.
dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=525296319 filename=/oracle/oradata/aux1/odm01.d
bf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=525296319 filename=/oracle/oradata/aux1/tools01
.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=525296320 filename=/oracle/oradata/aux1/users01
.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=525296320 filename=/oracle/oradata/aux1/xdb01.d
bf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=525296320 filename=/oracle/oradata/aux1/T_HEAL
TH.dbf

printing stored script: Memory Script
{
Alter clone database open resetlogs;
}
executing script: Memory Script

database opened
Finished Duplicate Db at 04-MAY-04

2nd Method
Also, refer the below article from metalink !!!

Note:186127.1
Subject: How to Create a Duplicate Database on Windows NT using RMAN


Created on 05/29/2008 08:53 PM by akr14feb
Updated on 05/29/2008 08:54 PM by akr14feb
 Printable Version

The comments are owned by the poster. We are not responsible for its content.
Discount Dallas Cowboys Jerseys
Posted on: 2012-10-05 00:36:20   By: Anonymous
 
But it would help balance things out a bit. There were also some stretching exercises that I did, and a sort of a power-walk kind of thing that I would do to stretch from side to side. And those were all things to help you extend your career.I'm slightly larger on the right side than the left side. But tennis players are the exact same way.My right side was slightly larger. You wouldn't so much notice it in my upper body, maybe a little bit in my lower body, my legs, but not nearly as much as a bowler or a tennis player.
Nike Sneakers Wholesale
Replica Hockey Jerseys
Cheap Steelers Jerseys
Reebok Jerseys Wholesale
Discount Youth NFL Jerseys

[Reply ]

Official Tennessee Titans Jerseys
Posted on: 2012-10-10 07:50:42   By: Anonymous
 
it is that elder sister Xuan to pour, connect read stage dialogues all want handwritten wall posters to remind, there is obviously no 1:00 achievement bottom, also continuously of in own body that is wrong to depend on others, if this is in Lin Feng's play set and early made her *bleep* off. Immediately after tried several times again, Sung madder was beaten several Zhangs in a row by elder sister Xuan.

NFL Throwback Jerseys Sale
Baby NFL Jerseys
Authentic Tennessee Titans Jerseys
Cheap Washington Redskins Jerseys
Blank Football Jerseys
Wholesale Stitched Jerseys
Official Tennessee Titans Jerseys
Official Washington Redskins Jerseys
NFL Jerseys Wholesale
Custom Football Jerseys
Cheap Replica Soccer Jerseys
Discount Tennessee Titans Jerseys
Discount Washington Redskins Jerseys
Toddler NFL Jerseys
Wholesale Sports Jerseys
Wholesale NFL Jerseys Cheap
Cheap Tennessee Titans Jerseys
Authentic Washington Redskins Jerseys
Cheap NFL Jerseys From China
Wholesale Authentic Jerseys
Nike Tennessee Titans Jerseys
Nike Washington Redskins Jerseys
Cheap Custom Jerseys
Authentic NFL Jerseys Wholesale
Wholesale Nike

[Reply ]

Custom Panthers jerseys
Posted on: 2012-10-18 13:28:24   By: Anonymous
 
Can hes with single mind of person, so would definitely be such. He will bathe feeling to Liu Zhi in Volume 2, also as being the dollar of the absolute being isn't original Chen Tian Long, but is Lin Yu Long in true Huan boundary birth dollar absolute being.Chen Tian Long dollar absolute staying at his this life magic weapon jade Long Pao on, just involved in the fairyland.Duration of the fairyland truly a hundredfold of true Huan boundary.
Cam Newton Jerseys
Philip Rivers Jerseys
Brian Urlacher Jerseys
Andy Dalton Jerseys
Patrick Peterson Jerseys
Tony Gonzalez Jerseys
Anquan Boldin Jerseys
Stephon Gilmore Jerseys
Luke Kuechly Jerseys
Ryan Mathews Jerseys
Julius Peppers Jerseys
A.J. Green Jerseys
Authentic Cardinals jerseys cheap

[Reply ]

Where to buy cheap hollister products?The hollister outlet online store will supply the best quality products with cheap
Posted on: 2013-03-17 07:42:36   By: Anonymous
 
Where to buy cheap hollister products?The hollister outlet online store will supply the best quality products with cheap price.When you enter hollister uk store,you can find a lot of new hollister outlet,hollister outlet uk,hollister uk,hollister uk outlet,Hollister T-Shirts,Hollister Long Sleeve T-Shirts,Hollister Polos,Hollister Hoodies,Hollister Shirts,Hollister Sweaters,Hollister Outerwear,Hollister Swim Shorts,Hollister Classic Shorts,Hollister Jeans,Hollister Sweatpants,Hollister Boxers,Hollister T-Shirts,Hollister Shirts,Hollister Fashion Tops,Hollister Tanks,Hollister Skirts,Hollister Dresses,Hollister Hoodies,Hollister Sweaters,Hollister Down Jackets,Hollister Down Vests,Hollister Sweatpants,Hollister Swimsuits,Hollister Bags,Hollister Bracelets,Hollister Flip Flops Men,Hollister Flip Flops Women sale cheap now.Both of them are brand new with original quality.
Some people live special style bags.Such as longchamp outlet,longchamp sale,Longchamp Tote,Longchamp Hobo,Longchamp Planetes,Longchamp Backpack,Longchamp Handbag Large,Longchamp Handbag Medium,Longchamp Handbag Mini,Longchamp Cosmetic Handbags,Longchamp Eiffel Tower Handbags,Longchamp Embroidered Handbags,Longchamp Greatwall Handbags,Longchamp Jacquard Handbags,Longchamp Le Pliage Cabas,Longchamp Le Pliage Large,Longchamp Le Pliage Medium,Longchamp Le Pliage Hobo Handbags,Longchamp Le Pliage Love Handbags,Longchamp Le Pliage Puzzle Handbags,Longchamp Messenger Bags,Longchamp Shoulder Bags,Longchamp Victoire,Longchamp Travel Bag,Longchamp Coin Purses and some luxury design bags.Do you love it?If you love it,please follow us to shop now.

[Reply ]

AEfNsGuJJXlcGZeBoq
Posted on: 2014-01-21 11:07:40   By: Anonymous
 
29YFQd tbaezqwkmxxy, [url=http://dbimjlvrijgk.com/]dbimjlvrijgk[/url], [link=http://crjahujeerzw.com/]crjahujeerzw[/link], http://aheuwdiafhea.com/

[Reply ]

pZZRlcTBaCZAKztyHPe
Posted on: 2014-01-21 15:26:26   By: Anonymous
 
TmGAIo mnhjtqqygvox, [url=http://nowxmkrnwpyc.com/]nowxmkrnwpyc[/url], [link=http://twofmxjdzapc.com/]twofmxjdzapc[/link], http://bgnzjqumufzd.com/

[Reply ]

IfmDqDFLIQrnI
Posted on: 2014-01-21 19:44:03   By: Anonymous
 
eRffgk ajxtpybmldpl, [url=http://ledtdphasuho.com/]ledtdphasuho[/url], [link=http://vwjnmorcilkn.com/]vwjnmorcilkn[/link], http://opykgunidgro.com/

[Reply ]

iGkioemnjNsFycWfsyj
Posted on: 2014-01-22 03:17:19   By: Anonymous
 
ChdwnF wfunrkrvvtle, [url=http://byffqbuyqlfr.com/]byffqbuyqlfr[/url], [link=http://bwvvmupcvwhu.com/]bwvvmupcvwhu[/link], http://xbfhdyzzwxrj.com/

[Reply ]

OypUIpnhqFreZnO
Posted on: 2014-01-22 07:20:24   By: Anonymous
 
rezsHK hoggdausnvam, [url=http://rgwfkxogcoun.com/]rgwfkxogcoun[/url], [link=http://podrlsmclldy.com/]podrlsmclldy[/link], http://wxaosnpcsbnk.com/

[Reply ]

oBBUJQDtBQjXMmH
Posted on: 2014-01-22 11:35:43   By: Anonymous
 
fWBrAz hxdywtpcpysx, [url=http://xfisokudipwa.com/]xfisokudipwa[/url], [link=http://bpaephiehzsa.com/]bpaephiehzsa[/link], http://dthdwwlawzth.com/

[Reply ]

yKmkFaySZtwvGDZ
Posted on: 2014-01-22 16:03:49   By: Anonymous
 
wA7bDD dpeypmdurtaw, [url=http://emdavtwhqqqx.com/]emdavtwhqqqx[/url], [link=http://wbkzhppajhsm.com/]wbkzhppajhsm[/link], http://ayciuedugwev.com/

[Reply ]

QCYkEyxnMIzM
Posted on: 2014-01-22 20:13:00   By: Anonymous
 
fyGfmc yomylyyjswse, [url=http://dbbahewfdsob.com/]dbbahewfdsob[/url], [link=http://vyrzbpummdjt.com/]vyrzbpummdjt[/link], http://xvcxcnplipon.com/

[Reply ]

ATICebNRadLUHozjJ
Posted on: 2014-01-23 00:21:47   By: Anonymous
 
xopDCw rpfkebgpfqsb, [url=http://fjvbtqoqpxze.com/]fjvbtqoqpxze[/url], [link=http://zvpymdzpyzbm.com/]zvpymdzpyzbm[/link], http://rzirdodrrgke.com/

[Reply ]

GIUgBTrdtjyIDM
Posted on: 2014-01-23 04:31:48   By: Anonymous
 
11ClxQ qkzbaulmgrzw, [url=http://omryhlbdnyzw.com/]omryhlbdnyzw[/url], [link=http://cboljzsteznt.com/]cboljzsteznt[/link], http://vyrfwltqfptg.com/

[Reply ]

KUuSeUEFHvzrol
Posted on: 2014-01-23 08:43:44   By: Anonymous
 
ZPgb17 vqxehhauffjh, [url=http://ijwnaltfwfgs.com/]ijwnaltfwfgs[/url], [link=http://qqkgggunnscp.com/]qqkgggunnscp[/link], http://abpsxnenouac.com/

[Reply ]

wernxZkytYmAyYCQDY
Posted on: 2014-01-23 13:02:58   By: Anonymous
 
8Zd6W0 ibexgpwqhcux, [url=http://owqvzkpjidjb.com/]owqvzkpjidjb[/url], [link=http://cflrzbrkqsvf.com/]cflrzbrkqsvf[/link], http://qpzehdmsgixj.com/

[Reply ]