I have been trying to update a test database with new data. I have watched multiple videos on this process and read different help articles, but I don't know what I'm doing wrong.
Backup Process on live servers:
RUN {
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
ALTER SYSTEM SWITCH LOGFILE;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
BACKUP INCREMENTAL LEVEL 0 DATABASE FORMAT 'D:\\fast\_recovery\_area\\CPCONV\\BACKUPSET\\8-01-2024\_Full\_4571442681'
CURRENT CONTROLFILE FORMAT 'D:\\fast\_recovery\_area\\CPCONV\\CONTROL\\8-01-2024\_4571442681';
delete force archivelog all completed before 'sysdate-7';
CROSSCHECK BACKUP;
DELETE NOPROMPT BACKUP COMPLETED BEFORE 'SYSDATE-7';
DELETE NOPROMPT OBSOLETE;
}
Once the backup is completed, I copy the entire fast_recovery_area folder to the test server. Once the copy is done I do the following.
Restore Process:
STARTUP NOMOUNT;
RESTORE CONTROLFILE FROM "D:\fast_recovery_area\CPCONV\CONTROL\8-01-2024_8583335815";
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
From what I have seen, there are no errors throughout this process. I have also confirmed backups are in the right spots with LIST BACKUP;
The database starts and can be used without issue. The issue is that the data is still a year old.
Let me know if any further information is needed.