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?
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;
Getting pretty late in the product lifecycle for 10.2.
If the databse is worth running in archivelog mode, it is worth haveing a regular backup schedule to include both the database and archivelogs. you say you want to back up an delete archivelogs not backed up since 1 month ... what about those that haven't been backed up since 2 months? And when was the last backup of the database?
Don't worry about the date.
BACKUP ARCHIVELOG NOT BACKED UP 1 TIME DELETE ALL INPUT;
Above should be done daily.
Along with your regular database backup.
When was the last database backup?