Hi Chad,
If you want create a new database by copying existing database
( Usually call cloneing a database)
You can follow the following procedure.
1. Source instance ( alter database backup controlfile to trace )
SQL> alter database backup controlfile to trace
2 /
Database altered.
cle/udump
2. Get the trace file from $ORACLE_HOME/admin/<SID>udump or
get the user_dump_desc parameter by the following command
SQL> show parameter user_dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string /ora01/prod/proddb/9.2.0/admin
/PROD_hpora
3. The trace file will look like
Dump file /ora01/prod/proddb/9.2.0/admin/PROD_hporacle/udump/prod_ora_23514.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
4. Modify the trace file , get the STARTUP_NOMOUNT till ....... ALTER DATABASE OPEN
and save as a new file CREATE_TARGET_CONTROLFILE.sql
And change the following
4.1 Database Name
CREATE CONTROLFILE REUSE DATABASE "PROD" NORESETLOGS ARCHIVELOG
=> Change as : CREATE CONTROLFILE SET DATABASE "TARGET_INSTANCE_Name" NORESETLOGS ARCHIVELOG
4.2 And change datafile/logfile path/filename to target datafile/logfile path
5. Create TARGET_INSTANCE controlfile using the step 4 script .
6. You can find more information on the step 3's trace file.
Regards
Wilson Shen
DBA of KLASER Technology Inc.
@ SIP, Hsinchu , TAIWAN
-----Original Message-----
From: jeff7055010802
[mailto:oracledba-ezmlmshield-x2314393.[Email address protected]
Sent: Monday, April 30, 2007 12:11 PM
To: LazyDBA Discussion
Subject: RE: Database Creation
HOW?
-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x56593072.[Email address protected]
Sent: Thursday, February 22, 2007 2:50 AM
To: LazyDBA Discussion
Subject: Re: Database Creation
Many ways. Depends on if you want the data (rows) or not...
>>> "Chad GARRISON "
<oracledba-ezmlmshield-x78686894.[Email address protected] 2/21/2007
12:02 PM >>>
Is there a way to create a new database by coping an existing
database?
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page