I'm running Oracle 8.1.5 on Solaris platform. I was just testing out some recovery scenarios. I deleted my control files and tried to re-create it using the backup control file. My database was running in archivelog mode and was shutdown normal before deleting my control files. I'm getting the foll. error. Could u pls help me out..?
1. Startup nomount
2. CREATE CONTROLFILE REUSE DATABASE "VTEST" NORESETLOGS ARCHIVELOG
GROUP 1 '/dbase1/u14/oradata/vtest/logs/log1.dbf' SIZE 1M,
GROUP 2 '/dbase1/u14/oradata/vtest/logs/log2.dbf' SIZE 1M
CHARACTER SET WE8DEC
After running the script , I'm getting the foll. error :-
CREATE CONTROLFILE REUSE DATABASE "VTEST" NORESETLOGS ARCHIVELOG
ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : '/dbase1/u14/oradata/vtest/data/system.dbf'
Could u pls help me sort out this problem. No changes've been made to any of the files.
Does '/dbase1/u14/oradata/vtest/data/system.dbf' exist?
Do you have the correct permission on '/dbase1/u14/oradata/vtest/data/system.dbf' ?
Check the path, permitions on SYSTEM.mdf
Sorry Guys..!! The problem was b'coz of using a different init.ora. I had just given startup nomount instead of the foll.
Startup nomount pfile=initvtest.ora.
Since, this is a test database, my init file was not in the ORACLE_HOME directory.
Thanx for the help though..!!