copying a database from one host to another host in the same cluster

[former_member432274]

Hi, We are planning to copy an oracle database to one host(sndhpu10) to another host(sndhpu14) in the same cluster. The database is of 3TB, what is the best procedure to acquire it with less downtime?

Is it of a sap basis guy work or an oracle admins work?? if sap basis guys then?

What can a sap basis can do to aquire it to reduce the downtime .

An oracle guy tried in his manner and said it took for him 8 hours for 1.5TB of data.

What is the best process of reducing the downtime? further it goes to prod? 

regarding the boxes.

sndhpu10 is presently our database box we are running our sap test system eccxdb (database)  on it  and sndhou14 is  our new box which don't have any thing running on it it is entirely free we want to set up elxdb (database) on it. The sndhpu10 and sndhpu14 hpunix boxes are on the same cluster.

Please check the diagram I attached for easy over look?

Thanks

[Reagan]

What downtime are you talking here? downtime of the SAP production system to take an offline backup? If yes RMAN based online backups have been used for years now. If the issue is regarding the duration taken to restore the database then that should be checked with the backup/storage specialist to understand the possible options to speed up the restore.

Apart from that there are solutions like FlashCopy from IBM which lets you mirror the file systems at the OS level. This will let you synchronize the Oracle database file systems with the target server.

[former_member432274]

Hi Sunil & Reagan,

Thanks for your quick response. Yeah i heard the flash copy and SAN to SAN copy is helpful.

Is there an option of using r3load, r3tools to do this type of copy? Or i am I making this complicated using r3tools and r3load. Here my database and OS of source and target systems are same. Correct me If i am wrong. I asked my friend he said its a waste of time and resource if you do with r3tools and r3load. Best option use the flash or SAN to SAN copy.

The downtime I am talking is my source system. The DBA said the source system was down for 8hours till he finished up his half of the work. Copying database from source to destination. Is it a correct approach what he did? He copied using the oracle tool.

Can you please suggest me which one will be the best?

Thanks.

[Reagan]

R3load based system copy will require downtime of the source system. You basically export the database content to the OS level and export it to the target system. The disadvantages here are 1) downtime of the source system.  2) longer time to do the complete activity.

The advantage of using backup and restore is that there is no need to have the downtime of the source system. You just need to take a full online backup and also the backup of the offline redologs created during that time. Like I have suggested before, taking an online backup do no require system downtime. I don't know what method the DBA used to copy the database. Was he doing the manual copy of the datafiles from the source to the target using OS commands?

Cheers

RB

[former_member432274]

I really appreciate your time and support

here my dba is using oracle pump tool to copy the database from source to destination.

I mentioned the negatives if we use r3tools for the entire database to him.

he is saying "the source is in uncompressed and the target system is compressed. We can use only oracle pump tool for this procedure" is this correct? or any methods you said earlier  can be applied here?

one more que.

Can we do a full online backup and also the backup of the offline redologs created during that time and restore it to target database and Later we can compress that target system?

Thanks

[Former Member]

As you have mentioned the sndhou14 is your new system then why so worried about downtime.

You should be able to restore from the database backup of your sndhpu10 to sndhou14. There are system copy guides avaialble on marketplace please refer to the one related to your requirement.

It depends on who manage your database, if the DB team or Basis team manage then request them to restore from the backup and then perform.