| problem on open data [message #174154] |
Fri, 26 May 2006 04:34  |
rnemkul
Messages: 35
Registered: February 2006
|
Member |
|
|
Dear all,
I have a problem on opening database
when i use to startup mannually using servicemanager
svrmgrl>startup
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HCS\SYSTEM01.DBF'
Please help what can i do for recovery my database.
Regards
Rajendra
|
|
|
|
| Re: problem on open data [message #174158 is a reply to message #174154] |
Fri, 26 May 2006 04:55  |
rnemkul
Messages: 35
Registered: February 2006
|
Member |
|
|
I am using Oracle 8i .Following are the process what i did for recover but not working
SQL*Plus: Release 8.1.7.0.0 - Production on Fri May 26 15:45:39 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Enter user-name: internal/oracle@hcs
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 224811036 bytes
Fixed Size 75804 bytes
Variable Size 77021184 bytes
Database Buffers 147636224 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\HCS\SYSTEM01.DBF'
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 224811036 bytes
Fixed Size 75804 bytes
Variable Size 77021184 bytes
Database Buffers 147636224 bytes
Redo Buffers 77824 bytes
Database mounted.
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 224811036 bytes
Fixed Size 75804 bytes
Variable Size 77021184 bytes
Database Buffers 147636224 bytes
Redo Buffers 77824 bytes
Database mounted.
SQL> alter database recover
2 ;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
What to do please guide me
Regards
Rajendra
|
|
|
|
|
|
| Re: problem on open data [message #174334 is a reply to message #174330] |
Sun, 28 May 2006 00:52 |
rnemkul
Messages: 35
Registered: February 2006
|
Member |
|
|
following error found on error log when the command "alter database recover;" used
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
WARNING! Recovering data file 5 from a fuzzy backup. It might be an online
backup taken without entering the begin backup command.
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 470 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\HCS\REDO02.LOG
Media Recovery Complete
Completed: alter database recover
When user to open database using command "alter database open;" following error found on error log
Sun May 28 11:42:23 2006
Thread 1 advanced to log sequence 471
Thread 1 opened at log sequence 471
Current log# 3 seq# 471 mem# 0: D:\ORACLE\ORADATA\HCS\REDO01.LOG
Successful open of redo thread 1.
Sun May 28 11:42:23 2006
SMON: enabling cache recovery
SMON: enabling tx recovery
Sun May 28 11:42:24 2006
Errors in file d:\oracle\admin\hcs\bdump\hcsSMON.TRC:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
SMON: terminating instance due to error 600
Instance terminated by SMON, pid = 756
Please give me suggestion.
Regards
Rajendra
|
|
|
|
| Re: problem on open data [message #174876 is a reply to message #174154] |
Tue, 30 May 2006 21:21 |
itman73
Messages: 6
Registered: May 2006
Location: Dallas, Texas, USA
|
Junior Member |
|
|
Did you replace datafile(s) with backup copies?
How were the backup copies made? This message is not a good sign: WARNING! Recovering data file 1 from a fuzzy backup. It might be an online backup taken without entering the begin backup command.
User managed backups must include the alter tablespace tablespace_name begin backup; command before copying the associated datafiles to disk or tape media, followed by an alter tablespace tablespace_name end backup; command. This begin/end backup is repeated for each tablespace.
Has your recovery process/backup files ever been tested before, either in development or in production?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
