473,473 Members | 1,604 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

replicating a database

We are migrating from SCO with 8i to SuSe SLES 8 with 9iR2 on our
Compaq i586 backup server "BKUP". This has already been done on our
development server "DEV" and production server "PROD". The RDBMS and
database on DEV, BKUP, and PROD are all named the same and stored
within one (~48Gb) filesystem. Besides the HOST name in listener.ora,
I am not aware of any other differences between the RDBMS or databases
on these servers.

Last week, due to the loss of two hard drives and our ARCserve tape
backup catalog, DEV was completely restored from a backup tape. After
recovering DEV's database, it appears to function correctly.

To migrate BKUP, we are first going to install the OS. I am then
considering "creating" BKUP's RDBMS and database by restoring the
Oracle filesystem from a PROD backup tape. I am also considering
recommending this as our database recreation method in certain(?)
scenarios.

Though this method seems efficient and successful, I entreat the
expertise of this group's members to point out any problems or issues
with it. Any comments are greatly appreciated.
Jul 19 '05 #1
0 1526

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Nathan Simpson | last post by:
Hi, We have one domain with a mixture of NT PDC's one Win2K DC (which was the first installed) and 4 Windows 2003 DC's. I created our sites as per MS documentation and created the subnets that...
0
by: Brian E. Seppanen | last post by:
I have a large number of tables in a database, and I'm looking at replicating only 5 of those 4000+ tables to about 5-7 other hosts. The primary server runs 4.0.15 and would replicate to 3.23...
0
by: nwiebe | last post by:
Hi, does anyone know how to avoid replicating delete statements? I have a table in a source database. This table is pruned occasionally. I'd like to have a copy of this table in a second...
3
by: jodyblau | last post by:
I'm fairly new to access, so I hope this question isn't too elementary. I'm putting together a database for my office. I want the database to be accessible to 5 or 6 users on our network and so...
0
by: ceadtinneh | last post by:
We're running merge replication between to SQL Server 2000 servers. The application isn't very high volume the setup is pretty vanilla (ie no filters, etc). We have a push subscription set up...
5
by: Radek | last post by:
Hi I'm in need of creating reporting database. What I have to do it is to replicate only half of tables to next database so reports could query only that second database. Unfortunately there is...
4
by: Imicola | last post by:
Hi, I recently got an external hard drive to backup all my files. The easiest way it seems to synchronise between my desktop computer and the backup files on the external hard drive is to use...
1
by: war_wheelan | last post by:
I am replicating an 80GB database between NY can CT and would like to know why table sizes are different between the two. Here is an example of sp_spaceused:: NY IOI_2007_04_23 ...
16
by: aswath | last post by:
hi dere, i have a question. i have an array with replicating values.... al i want to do is delete all replicating values and store the result in another array. eg., String a={1,2,3,3}; String...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.