Oracle-L: RE: Clone db 9.2 on AIX 5L

From: Bellow, Bambi <bbellow_at_chi.navtech.com>
Date: Tue, 28 Oct 2003 11:44:29 -0800
Message-ID: <F001.005D4D3D.20031028114429@fatcity.com>

Are you sure that init.ora has the same database name as the controlfile?

Bambi.
-----Original Message-----

Blake
Sent: Wednesday, October 29, 2003 3: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

--

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

--

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

--

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

Author: Pete Sharman
INET: peter.sharman_at_oracle.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: Bellow, Bambi
INET: bbellow_at_chi.navtech.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