Oracle dump import into newly created db

[Former Member]

Hello

We had problem to restore an SAP Oracle
Database(had no offline arcive logs). So according » http://oracleracdba1.wordpress.com/2012/11/27/ora-01195-online-backup-of-file-1-needs-more-recovery-...«
we started 

We exported the content of database via this
way

SQL> create or replace directory OL1_DUMP
as '/oracle/OL1/sapdata1/OL1_DUMP';

Directory created.

SQL>

Dumping of db was then run this way

server:oraol1 56>  expdp
sys/sys@OL1 full=Y directory=OL1_DUMP dumpfile=OL1.dmp logfile=expdpOL1.log
compression=METADATA_ONLY

Now I guess I should drop the db and
create the new one. How to do that? Has anyone some script to be run on
sqlplus?

Then import should run like this?

“server:oraol1 56>  impdp sys/sys@OL1 full=Y directory=OL1_DUMP dumpfile=OL1.dmp logfile=expdpOL1.log compression=METADATA_ONLY

The structure of existing db is a little
different as the new ones. Eg. tablespaces are PSAPOL1, PSAPTEMP, PSAPOL146C,
PSAPOL1700, PSAPOL1USR, PSAPUNDU, SYSAUX, SYSTEM

Thank you in advance

Jan

[stefan_koehler]

Hi Jan,

why do you want to export the content via expdp in such cases?

You already got the (consistency) corruptions, if you have opened the database with "_ALLOW_RESETLOGS_CORRUPTION". An export and import will not fix this.

> How to do that? Has anyone some script to be run onsqlplus?

I would use the corresponding SAPinst procedure and install a new database and exchange the SAP schema data with the exported data. However the database creation scripts are already on your database server. Here is the manual procedure:

http://docs.oracle.com/cd/E11882_01/server.112/e25494/create003.htm

You need to specify all the settings like character set, tablespaces, etc. on your own if you do it that way.

Regards

Stefan