Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Rollforward without log files

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-01-04, 12:02
toby25 toby25 is offline
Registered User
  
Join Date: Sep 2003
Posts: 63
Rollforward without log files
Hi,

This is ver 8.1 on aix 5.2

We have production and standby server. We have full offline bkp on weekend that we apply at standby server. The database on standby is always on rollforward pending state. How do I take it out of rollforward state and make it online without logfiles. I do not need the standby database to be up to the minute with production server. Just need to bring it online without having any logfiles after applying restore of the offline bkp from prodution.

I do not want to use without rolling forward option during restore on standby server as it must be in rollforward pending state all the time. It needs to be online only when needed. So is there any way to bring it online without logfiles from prod.

Thanks in advance,
toby
Reply With Quote
  #2 (permalink)  
Old 10-01-04, 17:04
dbamota dbamota is offline
Registered User
  
Join Date: Sep 2003
Posts: 237
When you restore the db, did you use "without rolling forward" phrase. If not you can give the command
db2 rollforward db dbalias complete
which should take it out of rollforward pending state
__________________
mota
Reply With Quote
  #3 (permalink)  
Old 10-05-04, 16:34
toby25 toby25 is offline
Registered User
  
Join Date: Sep 2003
Posts: 63
Thanks for the reply. I did not restore DR server with 'without rolling forward' as thats the requrement. DR server is not supposed to be online unless needed.

I gave 'db2 rollforward db DBNAME complete' command .
But it didnt work. it gave me error
SQL0276N Connection to database "DBNAME" cannot be made because it is in
the restore pending state. SQLSTATE=08004

Any suggestions how i can bring this database online after restoring full offline backup.

Thanks
toby
Reply With Quote
  #4 (permalink)  
Old 10-06-04, 12:13
dbamota dbamota is offline
Registered User
  
Join Date: Sep 2003
Posts: 237
I'm afraid you have to 'restore without rolling forward' again; I expected the db state to be 'ROLLFORWARD PENDING' at best. Are you doing a redirected restore? ie change the names of the containers in standby from prod?
__________________
mota
Reply With Quote
  #5 (permalink)  
Old 10-07-04, 13:58
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
To my understanding, you cannot use 'WITHOUT ROLLING FORWARD' for a online backup ... If that is allowed, the database may be left in an inconsistent state ..


In V8.2, you have the option to include logs in the backup image .. So, you will not have the problem of 'missing' log files

Cheers
Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #6 (permalink)  
Old 10-15-04, 14:09
chavadb2 chavadb2 is offline
Registered User
  
Join Date: Aug 2004
Posts: 138
did u try?

db2 "rollforward database [dbname] stop"

it shud work even if u don't have logfiles available
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.