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

TABLESPACE DROP AND REDIRECT RESTORE

P: n/a
Hi Group,

I have a problem in restoring my tablespace, my database is running in
ARCHIVAL logging, I created a tablespace, did some transaction, then
took the ONLINE BACKUP of the tablespace. Then I dropped the tablespace
and tried to restore from the tablespace backup image, when I do this
it's throwing error

SQL2549N The database was not restored because either all of the table
spaces
in the backup image are inaccessible, or one or more table space names
in list
of table space names to restore are invalid.

so when I drop my tablespace, whether my containers get dropped? if
dropped how should I do the tablespace redirect command.

Thanks in advance
Vijay

Jul 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

vj_dba schrieb:
Hi Group,

I have a problem in restoring my tablespace, my database is running in
ARCHIVAL logging, I created a tablespace, did some transaction, then
took the ONLINE BACKUP of the tablespace. Then I dropped the tablespace
and tried to restore from the tablespace backup image, when I do this
it's throwing error

SQL2549N The database was not restored because either all of the table
spaces
in the backup image are inaccessible, or one or more table space names
in list
of table space names to restore are invalid.

so when I drop my tablespace, whether my containers get dropped? if
dropped how should I do the tablespace redirect command.

Thanks in advance
Vijay
A dropped tablespace can only be recovered by restoring the whole
database to a point-in-time before the tablespace was dropped. Reason
is that drop tablespace also deletes information from the system
catalog. This metadata cannot be restored through a tablespace but only
a database restore

HTH
Joachim

Jul 26 '06 #2

P: n/a
Hi Joachim,

Thanks a lot for reply, I now got the reason why I am not able to
restore my tablespace from my tablespace backup image.

Thanks
Vijay

Joachim Klassen wrote:
vj_dba schrieb:
Hi Group,

I have a problem in restoring my tablespace, my database is running in
ARCHIVAL logging, I created a tablespace, did some transaction, then
took the ONLINE BACKUP of the tablespace. Then I dropped the tablespace
and tried to restore from the tablespace backup image, when I do this
it's throwing error

SQL2549N The database was not restored because either all of the table
spaces
in the backup image are inaccessible, or one or more table space names
in list
of table space names to restore are invalid.

so when I drop my tablespace, whether my containers get dropped? if
dropped how should I do the tablespace redirect command.

Thanks in advance
Vijay

A dropped tablespace can only be recovered by restoring the whole
database to a point-in-time before the tablespace was dropped. Reason
is that drop tablespace also deletes information from the system
catalog. This metadata cannot be restored through a tablespace but only
a database restore

HTH
Joachim
Jul 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.