- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Trying to duplicate production box
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-01-2001 11:57 AM
тАО11-01-2001 11:57 AM
I have been trying to duplicate our production database box from scratch. I did the OS install, Oracle install, etc. I have a few hangups with copying the datafiles and duplicating the Oracle instance. What I would rather do is backup our production box and restore the tapes to our dev box.
Our setup:
K460 w/AutoRaid, Oracle 8.1.6/WebDB 2.2, production box
K460 4-4GB drives, identical memory/cpu config
My plan was to backup vg00 using make_tape_recovery. Then use fbackup to copy everything else.
One of the questions I have is how to restore the files to the dev box that does not have AutoRAID. As long as I have the mount points would Oracle care what volume groups the files/data are on?
I think it doesn't, but being new to unix and Oracle my brain has stopped working because of overload. I have been reading these forums for 4+ months now, but I'm still expanding my knowledge.
Thanks,
Tim
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2001 12:02 PM
тАО11-01-2001 12:02 PM
SolutionClay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2001 12:09 PM
тАО11-01-2001 12:09 PM
Re: Trying to duplicate production box
Sounds good.
<
It does not matter whether
you have Autoraid or not,
as long as the disk space
is available to restore
the data. Performance will
not be the same as in Production, but i think that
is not a concern.
<
If the db is a filesystem
only db, it should not matter
at all.
If the Db has raw volumes,
then you would need to
get the DBA to change the
datafile links to the new lv
names within the database. OR you have the choice
of creating links to the newLV with the old LV which
is sort of messy.
-raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2001 01:05 PM
тАО11-01-2001 01:05 PM
Re: Trying to duplicate production box
Is it OK to just shutdown Oracle before backing up the program and datafiles? Or should I reboot to single user before running fbackup? That is assuming I have all the file systems mounted.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2001 01:17 PM
тАО11-01-2001 01:17 PM
Re: Trying to duplicate production box
Shutting down Oracle should be adequate.
One of the nice features of 'fbackup' is that it notes the modification timestamp of a file when it starts to back it up. Once the file has been copied to tape, the timestamp is compared to the one when the copy started. If they differ, the tape copy is marked "bad" and the copy is retried from disk. This will occur up to and including
Now, obviously, you want inter-consistency among tables and indices, so you *still* don't want your database up in and inuse during copies of any of its structures. Shutting down Oracle should be enough.
Regards!
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2001 01:21 PM
тАО11-01-2001 01:21 PM
Re: Trying to duplicate production box
Yes, you would definitely
need to Shutdown oracle, whenever you are taking it''s
copy/backup !!
Since this is a Filesystem only Database, you have saved
yourself some pain ;-)
-R