How to change SAP Schema name after RMAN duplicate database copy, Oracle 11g.

[Former Member]

Hi all,

We have sucessfully done RMAN  active database duplication without backup using RMAN. After that we need to change the schama name for all the object to new sap<SID>. We have ORACLE 11g.

Can somebody help us to know how to change Schema name after RMAN copy or Backup restore in Oracle 11g for SAP Database?

Thanks

Deepak

[Former Member · Accepted solution]

Hello Deepak,

As far as I remember schema change is not possible using RMAN backup/restores proceedures or for that matter any backup/restore proceedurs. If you need to change it you either need to due an export/import (using SAPinst) or else use Oracle's export/import method.

Regards.

Ruchit Khushu

[former_member182307]

Hello,

You can't change the schema name using the backup/restore procedure as far as I remember.

If you want to do this you should use the "R3load" system copy procedure which is in someway the same as an export/import.

Regards,

Steve.

[Former Member]

Hi Deepak,

As far as I know .. You can use the same schema name to connect to database. While we do system copies to QA, we never change schema names.. we keep it as like that.

Thanks,

Jagadish.