RE: Oracle instance startup issue - Please consider this as Very Urgent

RE: Oracle instance startup issue - Please consider this as Very Urgent

 

  

Thanks Aijaz,

My understanding is that I need to shutdown the source database from within
sqlplus with the command "shutdown normal", copy the required files from
source to target path, and then startup from linux using the startup pfile
command.
Please correct me if I'm wrong.

Regards,
Murali

>From: "Mir Aijaz A "
><oracledba-ezmlmshield-x75592664.[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 12:23:27 +0300
>
> praveen
>Check you your datafiles, controlfile, logfiles location.
>Set ORACLE_SID
>
>On mistake you did in the beginning only that you copied database files
>when database was up and running. You can do that but need to bring
>tablespace in backup mode.
>Since you are new to oracle I suggest you shutdown the source database
>copy all the files and so on.
>
>Keep database up and running and creating clone is tricky.
>
>Regards
>Aijaz
>
>-----Original Message-----
>From: RAMASWAMY Praveen Kumar
>[mailto:oracledba-ezmlmshield-x24804875.[Email address protected]
>Sent: Tuesday, October 30, 2007 12:05 PM
>To: LazyDBA Discussion
>Subject: RE: Oracle instance startup issue - Please consider this as
>Very Urgent
>
>Murali
>
>Is it possible for you to via RMAN?? Let me know
>
>Truly,
>Praveen
>
>
>
>-----Original Message-----
>From: Sangster Simon
>[mailto:oracledba-ezmlmshield-x5074285.[Email address protected]
>Sent: Tuesday, October 30, 2007 2:29 PM
>To: LazyDBA Discussion
>Subject: RE: Oracle instance startup issue - Please consider this as
>Very Urgent
>
>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.
>************************************************************************
>**
>
>
>---------------------------------------------------------------------
>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
>
>Confidentiality Statement:
>
>This message is intended only for the individual or entity to which it
>is addressed. It may contain privileged, confidential information which
>is exempt from disclosure under applicable laws. If you are not the
>intended recipient, please note that you are strictly prohibited from
>disseminating or distributing this information (other than to the
>intended recipient) or copying this information. If you have received
>this communication in error, please notify us immediately by return
>email.
>-----------------------------
>
>
>---------------------------------------------------------------------
>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.
>
>
>---------------------------------------------------------------------
>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