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 #251219 is a reply to message #250962] |
Thu, 12 July 2007 13:08 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
somavamshi wrote on Thu, 12 July 2007 00:18 | 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
|
you have an option of deleting archivelogs on daily basis after RMAN BACKUP completion.
|
|
|
|
|
Re: Archives deletion, [message #251493 is a reply to message #250962] |
Fri, 13 July 2007 17:07 |
bato
Messages: 6 Registered: July 2007 Location: Republic of Srpska, Bosni...
|
Junior Member |
|
|
run {
backup database format='...
backup archivelog all delete all input;
-- or
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
-- or something else
}
|
|
|
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
|
|
|
Re: Archives deletion, [message #251500 is a reply to message #250962] |
Fri, 13 July 2007 17:47 |
bato
Messages: 6 Registered: July 2007 Location: Republic of Srpska, Bosni...
|
Junior Member |
|
|
You don't need 'ALTER SYSTEM ARCHIVE LOG CURRENT'.
If the database is open when you run BACKUP ARCHIVELOG, and if the UNTIL clause or SEQUENCE parameter is not specified, then RMAN runs ALTER SYSTEM ARCHIVE LOG CURRENT.
|
|
|
Re: Archives deletion, [message #251503 is a reply to message #251500] |
Fri, 13 July 2007 17:56 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
Quote: | You don't need 'ALTER SYSTEM ARCHIVE LOG CURRENT'.
|
Why explain ??
Quote: | and if the UNTIL clause or SEQUENCE parameter is not specified
|
Are these new clauses for backup??
Quote: | then RMAN runs ALTER SYSTEM ARCHIVE LOG CURRENT.
|
What does it means??
|
|
|
|