Need to build new system from Exiting backup - source system

[Former Member]

Hello All,

AIX, ECC6.0 EHP4 and Oracle 11 g -> Source .

We Need to build new system from Exiting backup - source system .

What are the steps i have to do ?

I need to copy file system from Source to Target system?

Please advise .

What method we have to follow ?

[Former Member]

Hi Jone,

I assume that you are using offline backup for new system build. I this case please follow these below steps:

• Restore Oracle file system structure
• Create script to build new DB control files
• Rename the  environment file entries  for changing hostname &  SID
• Remove or rename old control files
• Build new DB control files
• OPEN DATABASE
• Check R3trans is OK
• Install License
• Post Installation Steps

BR

Rajat

[former_member188883]

Hi John,

All the above steps are good provided you have offline backup which is being restored.

In case backup is online, you may need to perform few more steps

1) Copy the redo logs from source to target

2) Create a trace file in source using "alter database backup controlfile to trace;"

3) Copy this trace file to target and modify the following

        SID, check the sapdata path, online redo log path etc

        Change the test resuse to "SET"

        Rename this trace file as control.sql

4) Start the database in mount state and execute this control.sql . It will create the new control files on target system

5) Recover database using command "recover database using backup controlfile until;

    type AUTO to start the recovery,

6) Once the recovery is complete, you can start the database using
   alter database open resetlogs

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hello All,

Thanks for the update .

Bur our requirement is we have to build a new system with exiting system backup .

We have copied below file system from Source system to target system .

Source (XXX )	Target (YYY)
/oracle/XXX1/112_64	/oracle/YYY/112_64
/oracle/client/11x_64	/oracle/client/11x_64
/sapmnt/XXX	/sapmnt/YYY
/usr/sap/XXX	/usr/sap/YYY

2, then will do backup restore .

please confirm can we bring SAP on target host if we  are following Above method ?

Please let me know what are the things we need to check after DB restore done bcoz still usr/sap/SID and /sapmnt/SID pointing source system SID and owner , group also pointing Source SID .

Please let me know .

[mmaglis]

Hi John,

From what you write (Source XXXX to Target YYYY) I understand you are trying to create a copy of the source system to a new System ID, possibly on another server. Then please follow the instructions of Homogeneous System Copy guide, using the Oracle specific database method.

Copying the files as you did will not work. Install a fresh target system and either use the existing backup during the installation (saves time) or restore the datafiles afterwards (see Deepak above).

Best regards,

Menelaos Maglis

[Reagan]

Hello

This method is possible and I have done this numerous times.

The system will work provided you recreate all the symbolic links.

There will be a lot of symbolic links in the /oracle/YYY/112_64 and also in the /usr/sap/SID/SYS locations.

You will need to adapt the environment variables, profiles, services and hosts file before you start SAP.

Regards

RB

[mmaglis]

Hi,

It may be possible, but why bother doing all this manual error-prone activity?

The procedure described in homogeneous system copy guide is simple, easy, error-free and supported by SAP.

Best regards,

Menelaos Maglis

[Reagan]

Good Day

It may be possible, but why bother doing all this manual error-prone activity?

For sure it is possible.

This is a question to be answered by the initiator of this discussion.

The reason why he is following this method is only known to him.

: You should probably start closing the threads if they are resolved and help others with the solution that worked.

I remember that two days back you were asking about a system copy using the export / import method.

http://scn.sap.com/thread/3401967

Good Luck

RB

[Former Member]

It may be possible, but why bother doing all this manual error-prone activity?

It's significantly faster compared to combined installation/system copy via sapinst.

And in the end you have to copy certain directories i.e. content of /sapmnt/SID/global accross the servers anyway.

Just don't forget to 'relink all' as ora<sid> user.

[former_member218805]

Hi Reagan,

Please note the procedure you described, even though it may technically work, it is not supported by SAP. This means if you face any issues by doing that, SAP Product support will not be able to help you.

You must always follow the procedure from the System Copy Guides, as mentioned by .

Check this link to find the relevant System Copy Guide for your specific scenario. Only the procedures described there are supported.

Best Regards,

Alessandro Parolin

[former_member206552]

hi john

as stated by benjamin, you can install the system using the backup restore option in the system copy procedure, once it asks for you to restore the database you can use rman cross system restore to resotre the database for you

http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmdupdb.htm

best regards

marius

[Reagan]

Hello

Create the file systems on the target system in the way it is created on the source system.

Install a new SAP system on the target server.

Restore the source system database from the backup.

Regards

RB

[Former Member]

Hello,

I suggest you to:

- install the targhet system as an SAP empty system (witch the export CD of the installation)

- stop SAP and Oracle on the targhet system

- delete the oracle datafile

- restore the source system in the targhet system (Oracle+brtools, or other system copy methods)

- perfom the post activity as per SAP system copy manual

Regards

Matteo Stocco