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
>
>
Oracle LazyDBA home page