Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to backup archive logs to disk which are not backed up 1 time?

sweetritzJun 9 2014 — edited Jun 10 2014

Hi DBAs,

I have a filesystem in which archive logs are stored and not backed up since 1 month as its a pre prod environment 10.2.0.5 . But the problem is now the filesystem is 98% fill and i need to backup all the archive logs since may 15 to june 9 to a specific disk location. is the following command correct?

run {

allocate channel ch01 type disk maxpiecesize 7000M;

allocate channel ch02 type disk maxpiecesize 7000M;

BACKUP tag ArchLogAll FILESPERSET 20 FORMAT '/oracledb/oradata/DBOEM/ORAFL/DBOEM/DBOEM/backupset/2014_06_09/%d/d_%d_s_%s_p_%p_t_%t.bkp' ARCHIVELOG ALL not backed up 1 times;

delete noprompt archivelog all backed up 1 times to DEVICE TYPE disk;

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

}

Regards,

Ritu

This post has been answered by EdStevens on Jun 9 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2014

Added on Jun 9 2014

#backup, #oracle, #performance-availability, #recovery-manager-rman, #rman

4 comments

6,657 views