Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01219: database not open: queries allowed on fixed tables/views only

823860Feb 5 2011 — edited Feb 5 2011
Dear All

I am working in Oracle database 10G using O.S (window xp). and i have 2 database and both were working fine, but i took physical backup of my server machine

do the fellowing sreps.

1- shutdown immediate

2-take the followinf file
---------------------------------
1- C:\Oracle\product\10.2.0\oradata\abc (complete folder)
2- C:\Oracle\product\10.2.0\admin\abc\pfile (take onle pfile)
3- i- F:\ORADATA\a1.dbf ( 6 table Spaces)
ii- F:\ORADATA\a2.dbf
iii- F:\ORADATA\a3.dbf
iv- F:\ORADATA\a4.dbf
v- F:\ORADATA\a5.dbf
vi- F:\ORADATA\a6.dbf

3- startup mount
4- alter database open
5- i got message my database alter successfully

but after some time, when i connect my abc database sys/****@abc as sysdba via toad then i got message

ORA-01219: database not open: queries allowed on fixed tables/views only

and if i connect another user under abc database then i got below message

ERROR: ORA-01033: ORACLE initialization or shutdown in progress

i had search solution on OTN and find some queries:

Firstly i check my database state:
1- select open_mode from v$database;
OPEN_MODE
----------
MOUNTED

then i put other queries

2- recover database until cancel;
Media recovery complete.

3- alter database open resetlogs;

database open successfully.

and i got login with other user and even can work in sys user normally.
but when i system shutdown and again restart then my abc database open in Mount state.
My default database working still fine.
any help, will be appreciated.
Thanks in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2011
Added on Feb 5 2011
19 comments
3,942 views