Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Restore (Backup Pending)

 
   Database Help (Home) -> DB2 RSS
Next:  hardware binding  
Author Message
Richard

External


Since: Oct 02, 2008
Posts: 6



(Msg. 1) Posted: Tue Sep 28, 2010 7:50 am
Post subject: Restore (Backup Pending)
Archived from groups: comp>databases>ibm-db2 (more info?)

I've taken an offline backup from one environment and copied the file
to two other enviroments. I restored the backup in the first
environment using this command.

restore db EDW taken at 20100923215956 without rolling forward

I was able to connect to the database immediately after the restore.
Everything is fine in this environment

I then used the same restore command in the second enviroment. The
restore completed. When I went to connect to the database I got this
message.

SQL1116N A connection to or activation of database "EDW" cannot be
made because of BACKUP PENDING. SQLSTATE=57019

I didn't think this was possbile, since it's the same backup being
restored in each environment. A coworker suggested I add a "replace
existing" to the restore command. That restore is still running, so I
don't know if it has fixed the problem, but regardless, I'm confused
in knowing when to use certain restore flags to avoid issues like this
in the first place. Thx.

This is for DB2 UDB 8.2

 >> Stay informed about: Restore (Backup Pending) 
Back to top
Login to vote
Richard

External


Since: Oct 02, 2008
Posts: 6



(Msg. 2) Posted: Tue Sep 28, 2010 1:09 pm
Post subject: Re: Restore (Backup Pending) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The "replace existing" made no difference, and after reading the
manual on that flag, it was
definitely not going to fix the problem.

Anyone have any insight into the original problem?

TIA

 >> Stay informed about: Restore (Backup Pending) 
Back to top
Login to vote
stefan.albert

External


Since: Jan 31, 2008
Posts: 15



(Msg. 3) Posted: Wed Sep 29, 2010 1:47 am
Post subject: Re: Restore (Backup Pending) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Just a guess:
There was already a database named EDW on both systems.
The first was in "recovery" mode, the second not.
So for the second restore the recovery mode (of the db) was changed to
"yes" and DB2 wants a backup then.
I don't know if the db parameter exists in 8.2 - but you can try what
DB2 says:

SQL1116N A connection to or activation for database "<name>"
cannot be made because of BACKUP PENDING.

Explanation:

The specified database requires a backup to be taken to provide a
starting point for roll-forward recovery.

No connection was made.

User Response:

Back up the database by calling the BACKUP routine or, if
roll-recovery is not required, set the database configuration
parameters LOGARCHMETH1 and LOGARCHMETH2 to OFF.
 >> Stay informed about: Restore (Backup Pending) 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Question: restore from backup in relative path... - Hi there. Using 8.2 on Windows. I have a situation where I have a db backup, which I want to deploy to a group of developer workstations. The target directory for the database files will be consistent, but the location that the backup file is on may..

force rollforward pending state - In a log shipping scenario I would like to be able to test my database and set it back manually in roll forward pending state, is it possible ? What I would like to do in detail: - On the backup site: restore the main backup, rollforward the logs, ..

db2 status shows "Pending remote request" during a column .. - Hi, i'm trying to do a simple update column on a partitioned table in a 4 node partitioned database. Although the table is pretty big, it seems like its hanging on something. A list applications shows the status as "Pending remote request". An...

DB2 Image Copy &amp; Restore.. - Hi, I have a critical requirement. I did search in the forums, but still I am not clear. Here is the requirement. Our Project (ACE) has nearly 400 DB2 tables in production and Test environment. Almost all the tables are partitioned. We just upgraded t...

db2 restore database TSM - Hello All, im trying to restore a 500GB database to a target AIX server.. its actually my first time doing this..it takes me 2hours to perform a full backup..however when i try the restore, it took restore 8hours just to restore 40% of the db2..
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]