Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Recovering a failed database copy
Fellow DBA's
System is 8.0.6 on Compaq Tru64 40f
Normally my database copies go smoothly, without incident. However this
time the rollback parameter on the target system did not match the rollback
segment that existed in the source database. The create controlfile script
ran successfully to rename the database, but when I tryed to "alter database
open resetlogs;" I got a ORA-1534 rollback segment does not exist. After
correcting the init file and trying this command again I get a ORA-1139
(resetlogs is now invalid option). Trying to open the database without the
resetlogs option generates a ORA-600 error. ls -l shows that all datafile
have a current datestamp.
Is there anyway to recover from this without starting the file copy (a 15-18hr process) all over again.
Thanks,
Mike Hand
Polaroid Corp
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: HANDM_at_polaroid.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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-LReceived on Mon Feb 12 2001 - 08:54:11 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).