Suresh,
Murali has mentioned all the steps perfectly. But steps would be
Shutdown the source gracefully
Keep filesystem same at target as it is in source (life will be easy)
Copy required files using rcp
Set the environment variables at target.
And startup;
If dbname and filesystem is different from source then follow murali's
steps properly
Regards
aijaz
-----Original Message-----
From: K. Suresh Kumar
[mailto:oracledba-ezmlmshield-x86577120.[Email address protected]
Sent: Tuesday, October 30, 2007 12:46 PM
To: LazyDBA Discussion
Subject: RE: Oracle instance startup issue - Please consider this as
Very Urgent
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
---------------------------------------------------------------------
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
DISCLAIMER:
Notice : This e-mail and any attachments may contain information which is confidential to the addressee and may also be privileged. If you are not the intended recipient of this e-mail, you may not copy, forward, disclose or otherwise use it in any way whatsoever. If you have received this e-mail by mistake, please e-mail the sender by replying to this message, and deleting the original and any printout thereof.
Oracle LazyDBA home page