How to restore/recovery to the LAST BACKUP no rollforward?
Hello all,
I borrow a test server to do function test on my code. When done, I need to put the database back to its original state.
I might need to run my backup script (more than once) to roll back the database during testing..
So, I did a full backup in NOARCHIVELOG mode, for example:
BACKUP FORMAT '$BACKUP_DIR/df_%u' FILESPERSET 999999 DATABASE;
Here is my restore script using point-in-time recovery:
connect target /
run
{
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALLOCATE CHANNEL c1 TYPE DISK;
# Doing the Incomplete Media Recovery with Time-Based Recovery
# Set the point-in-time to JUST AFTER the BACKUP
I borrow a test server to do function test on my code. When done, I need to put the database back to its original state.
I might need to run my backup script (more than once) to roll back the database during testing..
So, I did a full backup in NOARCHIVELOG mode, for example:
BACKUP FORMAT '$BACKUP_DIR/df_%u' FILESPERSET 999999 DATABASE;
Here is my restore script using point-in-time recovery:
connect target /
run
{
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALLOCATE CHANNEL c1 TYPE DISK;
# Doing the Incomplete Media Recovery with Time-Based Recovery
# Set the point-in-time to JUST AFTER the BACKUP
0