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 > Regarding backup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-15-10, 07:56
ashwinjoshi ashwinjoshi is offline
Registered User
 
Join Date: Oct 2010
Posts: 18
Regarding backup

I have 2 full backups and i want to restore one of the backup into another new database when i issue the following command

[db2inst1@abdulkalam ~]$ db2 restore database visilog taken at <VISILOG.0.db2inst1.NODE0000.CATN0000.201011151810 23.001> into test

I am getting following error into file called 'into'..

[db2inst1@abdulkalam ~]$ cat into
SQL2508N The Database Restore timestamp parameter "test" is not valid.
[db2inst1@abdulkalam ~]$

Please suggest me for correct command
Reply With Quote
  #2 (permalink)  
Old 11-15-10, 08:09
nvk@vhv nvk@vhv is offline
Registered User
 
Join Date: Jan 2010
Posts: 294
Ouch!

db2 restore database visilog taken at 20101115181023 into test
Reply With Quote
  #3 (permalink)  
Old 11-15-10, 09:16
ashwinjoshi ashwinjoshi is offline
Registered User
 
Join Date: Oct 2010
Posts: 18
Thanks a bunch... it worked.

And one more doubt, Can I take the incremental backup of 'A' database and restore into 'B' database( In new database I have full backup of 'A' database)...

If such... Can U please tell me the command...
Reply With Quote
  #4 (permalink)  
Old 11-15-10, 09:38
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
yes you can. I would suggest downloading manual as it will answer all of these questions for you w/o a wait.
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #5 (permalink)  
Old 11-15-10, 09:39
nvk@vhv nvk@vhv is offline
Registered User
 
Join Date: Jan 2010
Posts: 294
Yes, it's possible. It's in the documentation:
Using incremental restore in a test and production environment
Reply With Quote
  #6 (permalink)  
Old 11-17-10, 11:03
ashwinjoshi ashwinjoshi is offline
Registered User
 
Join Date: Oct 2010
Posts: 18
Thanks alot... It worked.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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