oracle11g - Create DB from scratch using dump without system tablespace -


I have this scenario:

Oracle 11g with ASM

A few days ago, instead of the disk where the system's table space data files were broken and there was no way to recover them.

I had dump all the data of all owners except the system user with the "exp". Can I format all the tools and recreate asm_disksgroup and asm_disks and import my dumps? Is there any way to rebuild DB with the use of that dump without system data?

Thank you!

Yes, after you re-create the asm diskgroup, you can reload your data You can create an empty database and import expansion dumps for. Loading system while data is being loaded


Comments