How to take backup of the SDE database and steps to export and import the database

[NCSCMNCSCM]

Hi,
In our organization, system configuration for ArcSDE 10.2.1:

Database: Oracle 11g versions:11.2.0.1
Operating System: Windows Server 2008 R2 SP1
ArcGIS for Desktop: 10.2.1

We were taking sde back-up using export command of oracle database "exp system/password file=filelocation.dmp full=y".
After this, while we were trying to import the dmp file to the test machine (with same configuration as mentioned above), the following error occurs: "Error executing stored procedure sde.pinfo_util.get_sde_idORA-06508:PL/SQL: could not find program unit being called" (kindly see the attached error message)

Before importing we were creating the user called sde with default tablespace SDE and temp tablespace, after creation of SDE user, we were using import command "imp system/password file=location fromuser=sde touser=sde"

Kindly suggest whether we were using correct syntax or else let us know the correct procedures/steps to export and import the sde geodatabase from one machine to another.

Thanks in advance

Muruganandam R
NCSCM

[NCSCMNCSCM]

ArcSDE 10.1 for Oracle 11g

Oracle database in both machine are same version too

[WilliamCraft]

So here is what I have gathered so far.  Can you please tell me if this is correct?

Production Environment
RDBMS: Oracle 11.2.0.1
ArcGIS for Desktop: 10.2.1
Geodatabase Version: 10.1

Test Environment
RDBMS: Oracle 11.2.0.1
ArcGIS for Desktop: 10.2.1
Geodatabase Version: 10.1 (it would have to be the same since you're importing from production)

From production, you export SDE schema into one or more Oracle dump files using EXP.  Then, you import the dump file(s) into your test database using IMP and no errors occur.  Is this right? 

Please note that your Geodatabase version is not necessarily the same thing as your version of ArcSDE.  For example, you could have 10.2.1 ArcSDE command line tools but still have a 10.1 SP1 geodatabase.  I just to make sure that when you said "10.1" you are referring to your Geodatabase version and not ArcSDE tools. 

[NCSCMNCSCM]

Hi Crafty,

Finally we brought our data's from rman backup, thanks for your help!!!

Regards
Muruganandam R

[AlexandrePaiva1]

So, using the RMAN fix the problem?