backup on standby

pts.
Tags:
SQL
Hi, We have a DR site about 1000km away from our primary site, so full backups of the databases can' be shipped on WAN (size @ 13gb). Hence I want to take backup on standby server. We have configured log shipping. Is it possible to stop log shipping for some time, open standby database in normal mode, take a backup, again make it standby & start log shipping. Please advice on the situation.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The Standby database can only be opened in ReadOnly mode – if you want to be able to put it BACK into Standby mode. You can do the backup then, or you can shut it down altogether and perform a cold backup if you prefer and if time permits. I still do all my HotStandbys manually, but I’m sure you can either pause the application of logs, or just let them pile up until the backup is done. At which point it will apply them in bulk.

You can also look into Oracle Streams, which I believe is a no cost option. It also does log based replication, but this way the 2nd database would be UP all the time. You might even choose to use it to offload work by using it for reporting or something.

I hope this helps!

(MrO)

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following