473,324 Members | 2,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Damaged container...

On Linux, suppose a recoverable database has crashed due to a damaged
tablespace (the container on which the tablespace existed has gone
bad). On restarting the database, I understand that the tablespace
will be in roll forward pending state. Because the container has gone
bad, I cannot 'fix' the container. So, what are my options? Can I
restore the 'tablespace' to some other good container and then roll
forward to the end of logs? What is the command for that? I mean, how
do I specify the path for the new container on the Restore command?

TIA
Raquel.
Nov 12 '05 #1
2 2301
Ian
Raquel wrote:
On Linux, suppose a recoverable database has crashed due to a damaged
tablespace (the container on which the tablespace existed has gone
bad). On restarting the database, I understand that the tablespace
will be in roll forward pending state. Because the container has gone
bad, I cannot 'fix' the container. So, what are my options? Can I
restore the 'tablespace' to some other good container and then roll
forward to the end of logs? What is the command for that? I mean, how
do I specify the path for the new container on the Restore command?

TIA
Raquel.


That's a redirected restore. See the data recovery book for syntax and
the procedure to do this.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2
Ian
Raquel wrote:
On Linux, suppose a recoverable database has crashed due to a damaged
tablespace (the container on which the tablespace existed has gone
bad). On restarting the database, I understand that the tablespace
will be in roll forward pending state. Because the container has gone
bad, I cannot 'fix' the container. So, what are my options? Can I
restore the 'tablespace' to some other good container and then roll
forward to the end of logs? What is the command for that? I mean, how
do I specify the path for the new container on the Restore command?

TIA
Raquel.


That's a redirected restore. See the data recovery book for syntax and
the procedure to do this.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dagoberto | last post by:
can somebody tell me how can I get old data from a recently damaged table?
0
by: Raquel | last post by:
On Linux, suppose a recoverable database has crashed due to a damaged tablespace (the container on which the tablespace existed has gone bad). On restarting the database, I understand that the...
2
by: XXX | last post by:
Hi, I've got a problem with a damaged access 2000 database. When I try to repair and compact the database, the process starts normaly, but then (after appr. 50 %) it hangs. Neither is it...
0
by: maniac | last post by:
Gang: "There was an error opening this document. The file is damaged and could not be repaired." Has anybody had issue with not being able to open pdf in any browser using ..net application?...
1
by: lauralucas | last post by:
I'm starting to suspect something is damaged in my working environment. (asp.net 1.1 and visual studio 2003) for example: is this normal? I add a label I assign the label a value of "hello" in...
1
by: MrWriteLA | last post by:
I've been trying to code a fairly uncomplicated program that will read some values from an Excel worksheet into Illustrator variables. I tried VBA first, being careful to add the Illustrator...
1
by: =?Utf-8?B?UnVzc2VsbA==?= | last post by:
Some sage tech told me, in an online discussion on how to keep my computer clean and working smoothly, that it was ok to delete all of the "downloaded program files" that reside in that internet...
4
by: muthu | last post by:
Hi, User will upload only picture and pdf files. I have return a asp.net application for that,But thing is I need to restrict the user uploading corrupted or damaged files. Can anyone have any...
3
by: olle | last post by:
How to deal with a VBA-project that is damaged? Hi everyone. I am BigOlle from sweden and I have been working with Accees for ten years I am now working on a project that started in Access97...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.