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.
2  2309 
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! =-----
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! =----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dagoberto |
last post by:
can somebody tell me how can I get old data from a recently damaged table?
|
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...
|
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...
|
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?...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
| |
