Online Backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gladiator - 23 Jun 2006 13:08 GMT

Hai.....

I have a database............ i took an online
backup for tht.....
After tht mistakenly i dropped the database.......... now i dont have
the logs also....... now after i restore the database it will be in
rollforward pending state........ when i am rollforwarding it is saying
cannot rollforward........ can anyone tell me how to bring the database
back again........

Reply to this Message

jdokos - 23 Jun 2006 13:12 GMT

> Hai.....
>
[quoted text clipped - 5 lines]
> cannot rollforward........ can anyone tell me how to bring the database
> back again........

Unfortunately, an online backup requires that you rollforward to at
least a point in time right after the backup. The only other option is
to have IBM reset your log control file. This will give you access to
the data, but the database will be unsupported after that. You will
have to export, drop, recreate and import/LOAD your data.

Reply to this Message

Gladiator - 23 Jun 2006 13:25 GMT

> > Hai.....
> >
[quoted text clipped - 11 lines]
> the data, but the database will be unsupported after that. You will
> have to export, drop, recreate and import/LOAD your data.

Thanks for the reply....

Can u elaborate ur
explanation..........plssss/.................

Reply to this Message

Mark A - 23 Jun 2006 14:32 GMT

"Gladiator" <vkamalnath1237@gmail.com> wrote in message >

> Thanks for the reply....
>
> Can u elaborate ur
> explanation..........plssss/.................

Always specify INCLUDE LOGS in your online backup. It will only include the
logs that were active during the backup, but that is all you need for point
in time recovery of an online backup.

Reply to this Message

Pierre Saint-Jacques - 23 Jun 2006 19:36 GMT

For your explanation:
There is a possibility with online backup that a transaction mofifies data
"to be entered" in the backup as well as modifies a table/tablespace whose
image is already in the backup.
That's why you must be 1) in logretain=recovery and always provide access to
the logs that were active when backing up, to the db after restore for roll
forward.
As Mark specifies further, use the include logs option in your command to
stay on the safe side.
HTH, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>
>> > Hai.....
[quoted text clipped - 17 lines]
> Can u elaborate ur
> explanation..........plssss/.................

Reply to this Message

Gladiator - 26 Jun 2006 09:45 GMT

> For your explanation:
> There is a possibility with online backup that a transaction mofifies data
[quoted text clipped - 32 lines]
> > Can u elaborate ur
> > explanation..........plssss/.................

thanks a lot every one...

regards...
kamal

Reply to this Message