Home > Net >  Oracle database recovery
Oracle database recovery

Time:03-09

I was living in Ukraine, Kharkov. Now moved to another place due to war with Russian. Back there in Kharkov I had HP ProLiant server with Oracle database. Before escape city I did copy of file system to my laptop. Oracle Linux installed on laptop.

Is it possible to restore/run database instance with all my database schemas/users from that copy of filesystem?

I'm Java and PL/SQL developer. But I'm not Oracle administer, Oracle is quite complex system and it hard to run it for me from copy of filesystem.

As well, I managed to get all 4 SAS drives from server and took them with me. But I do not have a server here, I'll try to find someone who has one.

Please guide me or give some ideas what could I do to run database again. Or export and import data to new database.

CodePudding user response:

The following will work if you have the same file paths as on your original Oracle database.

  1. Create new database.
  2. Shutdown immediate;
  3. Change your command window to the same directory that the backups are in.
  4. Launch RMAN with new database as target

The following are the rman commands you will be issuing:

 startup nomount;
 restore controlfile from '<<file path to control file>>';
 shutdown immediate;
 startup mount;
 restore database;
 recover database;
 alter database open resetlogs;
  • Related