By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,440 Members | 1,872 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,440 IT Pros & Developers. It's quick & easy.

Damaged container...

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.