467,073 Members | 1,263 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,073 developers. It's quick & easy.

Online Backup

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........

Jun 23 '06 #1
  • viewed: 1638
Share:
5 Replies

Gladiator wrote:
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........


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.

Jun 23 '06 #2

jdokos wrote:
Gladiator wrote:
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........


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.


Thanks for the reply....

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

Jun 23 '06 #3
"Gladiator" <vk************@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.
Jun 23 '06 #4
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.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gladiator" <vk************@gmail.com> a écrit dans le message de news:
11**********************@c74g2000cwc.googlegroups. com...

jdokos wrote:
Gladiator wrote:
> 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........


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.


Thanks for the reply....

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


Jun 23 '06 #5

Pierre Saint-Jacques wrote:
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.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gladiator" <vk************@gmail.com> a écrit dans le message de news:
11**********************@c74g2000cwc.googlegroups. com...

jdokos wrote:
Gladiator wrote:
> 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........

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.


Thanks for the reply....

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


thanks a lot every one...

regards...
kamal

Jun 26 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Arijit Chatterjee | last post: by
3 posts views Thread by Almund Sebi | last post: by
4 posts views Thread by manwiththeaxe.70@gmail.com | last post: by
10 posts views Thread by Konstantin Andreev | last post: by
4 posts views Thread by Al | last post: by
6 posts views Thread by michael.spoden@web.de | last post: by
2 posts views Thread by heyzulu59@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.