- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Mirroring production data onto reporting data
Operating System - HP-UX
1753689
Members
5107
Online
108799
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- 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
тАО09-05-2002 12:03 PM
тАО09-05-2002 12:03 PM
Application needs a reporting tool that needs to access same structure of production database ( they are working on a data warehouse model, but that will take time ).
So, for now, we will implement oracle or some 3rd party replication OR, the easiest right now, Business Copy for the XP ( SAN ). Business copy will mirror the database files into a different set of disks that can be mounted on another system for reporting purposes, thus, taking the load off the production box.
question.
how do I bring up the mirrored database up so that there is no confusion to which database it is being accessed, since the global instance name will be the same ? Or, can I simply setup two different global instance names based upon two different init.ora files ? Or public links ? Anyone has done this in the past ?
thanks,
Henrique Silva
"to be or not to be, what was the question ???? "
Solved! Go to Solution.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2002 01:06 PM
тАО09-05-2002 01:06 PM
Re: Mirroring production data onto reporting data
Hello Henrique,
We do something like that here. I'm not an Oracle DBA, but the way I understand it is that on the reporting side you would use a different oracle home, with an init.ora file that gives the mirrored copy a different instance name. We have a test/development system where we update the database every couple of weeks with a copy of the production side. I split off the copy and mount it up on the test system, and our DBAs run some scripts and make it come up with a different instance name.
JP
We do something like that here. I'm not an Oracle DBA, but the way I understand it is that on the reporting side you would use a different oracle home, with an init.ora file that gives the mirrored copy a different instance name. We have a test/development system where we update the database every couple of weeks with a copy of the production side. I split off the copy and mount it up on the test system, and our DBAs run some scripts and make it come up with a different instance name.
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2002 10:46 PM
тАО09-05-2002 10:46 PM
Solution
Henrique
This is something we do here every day - we use a business copy (similar to a mirror split) on our XP to generate 2 or 3 copies of the production database for data mining, testing etc.
To make thos work we use a couple of tricks.
On the prod database, before the split, invoke (from SQL or svrmgrl) "alter database backup control file to trace".
This produces, in the user_dump_dest directory, an ascii dump of the control file.
Then we use some scripts to edit this file to reflect the file system after the split. The key here is that the first line of the file becomes
"CREATE CONTROLFILE REUSE SET DATABASE "" RESETLOGS NOARCHIVELOG".
Then you can start up the copy database using the modified create control file sstatement (you then need to do "ALTER DATABASE OPEN RESETLOGS") and away you go.
BTW - don't forget to update the GLOBAL_NAME table.
This is something we do here every day - we use a business copy (similar to a mirror split) on our XP to generate 2 or 3 copies of the production database for data mining, testing etc.
To make thos work we use a couple of tricks.
On the prod database, before the split, invoke (from SQL or svrmgrl) "alter database backup control file to trace".
This produces, in the user_dump_dest directory, an ascii dump of the control file.
Then we use some scripts to edit this file to reflect the file system after the split. The key here is that the first line of the file becomes
"CREATE CONTROLFILE REUSE SET DATABASE "
Then you can start up the copy database using the modified create control file sstatement (you then need to do "ALTER DATABASE OPEN RESETLOGS") and away you go.
BTW - don't forget to update the GLOBAL_NAME table.
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-06-2002 04:15 AM
тАО09-06-2002 04:15 AM
Re: Mirroring production data onto reporting data
Thanks guys.
so, by doing getting the trace file and doing the reuse database and reset logs, you can basically change the instance name ? I was under the impression that with oracle, there were two things you could not do once the database had been created. Change its name and change the block size !!!
I will try it out !!!
thanks a lot
Henrique Silva
so, by doing getting the trace file and doing the reuse database and reset logs, you can basically change the instance name ? I was under the impression that with oracle, there were two things you could not do once the database had been created. Change its name and change the block size !!!
I will try it out !!!
thanks a lot
Henrique Silva
"to be or not to be, what was the question ???? "
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP