Testing and validating EBS backups
Hello,
I ran daily backups using RMAN on my production EBS system, but i want to test restoring this backups, so on a TEST instance and i did the following:-
1- Asked the application administrator to insert a record to the database
2- Run a database backup using rman with the following:-
RUN {
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK MAXPIECESIZE 5G;
ALLOCATE CHANNEL CH2 DEVICE TYPE DISK MAXPIECESIZE 5G;
BACKUP FORMAT "/data/backup/db-daily/db%U.bak" AS COMPRESSED BACKUPSET DATABASE;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP FORMAT "/data/backup/db-daily/arch%U.bak" AS COMPRESSED BACKUPSET ARCHIVELOG ALL;