Database Backup and Recovery (MOSC)

MOSC Banner

Online Redo Log Switching

edited Nov 17, 2011 2:28AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓
Hi all,

I want to separate the backup process of the database from the datafiles. Now I am executing a buckup plus archivelog

run {
   RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
   CROSSCHECK BACKUP OF DATABASE;
   ALLOCATE CHANNEL c1 DEVICE TYPE DISK MAXPIECESIZE 1 G FORMAT '/orafiles/backup/hot/%d_HOT1_%t_%U.bak';
   ALLOCATE CHANNEL c2 DEVICE TYPE DISK MAXPIECESIZE 1 G FORMAT '/orafiles/backup/hot/%d_HOT2_%t_%U.bak';
   BACKUP INCREMENTAL LEVEL 0 CUMULATIVE
   AS COMPRESSED BACKUPSET
   DATABASE PLUS ARCHIVELOG;
   RELEASE CHANNEL c1;
   RELEASE CHANNEL c2;
}

I want to remove the "PLUS ARCHIVELOG", and backup the archives with the folowwing script:

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