tag:blogger.com,1999:blog-53781634127692661462024-02-08T05:39:26.382-08:00santoshkalyan@oracle rac dbaAnonymoushttp://www.blogger.com/profile/08720348452979971376noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5378163412769266146.post-77167495584844566292012-11-04T09:40:00.001-08:002012-11-04T09:40:43.413-08:00Database Cloning<div dir="ltr" style="text-align: left;" trbidi="on">
Database Cloning can be done in two ways: 1. With Rman. 2. Without Rman.<br />
<br />
Database Cloning through Rman is easy and efficient way for performing Cloning.<br />
<br />
Steps for Database Cloning using Rman:<br />
<br />
Note: Before performing the operation make sure u have know the following:<br />
<br />
Target Database Name, Duplicate Database Name(which u want to set), catalog database name,<br />
tnsnames for Target Database and the catalog.<br />
<br />
Step 1. Set the Environment Variable for Duplicate Database.<br />
<br />
$export ORACLE_SID=DUPDB.<br />
<br />
Step 2. Create an init.ora file for duplicate database.<br />
<br />
Step 3. Bring the duplicate database to nomount state using the above created init.ora file.<br />
<br />
$ echo $ORACLE_SID<br />
<br />
$ sqlplus '/as sysdba'<br />
<br />
sql> startup nomount<br />
<br />
Step 4. Connect to Rman.<br />
<br />
$ rman target=system/password@targetdb catalog=rman/password@catalog auxiliary /<br />
<br />
step 5. Run the command.<br />
<br />
rman> run{<br />
allocate auxiliary channel aux1 device type disk;<br />
duplicate target database to DUPDP;<br />
}<br />
<br />
This will create a Duplicate Database for your Target Database using RMAN.<br />
<br />
<br />
<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/08720348452979971376noreply@blogger.com0tag:blogger.com,1999:blog-5378163412769266146.post-84902899078574831832012-11-03T12:05:00.003-07:002012-11-03T12:05:44.888-07:00hi frnds.. i am now in blogspot.in as santoshkalyan.tatablogspot.in<div dir="ltr" style="text-align: left;" trbidi="on">
<br /></div>
Anonymoushttp://www.blogger.com/profile/08720348452979971376noreply@blogger.com4