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.
- Create new database.
- Shutdown immediate;
- Change your command window to the same directory that the backups are in.
- 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;