 my database do not open [message #196062] |
Tue, 03 October 2006 23:25  |
farnaw4u
Messages: 22
Registered: October 2006
Location: pakistan
|
Junior Member |
|
|
hi all
when i open my db it returned following message.i dont have any
backup .
plz help me
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup mount
ORACLE instance started.
Total System Global Area 84121628 bytes
Fixed Size 75804 bytes
Variable Size 57024512 bytes
Database Buffers 26943488 bytes
Redo Buffers 77824 bytes
Database mounted.
SVRMGR> alter database open
2> ;
alter database open
*
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: 'D:\DATA\MAINMTR01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile
thanks in advance
farnaw
|
|
|
|
| Re: my database do not open [message #196157 is a reply to message #196062] |
Wed, 04 October 2006 06:19  |
pareshr
Messages: 18
Registered: August 2006
Location: Ahmedabad
|
Junior Member |
|
|
Hi,
Make datafile offline using following command. And then try to open your database.
ALTER DATABASE DATAFILE 'D:\DATA\MAINMTR01.DBF' OFFLINE;
|
|
|
|
| Re: my database do not open [message #196329 is a reply to message #196062] |
Thu, 05 October 2006 00:53 |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 130023424 bytes
Fixed Size 787788 bytes
Variable Size 99351220 bytes
Database Buffers 29360128 bytes
Redo Buffers 524288 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\SYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile
( if u don't have any bkp then just create new control file )
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 130023424 bytes
Fixed Size 787788 bytes
Variable Size 99351220 bytes
Database Buffers 29360128 bytes
Redo Buffers 524288 bytes
SQL> ed
Wrote file afiedt.buf
1 CREATE CONTROLFILE REUSE DATABASE "taj" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 10
5 MAXINSTANCES 1
6 MAXLOGHISTORY 113
7 LOGFILE
8 GROUP 1 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\REDO01.LOG' SIZE 10M,
9 GROUP 2 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\REDO02.LOG' SIZE 10M,
10 GROUP 3
11 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\REDO03.LOG' SIZE 10M
12 DATAFILE
13 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\SYSTEM01.DBF' size 450m,
14 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\USERS01.DBF' size 229120k, 'D:\ORAC
LE\PRODUCT\10.1.0\ORADATA\TAJ\Undotbs01.DBF' size 25600k, 'D:\ORACLE\PRODUCT\1
0.1.0\ORADATA\TAJ\sysaux01.DBF' size 276480k
15* CHARACTER SET WE8MSWIN1252
SQL> /
Control file created.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 44
Next log sequence to archive 44
Current log sequence 46
SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select status , instance_name from v$instance;
STATUS INSTANCE_NAME
------------ ----------------
OPEN taj
SQL>
hope this helps
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
