Re: Clone db 9.2 on AIX 5L

Check to your alert log for error messages. Maybe you haven't set your kernel parameters accordingly & your new instance can't allocate enough resources it needs.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 28, 2003 6:49 PM

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).