First of all I'll say I'm using:
- Oracle Database 11g Express Edition
- Oracle SQL developer
What I'm trying to achieve
Create a backup and restore it, so for example I can delete a table after a backup and then restore the backup to recover that table.
What I tried step by step
First I entered to RMAN and used the following statements
connect target; shutdown immediate; startup mount; configure controlfile autobackup on; backup database;
So for now I'm connected to the database and it's only mounted, and the backup has finished correctly. You have above what I got after executing the backup.
As you can see I don't have now tables because I deleted the only I had (before the backup I had the table "regions" of the HR schema so that's inside the backup I guess).
After all of this I close the connections in sql developer, because I don't know if it's going to create errors, but I want to avoid them.
Now I want to start trying recovering the backup and I execute this because I read that both for backing up and restoring, you must leave the database in the "mount state", so I go to RMAN and execute only this now:
shutdown immediate; startup mount;
And now in this step the real recovery, I execute this:
Now I should execute the following but it's returning this error:
alter database open;
So, I execute this instead:
alter database open resetlogs;
And no, it's not there.