TABLESPACE DROP AND REDIRECT RESTORE

[vj_dba]

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

[Joachim Klassen]

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

[vj_dba]

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