- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Need help. Standby database question. Using ...
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
тАО11-10-2003 01:55 AM
тАО11-10-2003 01:55 AM
Need help. Standby database question. Using RMAN
We have 2 box. One in Jersey and other in California. Both have 11.11 HP and ORacle 8.1.7.4. Due in company policies were have to do the following.
We have to take backup of jersey machine using RMAN and then copy it at night over to California and apply the backup using RMAN. This way it exactly the same.
Question is, can the oracle_sid on jersey and California be different?
Does RMAN cares if the ORACLE_SID are the same or not?
Thanks All
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2003 02:47 AM
тАО11-10-2003 02:47 AM
Re: Need help. Standby database question. Using RMAN
This is something you will need to test because the restore procedure is different if the instance names are different.
It would be easier for you however to have a copy of the rman respository database in both places and the instance names be the same.
It just makes the scripts easier to automate.
With enough bandwidth you could use oracle replication to keep the data hot and up to date through the wire.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2003 04:43 AM
тАО11-10-2003 04:43 AM
Re: Need help. Standby database question. Using RMAN
yes sid's can be different. however i'd would keep them same. As far as dbid is same, there shouldn't be an issue.
-
hth,
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2003 05:02 AM
тАО11-10-2003 05:02 AM
Re: Need help. Standby database question. Using RMAN
The fact that your planning to use rman for a DR solution may be an indication that your organination is offering limited funding, and may not have the bandwidthe required.
Depending on your storage hardware, there may be a 'snapshot' like package that could offer a solution. It's the cheapest way we found to mirror gigs of data over a few meg of bandwidth.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2003 09:31 PM
тАО11-10-2003 09:31 PM
Re: Need help. Standby database question. Using RMAN
Is the California DB read-only?
If so, you could use built-in functionality (in the oracle database) to keep the California DB in sync with the one in Jersey.
Have a look at "How to Create a Oracle 8i Standby Database" on Metalink, doc id: 70233.1
The main advantages with using Standby Database in Oracle is that the replication is spread out during the day, only changes are replicated and the amount of transactions lost is dependent on how often the log is switched.