dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Redirect Restore Question - ibm-db2

This is a discussion on Redirect Restore Question - ibm-db2 ; Hello All , I have question with restore. I have a backup image say i have taken at 10:00 am in the morning. At 10:20 i have created a new tablespace. Now i wanted to do a redirect restore in ...


Home > Database Forum > Other Databases > ibm-db2 > Redirect Restore Question

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 09-08-2009, 07:40 AM
usenet
Guest
 
Posts: n/a
Default Redirect Restore Question

Hello All ,

I have question with restore.
I have a backup image say i have taken at 10:00 am in the morning.
At 10:20 i have created a new tablespace.
Now i wanted to do a redirect restore in another server using the
backup taken at 10:00 which doesnt have the new tablespace.
So what will happen during the rollforward ?
During the redirect restore i cannot set the new tablespce container
as it says "INVAILD Tablespace ".

If i remove the entry from the redirect script and restored , when
doing the rollforward to Point in time 10:30 will the tablespace be
created ? If it is created where will it create as the filesystems
which are there in the source are not present in the target .

Or
Is it necessary to have a backup immediately after the tablespace
creation ? What will happen if i dont have a backup and the database
crashes ?

Thanks in advance.
Kamal.


Thanks & Regards s,
Kamalnath.V
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 08:15 PM.