By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,044 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

Online Backup

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a

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

P: n/a

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

P: n/a
"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

P: n/a
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

P: n/a

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.