- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: missing data file
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 03:20 AM
тАО05-21-2002 03:20 AM
This database is used by ITO.
The tape that would have had that file on is long gone as this server has not been used in a while.
Is there a way of clearing out all of the ito alerts that are in the database so i can start from scratch?
os hpux 11
oracle ver 8.0.6
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 11447272 bytes
Fixed Size 52200 bytes
Variable Size 6811648 bytes
Database Buffers 4505600 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '/u01/oradata/openviewd/OPC_1_1.dbf
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 03:31 AM
тАО05-21-2002 03:31 AM
Re: missing data file
svrmgrl>shutdown
svrmgrl>recover database;
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 03:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 04:06 AM
тАО05-21-2002 04:06 AM
Re: missing data file
Any ideas?
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [29360198], [1], [5035], [305
2], [32], [],
Cheers
George
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 04:51 AM
тАО05-21-2002 04:51 AM
Re: missing data file
You can open the database
by starting the database,bringing the datafile offline and opening the database.
I am not sure what that particular datafile contains.Might be some useful information for OV.
Let's try this
svrmgrl>startup mount
svrmgrl>alter database datafile 'datafile-name' offline
svrmgrl>alter database open;
Then we will try restoring that speific datafile
svrmgrl>alter database recover datafile 'datafile-name'
svrmgrl>alter database datafile 'datafile-name' online
Just post the log.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 04:59 AM
тАО05-21-2002 04:59 AM
Re: missing data file
I do have a couple of old backup tapes with the file on but that all.
Maybe i might have to reintstall the database.
Ta
George
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 05:04 AM
тАО05-21-2002 05:04 AM
Re: missing data file
If that specific datafile is corrupt we can drop it and re-create it.
First try opening your database making that datafile offline.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 05:06 AM
тАО05-21-2002 05:06 AM
Re: missing data file
I found a SAP note for an ORA-600[3020]
The solution states to start over the recovery from scratch and since you have no tapes, I guess there will be no luck for you.
I think you will need to reinstall the application.
Sorry
Volker
------------------------
During database recovery, an ORA-600 [3020] occurs and the recovery process stops.
Oracle writes a change phasor for every modification of a data block to the Online redo log file. To synchronize the change phasors with several modifications, a change number (version number) is incremented for every block.
If you now try to import a change with the number 453 during the recovery when the block in fact has the version number 451, the recovery stops with ORA-600 [3020] since it assumes that one or more changes are
missing.
The error can be caused by hardware problems and affects both redo log files and database files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 05:52 AM
тАО05-21-2002 05:52 AM
Re: missing data file
Never mind i'm learning lots more than i did about oracle Thanx T G :)
Dont worry Volker if worst comes to worst i'll hit it with a big hammer then reinstall but at least i get to play in the meantime.
Cheers
George
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2002 06:20 AM
тАО05-21-2002 06:20 AM
Re: missing data file
Also post your alert.log file for your recovery.
Thanks
G Manikandan