Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Restore Database

210 views
Skip to first unread message

Sarah

unread,
Mar 4, 2002, 4:54:30 PM3/4/02
to
Hello,

I am attempting to restore a database. Command in use is:

db2 restore database LPDB from /home/ taken at 20020221000002

Which returns:

SQL1005N The database alias "LPDB" already exists in either the local
database directory or system database directory. SQLSTATE=00000

However, when I attempt to drop the database LPDB, I am receiving:

SQL1013N The database alias name or database name "LPDB " could not be
found. SQLSTATE=42705

Any suggestions - I can't restore to a database exists, but when I attempt
to drop the database, it doesn't exist.

Thanks,
Sarah.


David Mooney

unread,
Mar 4, 2002, 5:20:50 PM3/4/02
to

Try uncataloging it instead of dropping it:

db2 uncatalog db lpdb

dave

Sarah

unread,
Mar 4, 2002, 7:56:21 PM3/4/02
to

Thanks Dave - that resolved the first issue.

I have now managed to successfully restore the database, however it is
pending rollforward.

When attempting to rollforward I receive the following:

db2 => rollforward database lpdb to end of logs
SQL4970N Roll-forward recovery on database "LPDB" cannot reach the
specified
stop point (end-of-log or point-in-time) because of missing log file(s) on
node(s) "0".

I have done a search for work arounds to this and found the following:

-----
Action: Use the ROLLFORWARD DATABASE command with the QUERY STATUS option to
determine which log files are missing.

Do one of the following:

a.. Make sure that all archive log files are available in the database log
directory or the overflow log path, and issue the ROLLFORWARD DATABASE
command again.
b.. If you cannot find the missing log files, restore the database/table
space on all nodes, then do point-in-time recovery using a timestamp that is
earlier than that of the earliest missing log file.
-----

When attempting to adjust the point in time ... I am receiving the following
error:

SQL1274N The database "LPDB" requires roll-forward recovery and the
point-in-time must be to the end of logs.

How am I able to find the date of the end of the logs ... am I taking the
wrong solution path ? Any assistance would be greatly appreciated.

Thanks.


"David Mooney" <d...@vnet.ibm.com> wrote in message
news:a60s02$11r6$1...@tornews.torolab.ibm.com...

David Mooney

unread,
Mar 5, 2002, 12:33:21 PM3/5/02
to
Sarah <sar...@lonelyplanet.com.au> wrote:
> I have now managed to successfully restore the database, however it is
> pending rollforward.
>
> When attempting to rollforward I receive the following:
>
> db2 => rollforward database lpdb to end of logs
> SQL4970N Roll-forward recovery on database "LPDB" cannot reach the
> specified
> stop point (end-of-log or point-in-time) because of missing log file(s) on
> node(s) "0".
>
> I have done a search for work arounds to this and found the following:

There is no such thing as a "workaround" for having a database in
rollforward-pending. You will have to retrieve the logs from the original
database and make them available for the rollforward command.

dave

0 new messages