Murali,
For cloning the database in same server
1. Decide a name for the new database
2. connect to source db with sysdba privilege
3. Execute the command "alter database backup controlfile to trace"
4. shutdown normal
5. go to user_dump_dest
6. Find one of the latest file in the folder contains create database
script
7. Rename the file to create<NEWDB>.sql
8. Edit create<NEWDB>.sql
There will be two copy of create database script, one with
resetlogs and another with noresetlogs
remove the noresetlogs script part
EDIT the following lineS appropriately
CREATE CONTROLFILE SET DATABASE "NEWDB" RESETLOGS
NOARCHIVELOG
ALTER DATABASE OPEN RESETLOGS
9. copy datafiles, logfiles to the new folder. (don't copy controlfiles)
10. Rename datafiles to newnames if required.
11. copy init<olddb>.ora init<newdb>.ora under $ORACLE_HOME/dbs
12. copy orapw<olddb> orapw<newb> under $ORACLE_HOME/dbs
13. Edit init<newdb>.ora to change file values, database name, trace
location with the new destination
14. Create udump, bdump, cdump folders in the location mentioned in the
init<newdb>.ora
13. SET ORACLE_SID=<newdb>
14. startup "/as sysdba"
15. sqlplus> @create<NEWDB>
NOW YOU ARE DONE.
ENJOY.
Suresh
-----Original Message-----
From: Murali P
[mailto:oracledba-ezmlmshield-x91073508.[Email address protected]
Sent: Tuesday, October 30, 2007 2:24 PM
To: LazyDBA Discussion
Subject: RE: Oracle instance startup issue - Please consider this as
Very Urgent
Hi Suresh,
Thanks a lot for the information.
I'm attempting to clone the database to a different name in the same
server.
Could you please shed some light on this.
Regards,
Murali
>From: "K. Suresh Kumar "
><oracledba-ezmlmshield-x39389981.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Oracle instance startup issue - Please consider this as
Very
>Urgent
>Date: Tue, 30 Oct 2007 13:45:08 +0530
>
>Hi Murali,
>
>To clone a database to another server do the following.
>
>1. shutdown the source db normally
>2. copy all the data files, control files and redo log files to the
>destination server with same directory structure.
>3. copy init<db>.ora and orapw<db> to the destination server to
>appropriate folder ($ORACLE_HOME/dbs)
>4. export ORACLE_SID=<DATABASE SID>
>5. startup the destination database
>
>For the above to work
>
>a. Same version of oracle software to be installed in the destination
>server.
>b. All required environment variable to be set properly. E.g.
> ORACLE_HOME
> LD_LIBRARY_PATH
> PATH
>
>If you want to clone the database to a different name in the same
server
>requires little more steps to be followed. Please let me know if you
>need that to be explained.
>
>Regards
>Suresh
>
>
>-----Original Message-----
>From: Murali P
>[mailto:oracledba-ezmlmshield-x58538620.[Email address protected]
>Sent: Tuesday, October 30, 2007 1:15 PM
>To: LazyDBA Discussion
>Subject: Oracle instance startup issue - Please consider this as Very
>Urgent
>
>Hello All,
>
>I'm a SQL Server DBA and new to Oracle Database administration.
>We're on Oracle 9.2 on Linux platform.
>In an attempt to clone an existing oracle database I did the following
>
>Left the source database up and running.
>Copied files (data files, redo log files, control files and
>initialization
>files) from source path to target path.
>Modified initialization parameter file (initSID.ora) to point to the
>target
>file structure.
>set ORACLE_SID successfully.
>While I startup the target instance with the command
>"startup NOMOUNT PFILE=$ORACLE_HOME/dbs/initSID.ora" I get the
following
>error:
>
>-----------------------------------------------------------------------
-
>--------------------------------------
>/u01/app/oracle/product/9.2.0
>Usage: grep [OPTION]... PATTERN [FILE]...
>Try `grep --help' for more information.
>
>SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 30 00:17:10 2007
>
>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>Connected.
>select name, log_mode, user from v$database
>*
>ERROR at line 1:
>ORA-01034: ORACLE not available
>
>SQL> SQL> SQL>
>SQL> SP2-0332: Cannot create spool file.
>SQL> ORA-07217: sltln: environment variable cannot be evaluated.
>SQL> Disconnected
>-----------------------------------------------------------------------
-
>--------------------------------------
>
>Please consider this as Very Urgent.
>Not sure where I went wrong.
>Please, please help.
>
>Thank you,
>Murali
>
>
>
>
>---------------------------------------------------------------------
>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