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