Tuesday, March 15, 2011

CREATE CONTROL FILE MANUALLY ......AS YOU HAVE LOST ALL BACKUP OF IT




SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  209715200 bytes
Fixed Size                  1248164 bytes
Variable Size              79692892 bytes
Database Buffers          125829120 bytes
Redo Buffers                2945024 bytes
ORA-00205: error in identifying control file, check alert log for more info

..Above error shows that controlfile is missing.


No worry you can create the same:-)


Shut your instance..

SQL> shut immediate;
ORA-01507: database not mounted


ORACLE instance shut down.


Now, start with nomount

SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  209715200 bytes
Fixed Size                  1248164 bytes
Variable Size              79692892 bytes
Database Buffers          125829120 bytes
Redo Buffers                2945024 bytes


Create controlfile manually...

SQL> CREATE CONTROLFILE REUSE DATABASE "DBTEST" NORESETLOGS
     MAXLOGFILES 16
      MAXLOGMEMBERS 3
      MAXDATAFILES 100
      MAXINSTANCES 8
       MAXLOGHISTORY 292
   LOGFILE
  GROUP 1 'D:\oracle\product\10.2.0\oradata\dbtest\REDO01.LOG'  SIZE 50M,
  GROUP 2 'D:\oracle\product\10.2.0\oradata\dbtest\REDO02.LOG'  SIZE 50M,
  GROUP 3 'D:\oracle\product\10.2.0\oradata\dbtest\REDO03.LOG'  SIZE 50M
   DATAFILE
    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\dbtest\SYSTEM01.DBF',
    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\dbtest\UNDOTBS01.DBF',
   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\dbtest\SYSAUX01.DBF',
    'D:\ORACLE\PRODUCT\10.2.0\ORADATA\dbtest\RMAN01.DBF',
   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\dbtest\USE01.DBF',
   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\dbtest\USE02.DBF';



Control file created.

...you see now your controlfile is successfully created.


Open the database :-)


SQL> alter database open;

Database altered.


Check your data...


SQL> select count(*) from testcf;

  COUNT(*)
----------
        19

6 comments:

black archer said...

hi can u tell me if log file are lost then wahat to do

Anonymous said...

When some one searches for his vital thing, so he/she wishes to
be available that in detail, therefore that thing is maintained over here.


Check out my web-site :: what should i weigh for my height

Anonymous said...

Wow, that's what I was looking for, what a stuff! present here at this web site, thanks admin of this website.

Here is my blog post :: what should i weigh

Anonymous said...

Well, but you must know the location of previously datafiles

Zheng junxai5 said...

zhengjx20160428
kd 8
jordan retro 8
kate spade outlet
coach factory outlet online
coach outlet store online clearances
toms outlet
nfl jerseys
hollister clothing store
michael kors outlet clearance
true religion outlet
ray bans
air jordan homme
nike outlet store
ray ban outlet
burberry handbags
hollister clothing store
asics running shoes
montblanc pen
oakley canada
cheap nfl jerseys
coach outlet
michael kors outlet online
nike store outlet
coach factory outlet
nike air max 90
coach factory outlet
adidas stan smith
cheap jordan shoes
abercrombie and fitch
polo ralph lauren outlet
louis vuitton outlet stores
louis vuitton bags
louis vuitton outlet
polo ralph lauren outlet
oakley vault
cheap jerseys
gucci outlet online
coach outlet
lebron james shoes 13

raybanoutlet001 said...

ray ban sunglasses outlet
yeezy shoes
49ers jersey
rolex watches
michael kors handbags
eagles jerseys
ugg boots
nike air force 1
true religion outlet store
fitflops sale