Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trouble creating control file

Dan AOct 21 2008 — edited Oct 22 2008
Hi
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2008
Added on Oct 21 2008
17 comments
1,303 views