Probably best to invest in some good manuals or spend some time going
through Metalink mate - apart from anything else I'd say you need to
spend time on researching backup and recovery as well as cloning :)
Oh and welcome to the wonderful world of Oracle :D
Si
-----Original Message-----
From: Murali P
[mailto:oracledba-ezmlmshield-x91073508.[Email address protected]
Sent: 30 October 2007 08:54
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
**************************************************************************
IMPORTANT NOTICE
This e-mail may contain information that is privileged, confidential or
otherwise protected from disclosure. It must not be used by, or its contents
copied or disclosed to persons other than the intended recipient(s).
If you have received this e-mail in error, please notify us immediately at
[Email address protected] and delete this e-mail from your system.
Any liability (in negligence or otherwise) arising from any third party
acting, or refraining from acting, on any information contained in this e-mail
is excluded.
It is the responsibility of the recipient to ensure that this message and its
attachments are virus free. UAP Limited are not responsible for any reliance
placed on the information contained in this e-mail and excludes all liability.
**************************************************************************
Oracle LazyDBA home page