Hi,
I have 11g installed on my Windows 10 PC and I am starting to work with RMAN. I am having trouble getting a basic backup and restore to work correctly. Hopefully someone can help me out as I think it may be something obvious.
I have a table called BACKUPTEST which contains three integers (10, 20 and 30) which has been committed to the database XE. The database is in ARCHIVELOG mode at the moment. I have connected to RMAN and used the following commands to backup the database.
connect / as target;
connected to target database: XE (DBID=2932141296)
using target database control file instead of recovery catalog
shutdown immediate;
startup mount;
backup database;
All of these run successfully and I can see files have been created in the C:\ drive for the backup. I have then deleted all the entries from the BACKUPTEST table and committed those changes using the system account. I then use the following commands to restore the database.
connect / as target;
connected to target database: XE (DBID=2932141296)
using target database control file instead of recovery catalog
shutdown immediate;
startup mount;
restore database;
recover database;
alter database open resetlogs;
After this, I query the BACKUPTEST table but the backup has not restored the table content. It is still empty after my delete statement earlier. Am I missing anything obvious? Has the backup actually ran and I need to do something else as well? Any help greatly appreciated.