-
Originally posted by itwizzkid
It's exactly what Iam saying. I recover all the datafiles. When I attempt to open the database, I get SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced.
I then start the db mount.. alter database open; and get ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'.
I'm going round in cycles.
Try going around in a few more cycles,
and see if it allows you to open the database.
-
Hi,
I have tried this a few times.
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\CWMLITE01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DRSYS01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\EXAMPLE01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\INDX01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\ODM01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\TOOLS01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\USERS01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\XDB01.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM120040519091720_DB.DBF'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_NTDISTRIB20040514033149_DB.DB
F'
Media recovery complete.
SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM1_INDX1.ORA'
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
-
"recover database until cancel;", help it find any archive logs that that it needs, including pointing it to the online redor logs. When you get to a point where you can't find what it wants type "cancel", and then "open database resetlogs;"
-
Final action what I can sujjest is to use _allow_resetlogs_corruption=TRUE
Do as follows
1.Shutdown the database.
2. Add the following parameter in the init.ora file:
_allow_resetlogs_corruption=TRUE
3. Startup mount;
4. Recover database using backup controlfile until cancel;
5. If prompted for a logfile, type CANCEL.
6. alter database open resetlogs;
Since the database is in Noarchive mode this is the last option.u need to be careful while using _allow_resetlogs_corruption parameter as it may make ur database inconsistent.Since as per replies u only wants ur database open so u can use this option.
-
Hi,
None of these have worked so far. I am well and truly scuppered.
-
Originally posted by itwizzkid
Hi,
None of these have worked so far. I am well and truly scuppered.
I really don't understand why you are still having problems.
Is there another DBA that can have a look at the database?
-
We have a couple of dba's on this. Every time we try to open the database we get:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
The alert log has the following entries:-
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup cont...
Wed Oct 13 05:01:28 2004
ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG'
Wed Oct 13 05:01:28 2004
Media Recovery Log E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG
Incomplete recovery applied all redo ever generated.
Recovery completed through change 14491308
Media Recovery Complete
Completed: ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADA
Wed Oct 13 05:02:38 2004
alter database open resetlogs
Wed Oct 13 05:02:38 2004
RESETLOGS after complete recovery through change 14491308
Resetting resetlogs activation ID 3724171580 (0xddfa593c)
Online log 1 of thread 1 was previously cleared
Wed Oct 13 05:02:48 2004
Online log 3 of thread 1 was previously cleared
Wed Oct 13 05:02:51 2004
Assigning activation ID 3724197347 (0xddfabde3)
Thread 1 opened at log sequence 1
Current log# 2 seq# 1 mem# 0: E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG
Successful open of redo thread 1.
Wed Oct 13 05:02:52 2004
SMON: enabling cache recovery
Wed Oct 13 05:02:52 2004
Errors in file c:\oracle\admin\train1\udump\train1_ora_2312.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists
Wed Oct 13 05:02:52 2004
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Wed Oct 13 05:02:52 2004
Errors in file c:\oracle\admin\train1\bdump\train1_pmon_2636.trc:
ORA-00704: bootstrap process failure
-
Errors in file c:\oracle\admin\train1udump\train1_ora_2312.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists
Have you looked at the "c:\oracle\admin\train1udump\train1_ora_2312.trc" file? Do you want to post it here? Is there another file that is missing? i.e. what do you think that "ORA-08103: object no longer exists" relates to?
-
Hi,
This is the train1_ora_2312.trc:-
Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
Mon Oct 11 06:25:25 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: train1
Redo thread mounted by this instance: 0
Oracle process number: 12
Windows thread id: 2312, image: ORACLE.EXE
*** SESSION ID:(9.1) 2004-10-11 06:25:25.000
(blkno = 0x8a, size = 276, max = 1, in-use = 0, last-recid= 0)
(blkno = 0x8b, size = 56, max = 145, in-use = 0, last-recid= 0)
Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
Tue Oct 12 07:28:11 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: train1
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 2312, image: ORACLE.EXE
*** SESSION ID:(9.3) 2004-10-12 07:28:11.000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 34s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
*** 2004-10-12 07:30:21.000
*** 2004-10-12 07:30:42.000
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists
Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
Tue Oct 12 07:33:11 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: train1
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 2312, image: ORACLE.EXE
*** SESSION ID:(9.3) 2004-10-12 07:33:11.000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
*** 2004-10-12 08:26:26.000
KCRA: start recovery claims for 0 data blocks
*** 2004-10-12 08:26:26.000
KCRA: buffers claimed = 0/0, eliminated = 0
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists
Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
Wed Oct 13 04:52:20 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: train1
Redo thread mounted by this instance: 0
Oracle process number: 12
Windows thread id: 2312, image: ORACLE.EXE
*** SESSION ID:(9.17) 2004-10-13 04:52:20.000
Archiving is disabled
Archiving is disabled
Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
Wed Oct 13 04:56:38 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: train1
Redo thread mounted by this instance: 0
Oracle process number: 13
Windows thread id: 2312, image: ORACLE.EXE
*** SESSION ID:(9.3) 2004-10-13 04:56:38.000
Archiving is disabled
Archiving is disabled
Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
Wed Oct 13 05:01:32 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: train1
Redo thread mounted by this instance: 1
Oracle process number: 13
Windows thread id: 2312, image: ORACLE.EXE
*** SESSION ID:(9.3) 2004-10-13 05:01:32.000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC) = 0Kb/sec => 1 blocks in 30s
Read buffer = 8192Kb (16384 blocks)
Longest record = 0Kb
Record moves = 0/1 (0%)
----------------------------------------------
*** 2004-10-13 05:02:38.000
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-08103: object no longer exists
I think that ORA-08103: object no longer exists refers to the undo tablespace.
regards
-
Ok, do a "alter batabase backup control file to trace;", while the databas eis mounted. Go find the file in the c:\oracle\admin\train1\bdump, or something like it, directory, rename it to something meaningful and post it here.
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
|