| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Clone db 9.2 on AIX 5L
Usually when I've seen that it's because of an invalid or missing password
file. Anything in the alert log to tell you more?
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----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
SQL> -- RECOVER DATABASE SQL> -- ALTER DATABASE OPEN; SQL> -- ALTER TABLESPACE TEMP ADD TEMPFILE'/iu33/u02/oradata/spap/temp01.dbf'
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: 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).Received on Tue Oct 28 2003 - 11:39:26 CST
 |
 |