Home » RDBMS Server » Backup & Recovery » Archives deletion,
Archives deletion, [message #250962] |
Thu, 12 July 2007 01:18  |
somavamshi
Messages: 17 Registered: July 2007 Location: bangalore
|
Junior Member |
|
|
Hi...
My archives destination is filling up daily.
1) I moved some of the archives to another location.
2) Again its filled.
3) Again moved some files using zip.
4) If I delete the files 10 days back old. What happens?
5) Is that required for recovery the older one or not?
regards
Soma
|
|
|
|
|
|
|
|
Re: Archives deletion, [message #251496 is a reply to message #251493] |
Fri, 13 July 2007 17:23   |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
create script GAM_backup_whole
{
allocate channel ch1 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch2 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch3 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch4 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch5 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch6 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch7 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch8 type disk format '$GAM_ORABACKUP/%U.bck';
allocate channel ch9 type disk format '$GAM_ORABACKUP/%U.bck';
set limit channel ch1 kbytes 2024800;
set limit channel ch2 kbytes 2024800;
set limit channel ch3 kbytes 2024800;
set limit channel ch4 kbytes 2024800;
set limit channel ch5 kbytes 2024800;
set limit channel ch6 kbytes 2024800;
set limit channel ch7 kbytes 2024800;
set limit channel ch8 kbytes 2024800;
set limit channel ch9 kbytes 2024800;
backup as compressed backupset database;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all delete all input format '$GAM_ORABACKUP/al_%U.bck';
backup current controlfile
tag = cf1
format '$GAM_ORABACKUP/cf_%U.bck';
}
[Updated on: Fri, 13 July 2007 17:24] Report message to a moderator
|
|
|
|
|
|
Goto Forum:
Current Time: Sat May 03 14:26:14 CDT 2025
|