cancel
Showing results for 
Search instead for 
Did you mean: 

system copy process

Former Member
0 Kudos

Dear Experts,

I am doing a homogenious system copy on ECC6 on windows plateform for STANDBY DATABASE .

I am some queries

1. I have taken the offline backup in sapbackup folder on source system ( backup taken on hard disk )

2. I have installed OS on target system .

3. Now I am installing Database oracle 10g on target system .

My query is

I will configure this system as a standy database for disaster recovery

1. in the starting of oracle installation , it is asking to give DATABASE SID

Is the SAP SID , database sid , schema should be same if we use the system as standby database ?

2. I have copied the sapbackup folder from source to target system .

It will ask to restore the backup in the mid of installation .

what will be the step by step process to restore offline backup from DISK.

pl. suggest.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member227283
Active Contributor
0 Kudos

Hi Thomas,

1. in the starting of oracle installation , it is asking to give DATABASE SID 
Is the SAP SID , database sid , schema should be same if we use the system as standby database ?

Yes, if you are creating standby database then you have to keep the database same.

It will ask to restore the backup in the mid of installation .

1. You have the install oracle and sap with with SID on target system with SAP's default database.

2. Restore the backup using brtools or by manually copy the file to sapdata location.

3. Create the standby control file.

4. Apply archive the keep database in mount stage.

5. Apply archive to standby on regular basis.

Thanks

Anil

Former Member
0 Kudos

you mean to say

1. You have the install oracle and sap with with SID on target system with SAP's default database.

Fresh installation of sap on standby database server *not* system refresh . Is it ?

I was trying to make system refresh to create standby database server ( DR server ) . It is not required . am i right ?

2. Restore the backup using brtools or by manually copy the file to sapdata location.

After fresh installation of SAP , I have to restore the backup of primary server to standby server . Is it ?

3. Create the standby control file.

How ?

4. Apply archive the keep database in mount stage.

5. Apply archive to standby on regular basis.

You mean to say , i have to configure data guard for point 3 , 4 and 5 .

Pl. correct me

Former Member
0 Kudos

>>Fresh installation of sap on standby database server not system refresh . Is it ?

You need to have a basic installation of SAP and Database software. If you install SAP and database on DR system then this will allow you to bring the database online with SAP and can be used as production in case of disaster or emergency. DR has to be sync with production.

>>I was trying to make system refresh to create standby database server ( DR server ) . It is not required . am i right ?

You have to create a standby database using a system copy of your production system.

>>After fresh installation of SAP , I have to restore the backup of primary server to standby server . Is it ?

Yes, you need to restore the production database on DR database using brtools or copy the online/offline backup to DR system.

3. Create the standby control file.

4. Apply archive the keep database in mount stage.

5. Apply archive to standby on regular basis.

>>You mean to say , i have to configure data guard for point 3 , 4 and 5 .

Yes you need to configure dataguard for DR sync. all these steps are already documented.