Database Reference
In-Depth Information
Restoring a Database to a New Host
In the previous several chapters, we discussed user-based backup and recovery and
RMAN-based (or server-based) backup and recovery.
When we think about restoring databases to other hosts, we might think about a number
of situations. One might be disaster recovery where we have to start from the bottom up and
where all we have are (hopefully) some backup tapes somewhere.
Other cases might involve a refresh process where new systems are being moved into your
data center and you need to move your database over to that new system. Perhaps your other
host is a development system and you just want to restore a copy of your production database
over there. There are a number of different possibilities.
There are several ways to approach this requirement, and the method you would use
really depends on what is required. If you are restoring to a bare metal machine, then you
would need to make sure that the operating system was installed, the Oracle software was
installed, and so on.
With respect to moving an Oracle database, there are many things to consider, including
the following:
■
The size of the database
■
The platform you are moving from
■
The platform you are moving to
■
How long you can take the databases down to make the move
■
Network speed
■
Disk speed
■
Impacts on other users and systems
■
And so on…
So, moving a database to a new host is not usually a simple “just do it” kind of operation.
There are different methods that can be employed to perform these database moves.
The following list provides a summary of those methods:
■
RMAN
■
Oracle Data Pump
■
Oracle GoldenGate
■
Oracle Data Guard
Of course, there is also the consideration of what to do in a complete disaster. Let's look
at these options in a bit more detail next:
Using RMAN to Move a Database
We have already discussed the
RMAN DUPLICATE DATABASE
command. If the new host is
connected to the old host via the network then RMAN duplication of a database may well
be the easiest way to restore a database to a new host.
Search WWH ::
Custom Search