Has anyone restored/refreshed a database from one system to another,
applied logs and have the database available for normal use?
I'm running on an IBM AIX system and trying to restore an online/offline
database backup from one system to another. The same database name
resides on both systems (same create command). I copied all active and
archive logs to the new system along with the database dump file. The
offline database restore works fine as long as I do not try rolling
forward through the logs. Once I roll forward to the end of logs and
issue a "complete" or "stop", the tablespace where the data tables
reside is taken offline.
------------------------------------------------------------------------
-----
Here are the db2 cmds I issued on the second system. Loading an online
backup and rollforward to end of logs an complete. The tablespace is
taken offline.
>db2 restore database DCN_PRD from /dbload/online taken at
20011114090553 with 4 buffers replace existing without prompting
SQL2540W Restore is successful, however a warning "2539" was
encountered
during Database Restore while processing in No Interrupt mode.
>db2 rollforward db dcn_prd to end of logs and complete
SQL1271W Database "DCN_PRD" is recovered but one or more table spaces
are
off-line on node(s) "0".
----------------------------
tablespace that was taken offline.
Tablespace ID = 3
Name = DCNPRD_TSP1
Type = Database managed space
Contents = Any data
State = 0x0100
Detailed explanation:
Restore pending
>db2 LIST TABLESPACE CONTAINERS for 3 show detail
Tablespace Containers for Tablespace 3
Container ID = 0
Name = /dev/rdb2prd_tsp1
Type = Disk
Total pages = 130816
Useable pages = 130784
Accessible = Yes
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
