Hi, I have create a database manually, follow steps here: https://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm#ADMIN11073
And my pfile didn't set value to `control_files` parameter, I comment out `control_files`
and after I succesfully create the data base and can use conn / as sysdba connect to DB,
a problem appears, that is I can only `startup nomount pfile=mypfile.ora`, but I CANNOT `startup mount pfile=mypfile`,
that is the database cannot mounted but only not mounted
Then I try to create a control file, but in this tutorial https://docs.oracle.com/html/E25494_01/control003.htm
I don't know what to write in the DATAFILE section:
-------------
CREATE CONTROLFILE
SET DATABASE prod
LOGFILE GROUP 1 ('/u01/oracle/prod/redo01_01.log',
'/u01/oracle/prod/redo01_02.log'),
GROUP 2 ('/u01/oracle/prod/redo02_01.log',
'/u01/oracle/prod/redo02_02.log'),
GROUP 3 ('/u01/oracle/prod/redo03_01.log',
'/u01/oracle/prod/redo03_02.log')
RESETLOGS
DATAFILE '/u01/oracle/prod/system01.dbf' SIZE 3M,
'/u01/oracle/prod/rbs01.dbs' SIZE 5M,
'/u01/oracle/prod/users01.dbs' SIZE 5M,
'/u01/oracle/prod/temp01.dbs' SIZE 5M
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXLOGHISTORY 400
MAXDATAFILES 200
MAXINSTANCES 6
ARCHIVELOG;
-----------
How to create control file for a new manual created databse, or make a new manual created database mounted ?