views:

29

answers:

1

Hi

I would like to backup an Oracle 10G as simple as possible. It is in NOARCHIVELOG mode and I can shut down for backup (it is only a development server).

After reading tons of documentation abour rman I tried this way in rman:

shutdown immediate;
startup mount
backup database;
sql 'alter database open';

As I see it works fine, list backup shows backups.

Than I made some modifications (droping some tables, adding data) and I tried to restore backup:

shutdown immediate;
startup mount
restore database;
recover database;
sql 'alter database open';

It also seems to work fine but I can't get back the previous state of the database. I don't understand why. I also don't understand why need to use recover.

Thanks

Hubidubi

+1  A: