Database Backup and Recovery (MOSC)

MOSC Banner

Archival database for long-term backups

edited Nov 15, 2019 8:46AM in Database Backup and Recovery (MOSC) 6 commentsAnswered

Hi,

I'm in the midst of process to setup archival backup for 5 years retention period.

Plan to using daily backup script and tagging as a 5 years backup.

DB version : 12c Enterprise Edition Release 12.1.0.2.0

connect target /

run {

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/vol_name/15yr/%F_CNT_0';

ALLOCATE CHANNEL C1 TYPE DISK;

Backup as compressed backupset Database tag DB_Full_15yrbkp format '/vol_name/15yr/full_vmSPDBSTG2_%U';

sql 'alter system archive log current';

BACKUP ARCHIVELOG ALL TAG Arc_Full_15yrbkp FORMAT '/vol_name/15yr/arch_vmSPDBSTG2_%U';

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