-
hi,
i gave the foll command
CREATE CONTROLFILE REUSE DATABASE FINSATI NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 50
MAXINSTANCES 1
MAXLOGHISTORY 112
datafile
'D:\Oracle\oradata\finsati\temp01.dbf' ,
'D:\Oracle\oradata\finsati\rbs01.dbf',
'D:\Oracle\oradata\finsati\indx01.dbf',
'D:\Oracle\oradata\finsati\tools01.dbf',
'D:\Oracle\oradata\finsati\dr01.dbf',
'D:\Oracle\oradata\finsati\System01.dbf',
'D:\Oracle\oradata\finsati\users01.dbf'
logfile 'D:\Oracle\oradata\finsati\redo01.log' size 1M,
'D:\Oracle\oradata\finsati\redo02.log' size 1M,
'D:\Oracle\oradata\finsati\redo03.log' size 1M resetlogs
it says control file created. now do i start the instance using
startup force
or should it be something else ? waiting for ur reply.
thanks a lot.
satish
-
There is smth wrong with your syntaxis, it should looks smth like follows
CREATE CONTROLFILE REUSE DATABASE FINSATI NORESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 50
MAXINSTANCES 1
MAXLOGHISTORY 112
datafile
'D:\Oracle\oradata\finsati\temp01.dbf' ,
'D:\Oracle\oradata\finsati\rbs01.dbf',
'D:\Oracle\oradata\finsati\indx01.dbf',
'D:\Oracle\oradata\finsati\tools01.dbf',
'D:\Oracle\oradata\finsati\dr01.dbf',
'D:\Oracle\oradata\finsati\System01.dbf',
'D:\Oracle\oradata\finsati\users01.dbf'
logfile
'D:\Oracle\oradata\finsati\redo01.log' size 1M,
'D:\Oracle\oradata\finsati\redo02.log' size 1M,
'D:\Oracle\oradata\finsati\redo03.log' size 1M;
after this is done
alter database open;
-
hi,
when i say alter database open, i get the foll error
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\FINSATI\SYSTEM01.DBF'
what do i do ?
satish
-
ops, try this although I am not sure if it would work
shutdown the database
startup mount
recover database;
alter database open;
are you in archive log or no archive log
-
hi pando,
thanks a lot. it works great. a few more questions to triuble u. i had a few tablespaces which had 2-3 more datafiles. i can add these tablespaces and datafiles now, right ? second, what diff does it make whether i am in archive or nonarchive mode ? thanks a lot for u r help. i did learn a lot today.
satish
-
hm what do you mean you have a few more files to add...? You didnt include all datafiles in your create control file statement? Well it is too late now to add because the file headers have been updated with new SCNs. You will get errors if you wanna add.
Archive log allows you to recover until point of failure (as long as you keep the archived logs)
With no archive log you can only recover until last cold backup, if your last cold backup is from 1 week ago then you would lose 1 week work.
-
hi ,
i had mentioned all the datafiles but it seems there was a datafile in d:\oracle\ora81\database. but i couldnt fond any datafile there. now in the dba studo, it is showing me that this datafile is missing but i am not getting the name of the file. just the path. whenever i am querying most of my tables, i am getting this error
ORA-00376: file 9 cannot be read at this time
ORA-01111: name for data file 9 is unknown - rename to correct file
ORA-01110: data file 9: 'D:\ORACLE\ORA81\DATABASE\MISSING00009'
what is the way out ? can i delete this datafile ?
satishpc
-
Well I think this is a bit trouble. You said most of your tables cant be queried then seems like it´s the main datafile that is missing and you said it´s not anywhere, so it was deleted accidently? If it was deleted then you will have to do a recovery, it can be a few situations, I doubt I can help remotely.
Do you have backups at all?
Your company should hire a DBA, really. Oracle is pretty complex since it offers so many options, features, and depending on situation you do a specific thing.
If the boss doesnt want to hire a DBA I would suggest using SQL Server.
-
hi pando,
thanks a lot. i guess i will manage from here onwards. actually my co. wants me to be the dba so i gues i woill have to start studying very hard. :D . i did learn a lot as this is the first time my comapny has encountered a serious database problem. earlier, they simply used to reinstall oracle and import the dump. but i guess i will have to put systems in place. for the time being my database working properly(hopefully). i will just have to import a few tables and process them.can u just tell me how to delete that datafile. right now it is offline. thanks once again. bye and have a nice time.
satishpc
-
try this
shutdown the database
startup mount
alter database datafile 'MISSINGwhatever' offline drop;
select * from v$datafile;
check the status column, see if it´s offline
alter database open;
drop tablespace XXXXX including contents;
where XXXX the tablespace that owns that datafile.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|