Hi there,
Is the arquitecture diferent in the new server?. Otherwise, you can use a
homogenous system copy of your database instance for example to test new
applications, to check the database structures without affecting operation or
to set up a new standby database.
Prerequisites
Different prerequisites apply depending on the type of database instance that
you want to copy:
· Database instance type OLTP: the processor architecture of the source and
target computers have to be compatible.
· Database instance type liveCache: both the processor architectures and the
operating systems of the source and target computers have to be identical, and
the same database procedures have to be used on both computers.
Process Flow
Use the Database Manager.
1. Create a complete data backup of the original instance to a
backup medium.
2. Initialize an existing target instance, or create a new target
instance using the for recovery option.
The target instance has to be the of the same database instance type as the
original instance and use the same database software version.
¡ You are using the original parameters of the original database instance for
the target instance.
¡ In the target instance, create volumes that are large enough for importing
the data backup from the original instance.
¡ In the target instance, define a backup medium that is compatible with the
backup medium on which you created the data backup of the original instance.
3. Import the complete data backup of the original instance in the
target instance.
You can transport the data backup using pipes.
With the database manager GUI, proceed as described in Recovery Without a
Backup History.
You must not transfer the target instance to the operational state ONLINE
before you import the data backup from the original instance. If the target
instance has already been in operational state ONLINE, you have to reinitialize
the target instance.
4. Transfer the target instance to the operational state ONLINE.
5. Update the system tables in the target instance. You will need
the database system administrator and the domain users password for this.
6. If necessary, restore indices that are no longer up-to-date in
the target instance (BAD INDICES).
Eduardo Vega Torres
Projection Core Consulting Ltda.
Tel. +571-3131060
Bogotá, Colombia.
-----Mensaje original-----
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: Mié 27/07/2005 07:04 a.m.
Para: [email protected]
Asunto: copy a complete database to a different server
hello,
I'm facing the following task: we are running sapdb 7.4.3.025 with only
one database which has to be moved to a different server (on a different
computer). How could I manage this?
Is there a possibility to use a (complete) backup or do I have to write
out files with the repmcli or something like that? Is there any supporting
functionality that comes within the dbm which I hadn't seen yet?
Did anyone do the same before? Any advice welcome!
regards
Heidi Rufer
-Entwicklung-
Kern AG
Hildastr. 66
D-79102 Freiburg
Fon: +49-761-791 878-150
Fax: +49-761-791 878-9
mailto: [EMAIL PROTECTED]
http://www.kern.ag
