467,925 Members | 1,812 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,925 developers. It's quick & easy.

TABLESPACE DROP AND REDIRECT RESTORE

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
  • viewed: 4917
Share:
2 Replies

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
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.

Similar topics

2 posts views Thread by Patrick Tan | last post: by
8 posts views Thread by Amy DBA | last post: by
7 posts views Thread by CCC via DBMonster.com | last post: by
4 posts views Thread by Joachim Klassen | last post: by
1 post views Thread by Sam Durai | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.