Technology Stack - EBS (MOSC)

MOSC Banner

Testing and validating EBS backups

edited Aug 20, 2021 11:35AM in Technology Stack - EBS (MOSC) 15 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center