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

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

 

  

No Praveen,

This task came all of a sudden with a critical deadline and that's why I
didn't get a chance to read through any manual. That's why I'm asking.
I haven't used RMAN before. Also, I don't see any other Admin tool (like
Enterprise Manager) to do this.
Any help is appreciated.

Regards,
Sai

>From: "RAMASWAMY Praveen Kumar "
><oracledba-ezmlmshield-x24804875.[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 14:35:03 +0530
>
>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
>
>



Oracle LazyDBA home page