Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Clone db 9.2 on AIX 5L

RE: Clone db 9.2 on AIX 5L

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 28 Oct 2003 09:29:25 -0800
Message-ID: <F001.005D4D1E.20031028092925@fatcity.com> 





This is how ours look like ...



STARTUP NOMOUNT



CREATE CONTROLFILE REUSE DATABASE "XXX" NORESETLOGS  ARCHIVELOG



--  SET STANDBY TO MAXIMIZE PERFORMANCE




    MAXLOGFILES 192



    MAXLOGMEMBERS 3



    MAXDATAFILES 1024



    MAXINSTANCES 32



    MAXLOGHISTORY 3403



LOGFILE



..



maybe it is that pfile line causing trouble ...
Raj




Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !




-----Original Message-----



Sent: Tuesday, October 28, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L




SQL> @cr_spap


SQL> STARTUP NOMOUNT



pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora
ORA-03113: end-of-file on communication channel
SQL> CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG

2 MAXLOGFILES 50



3 MAXLOGMEMBERS 5



4 MAXDATAFILES 100



5 MAXINSTANCES 1



6 MAXLOGHISTORY 226



7 LOGFILE



8 GROUP 1 '/iu33/u02/oradata/spap/redo01.log' SIZE 100M,
9 GROUP 2 '/iu33/u02/oradata/spap/redo02.log' SIZE 100M,
10 GROUP 3 '/iu33/u02/oradata/spap/redo03.log' SIZE 100M
11 DATAFILE


12 '/iu33/u02/oradata/spap/system01.dbf',
13 '/iu33/u02/oradata/spap/undotbs01.dbf',
14 '/iu33/u02/oradata/spap/drsys01.dbf',
15 '/iu33/u02/oradata/spap/example01.dbf',
16 '/iu33/u02/oradata/spap/odm01.dbf',
17 '/iu33/u02/oradata/spap/tools01.dbf',
18 '/iu33/u02/oradata/spap/users01.dbf',
19 '/iu33/u02/oradata/spap/xdb01.dbf',
20 '/iu33/u02/oradata/spap/users02.dbf',
21 '/iu33/u02/oradata/spap/users03.dbf',
22 '/iu33/u02/oradata/spap/users04.dbf',
23 '/iu33/u02/oradata/spap/users05.dbf',
24 '/iu33/u02/oradata/spap/indexes01.dbf',
25 '/iu33/u02/oradata/spap/indexes02.dbf',
26 '/iu33/u02/oradata/spap/indexes03.dbf'


27 CHARACTER SET WE8ISO8859P1



28 ;


CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG

*


ERROR at line 1:


ORA-03114: not connected to ORACLE

SQL> -- RECOVER DATABASE
SQL> -- ALTER DATABASE OPEN;
SQL> -- ALTER TABLESPACE TEMP ADD TEMPFILE


'/iu33/u02/oradata/spap/temp01.dbf'


SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ;

SQL>


The confusing thing is that I have instances already running on the machine.
So I know the install is ok.  I can start/shutdown the existing instances no
problem.  But when I try to clone and startup --- I get the results from
above.


-----Original Message-----



Sent: Monday, October 27, 2003 5:24 PM


To: jblake_at_arrow.com




When are you getting the error?  During startup?



Adam






"John Blake" <jblake_at_arrow.com>


Sent by: ml-errors_at_fatcity.com


10/27/2003 03:04 PM


Please respond to


ORACLE-L_at_fatcity.com




To


Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc



Subject


RE: Clone db 9.2 on AIX 5L








Sorry,


AIX 5L to AIX 5L


cold backup copies


create backup controlfile to trace -- edited for the new file locations
keeping the SID the same



created init.ora from spfile


startup nomount pfile=<init.ora>


getting  ora-3113



I have a TAR opened and figured I would check out here as well.





-----Original Message-----



adamdonahue_at_maximus.com


Sent: Monday, October 27, 2003 4:44 PM


To: Multiple recipients of list ORACLE-L




How about some more details?  Are you cloning to a similar platform?  Are
you using a cold backup with controlfile recreation?  RMAN backup or
restore?  RMAN duplicate?  ...



Adam






"John Blake" <jblake_at_arrow.com>


Sent by: ml-errors_at_fatcity.com


10/27/2003 02:24 PM


Please respond to


ORACLE-L_at_fatcity.com




To


Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc



Subject


Clone db 9.2 on AIX 5L








Just checking to see if anyone has been able to clone a 9.2 DB from one
machine to another.  I have never had a problem doing this prior to 9.2,
and am just wondering if I have overlooked something peculiar to 9i.
Thanks in adavance


John



--



Please see the official ORACLE-L FAQ: http://www.orafaq.net


--



Author:


  INET: adamdonahue_at_maximus.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--



Please see the official ORACLE-L FAQ: http://www.orafaq.net


--



Author: John Blake


  INET: jblake_at_arrow.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: John Blake


  INET: jblake_at_arrow.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

**************************************************************************************4




-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: Jamadagni, Rajendra


  INET: Rajendra.Jamadagni_at_espn.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Oct 28 2003 - 11:29:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US