Home » RDBMS Server » Backup & Recovery » my database do not open
icon9.gif  my database do not open [message #196062] Tue, 03 October 2006 23:25 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: log switching in hot backup
Next Topic: database is mounted suddenly cannot open it
Goto Forum:
  


Current Time: Thu Dec 08 19:58:50 CST 2016

Total time taken to generate the page: 0.25054 seconds