Trouble creating control file
Dan AOct 21 2008 — edited Oct 22 2008Hi
Just did a refresh of our DEV instance, copying datafiles from back up of Production.
I am now trying to recreate the control file with the following, but after nearly 5 hours I am running low on ideas:
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 19285
LOGFILE
GROUP 1 (
'/oradbi3/oracle/devdata/log01a.dbf',
'/oradbi3/oracle/devdata/log01b.dbf'
etc
RECOVER DATABASE USING BACKUP CONTROLFILE
ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi3/oracle/devdata/tmp04.dbf'
SIZE 2040M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi3/oracle/devdata/tmp03.dbf'
SIZE 2040M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi3/oracle/devdata/tmp02.dbf'
SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M;
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi3/oracle/devdata/tmp01.dbf'
SIZE 2000M REUSE AUTOEXTEND OFF;
The error retunred is "ORA-01507: database not mounted" .
If I change the opening lines to STARTUP MOUNT, this is returned:
ORA-00205: error in identifying controlfile, check alert log for more info
This script is supposed to be creating the control file!
If someone can see through this please let me know! Need a break.
AIX 5.2
Oracle 9.2
DA