- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- one of the datafile was accidently deleted...datab...
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
тАО07-03-2002 07:36 AM
тАО07-03-2002 07:36 AM
one of the datafile was accidently deleted...database won't start
oerr ora 01157
157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
*Cause: The background process was either unable to find one of the
files or failed to lock it because the file was already in us
The database will prohibit access to this file but other file
be unaffected. However the first instance to open the databas
need to access all online data files. Accompanying error from
operating system describes why the file could not be identifi
*Action: Have operating system make file available to database. Then
open the database or do ALTER SYSTEM CHECK DATAFILES.
cd /tablespace_rollback
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 07:45 AM
тАО07-03-2002 07:45 AM
Re: one of the datafile was accidently deleted...database won't start
How you proceed will depend upon which file and if you are able to recover it....
If you can't recover it, you may be able to mount, offline the tablespace, and open without it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 07:49 AM
тАО07-03-2002 07:49 AM
Re: one of the datafile was accidently deleted...database won't start
OK - first do you know which specific file is missing? Have you verfied that it is gone? Do you have a backup? yes...that file is no longer
in my directory...i have check on the o/s level... and no, i didn't have back up for this...this file is part of the tablespace for rollback
How you proceed will depend upon which file and if you are able to recover it....
If you can't recover it, you may be able to mount, offline the tablespace, and open without it.
*** hi....i can't do either of that..can't take
the tablespace offline because it is not open...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 08:01 AM
тАО07-03-2002 08:01 AM
Re: one of the datafile was accidently deleted...database won't start
1) create a new (empty) datafile to replace the one you lost.
2) mount, but do not open the database
3) do a "recover datafile xyz;"
Are you running in archive log mode? If so, do you have the archived log files?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2002 12:11 PM
тАО07-03-2002 12:11 PM
Re: one of the datafile was accidently deleted...database won't start
If you don't have this documentation you go to technet.oracle.com.
Finally, if you have a support contract I would recommend calling Oracle support and they will walk you through the recovery process.