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

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

 

  

Yeah, Suresh has mentioned all the steps perfectly. Thank you Suresh.
It was 4am and I couldn't work anymore so I crashed.
The problem hasn't been resolved yet. I'm starting to use the valuable
information in the system.
This is the first time I've asked a question in any forum and the response
was outstanding.
Thanks to all you wonderful people.

- Murali

>From: "K. Suresh Kumar "
><oracledba-ezmlmshield-x72447201.[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 17:27:53 +0530
>
>I hope the names Suresh and Murali interchanged.
>
>-----Original Message-----
>From: Mir Aijaz A
>[mailto:oracledba-ezmlmshield-x20276726.[Email address protected]
>Sent: Tuesday, October 30, 2007 5:18 PM
>To: LazyDBA Discussion
>Subject: RE: Oracle instance startup issue - Please consider this as
>Very Urgent
>
>
>Suresh,
>Murali has mentioned all the steps perfectly. But steps would be
>
>Shutdown the source gracefully
>Keep filesystem same at target as it is in source (life will be easy)
>Copy required files using rcp
>Set the environment variables at target.
>And startup;
>
>If dbname and filesystem is different from source then follow murali's
>steps properly
>
>Regards
> aijaz
>
>-----Original Message-----
>From: K. Suresh Kumar
>[mailto:oracledba-ezmlmshield-x86577120.[Email address protected]
>Sent: Tuesday, October 30, 2007 12:46 PM
>To: LazyDBA Discussion
>Subject: RE: Oracle instance startup issue - Please consider this as
>Very Urgent
>
>Murali,
>
>For cloning the database in same server
>
>1. Decide a name for the new database
>2. connect to source db with sysdba privilege 3. Execute the command
>"alter database backup controlfile to trace"
>4. shutdown normal
>5. go to user_dump_dest
>6. Find one of the latest file in the folder contains create database
>script 7. Rename the file to create<NEWDB>.sql 8. Edit create<NEWDB>.sql
> There will be two copy of create database script, one with
>resetlogs and another with noresetlogs
> remove the noresetlogs script part
> EDIT the following lineS appropriately
> CREATE CONTROLFILE SET DATABASE "NEWDB" RESETLOGS
>NOARCHIVELOG
> ALTER DATABASE OPEN RESETLOGS
>9. copy datafiles, logfiles to the new folder. (don't copy controlfiles)
>10. Rename datafiles to newnames if required.
>11. copy init<olddb>.ora init<newdb>.ora under $ORACLE_HOME/dbs 12. copy
>orapw<olddb> orapw<newb> under $ORACLE_HOME/dbs 13. Edit init<newdb>.ora
>to change file values, database name, trace location with the new
>destination 14. Create udump, bdump, cdump folders in the location
>mentioned in the init<newdb>.ora 13. SET ORACLE_SID=<newdb> 14. startup
>"/as sysdba"
>15. sqlplus> @create<NEWDB>
>
>NOW YOU ARE DONE.
>
>ENJOY.
>
>Suresh
>-----Original Message-----
>From: Murali P
>[mailto:oracledba-ezmlmshield-x91073508.[Email address protected]
>Sent: Tuesday, October 30, 2007 2:24 PM
>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
>
>
>
>
>---------------------------------------------------------------------
>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
>
>
>
>
>---------------------------------------------------------------------
>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