- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: how to keep a disaster recovery db up to date
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 02:15 AM
тАО01-23-2003 02:15 AM
Thanks,
John.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 03:54 AM
тАО01-23-2003 03:54 AM
SolutionThere's no secret on building a standby DB.
You simple have to make a full copy of the DB and apply all archivelogs.
In my case, I apply just one time a day, but you can make a crontab entry where you copy from the other box (using ftp in batch mode) and call a script to update the DB.
I don't have the script but if you need we can make an effort to develop this to help you.
Also, if you are a Metalink user, there are a lot of information about standy DBs in there.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 03:59 AM
тАО01-23-2003 03:59 AM
Re: how to keep a disaster recovery db up to date
You are probably best to write some custom scripts. If you want to be tricky, you can get the scripts to check for assured delivery, sequence numbers, and failures within Oracle to apply redo logs.
We tried NFS but settled on gzip-ping the logs and ftping them.
The main issue with this is determining if something has gone wrong, and providing yourself (or the operators) the information needed. Sorry, can't provide my old scripts for this; previous employer has them.
Got a Storage Array in the mix? Can you use it's Replication facility (EMC = SRDF, HP = Business Copy)? Veritas does some nice incremental update software, maybe you can look at that?
Share and Enjoy! Ian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 04:36 AM
тАО01-23-2003 04:36 AM
Re: how to keep a disaster recovery db up to date
Did you find this process reasonably reliable?
John.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 04:57 AM
тАО01-23-2003 04:57 AM
Re: how to keep a disaster recovery db up to date
We are using this process to make our Disaster Recovery Plan.
We make a test every 6 months and it's completely secure.
In your case, if you make a update of archivelog, say, evey 30 minutes, in case of disaster, you have lost of data of 30 minutes (maximum).
Note that, you can make 15 minutes or less, but it depends on the speed where your archivelogs are generated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 04:57 AM
тАО01-23-2003 04:57 AM
Re: how to keep a disaster recovery db up to date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 05:54 AM
тАО01-23-2003 05:54 AM
Re: how to keep a disaster recovery db up to date
Julio, do you abtain this reliability with a scripted solution or do import logs manualy?
Does my standby database also need to be configured in archivelog mode?
Regards,
John.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2003 08:17 PM
тАО01-23-2003 08:17 PM
Re: how to keep a disaster recovery db up to date
The standby database can operate in NOARCHIVELOG mode. However, if ever you have to switch to it, you should immediate enable ARCHIVE LOG mode.
Again, remember that in 817 -- you can either deploy a managed standby where by the ARCH process delivers redo log files over the network to another system (requires enterprise edition) or you can move the archived redo log files yourself (non-managed standby).
In either case, the standby database is running in "recovery mode" -- meaning it is applying archives as they are recieved normally.
Also, note that standby database may be opened READ ONLY for queries and such in 8i. When the standby is opened read only, it is not applying archive redo log (eg: the logs are being collected but not applied).
As for "reliability with a scripted solution or do import logs manualy", i believe that it is up to you making it so. You have to ensure every thing yourself. Managed standby relieves you from this pain!
hope this helps!
Best regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 12:23 AM
тАО01-24-2003 12:23 AM
Re: how to keep a disaster recovery db up to date
It is called DataGuard, is supplied with 9i but has been packported to 8i.
We use it on 8i on all our production databases - works fine.
- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 12:26 AM
тАО01-24-2003 12:26 AM
Re: how to keep a disaster recovery db up to date
Thanks for the help everybody