Monday 21 April 2014

Import Oracle 11gR2 backup (specific users) to Oracle 10gR2

Import Oracle 11gR2 backup (specific users) to Oracle 10gR2 

1. Export full database backup

exp /@SID full=y file=/home/oracle/stelar.dmp STATISTICS=NONE

2. Drop specific user which need to import

DROP USER ATMUTL CASCADE;
DROP USER BACH CASCADE;
DROP USER BACHINT CASCADE;
DROP USER BNSUSER CASCADE;
DROP USER FIUINT CASCADE;
DROP USER ISLBAS CASCADE;
DROP USER ISLIMG CASCADE;
DROP USER ISLITS CASCADE;
DROP USER ISLSYS CASCADE;
DROP USER MYBANK CASCADE;
DROP USER ORBBBR CASCADE;
DROP USER ORBITS CASCADE;
DROP USER SBLMIS CASCADE;
DROP USER SMSGTWAY CASCADE;
DROP USER STFOREX CASCADE;
DROP USER STLBAS CASCADE;
DROP USER STLIMG CASCADE;
DROP USER STLSYS CASCADE;
DROP USER WEBADMIN CASCADE;

3. Unrar backup rar file

unrar e Stelar_31102013.rar

4. Import specific database users

imp user/passwd file=/back/export_backup/Stelar_Thu.DMP fromuser=MYBANK,STLSYS,ORBITS,BACH,BACHINT,ORBBBR,FIUINT,ISLBAS,SMSGTWAY,ISLITS,ISLIMG,WEBADMIN,BNSUSER,STLBAS,ATMUTL,STLIMG,STFOREX,ISLSYS,SBLMIS touser=MYBANK,STLSYS,ORBITS,BACH,BACHINT,ORBBBR,FIUINT,ISLBAS,SMSGTWAY,ISLITS,ISLIMG,WEBADMIN,BNSUSER,STLBAS,ATMUTL,STLIMG,STFOREX,ISLSYS,SBLMIS

2 comments:

  1. Does it requird "version" keyword ?

    ReplyDelete
    Replies
    1. Thanks Utpal da for your question...

      Actually i have tested the above steps in my lab and its work fine for me..

      Delete