- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: DROP Rollback Segment 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
тАО01-30-2003 06:47 AM
тАО01-30-2003 06:47 AM
DROP Rollback Segment file
it's an Oracle question : I drop unfornetly a file of a rollback segment tablespace and don't have backup. I shutdowned the database and try to open it but i have this error :
ORA-01157: cannot identify data file 2 - file not found
ORA-01110: data
file2: '/dev/ORADEV/rbs/rbs01.dbf'
can i open my databse without this file and recreate a rollback after ?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 07:07 AM
тАО01-30-2003 07:07 AM
Re: DROP Rollback Segment file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 03:58 PM
тАО01-30-2003 03:58 PM
Re: DROP Rollback Segment file
startup mount
alter database datafile
'/dev/ORADEV/rbs/rbs01.dbf' offline drop;
alter database open;
- For each rollback segment:
drop rollback segment
- or -
drop tablespace rbs including contents;
Once complete, recreate the tablespace.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 05:08 PM
тАО01-30-2003 05:08 PM
Re: DROP Rollback Segment file
to recovery from loast of a rbs datafile is not so simple.
So I'm sending you an attachment file, with two possibilities.
If you have some difficulties, let me know.
Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 07:46 PM
тАО01-30-2003 07:46 PM
Re: DROP Rollback Segment file
Remove the rollback segment names from the init
Now the database will open.Then you can create a new rollback tablespace and then drop the lost file tablespace.
you can also do this
$ORACLE_SID=
$export ORACLE_SID
$svrmgrl
connect internal
svrmgr>startup mount
svrmgr>alter database datafile '/dev/ORADEV/rbs/rbs01.dbf' offline drop
svrmgr>alter database open
create tablespace
like
create tablespace rollback datafile '
create rollback segment roll1 tablespace rollback online;
select segment_name,tablespace_name,status from dba_rollback_segs;
select name,TS# from v$tablespace;
select name from v$datafile where TS#='0';
check whether the datafile that was missing is in the list
select segment_name,tablespace_name,status from dba_rollback_segs where tablespace_name='
alter rollback segment
drop tablespace
(the tablespace which had the lost file)
Also make sure that you update the init
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2003 07:48 PM
тАО01-30-2003 07:48 PM
Re: DROP Rollback Segment file
After you recover your database kindly recover the no.of points assigned for your questions.
It too requires some recovery