Home » RDBMS Server » Backup & Recovery » Archives deletion,
Archives deletion, [message #250962] Thu, 12 July 2007 01:18 Go to next message
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 #250986 is a reply to message #250962] Thu, 12 July 2007 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If I delete the files 10 days back old. What happens?

Nothing.
Archived log only purpose is to recover the database.
If you backup it each (for instance) you only need 1 day or archived logs.

Quote:
Is that required for recovery the older one or not

Archived logs are necessary to recover from a backup older than them.

Regards
Michel
Re: Archives deletion, [message #251219 is a reply to message #250962] Thu, 12 July 2007 13:08 Go to previous messageGo to next message
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 #251490 is a reply to message #250962] Fri, 13 July 2007 16:33 Go to previous messageGo to next message
bato
Messages: 6
Registered: July 2007
Location: Republic of Srpska, Bosni...
Junior Member
backup archivelog all delete all input;
Re: Archives deletion, [message #251491 is a reply to message #251490] Fri, 13 July 2007 16:49 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
It is correct i was tellling you about deletion of archivelogs after the ONLINE BACKUP by RMAN.
Re: Archives deletion, [message #251493 is a reply to message #250962] Fri, 13 July 2007 17:07 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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??
Re: Archives deletion, [message #251504 is a reply to message #250962] Fri, 13 July 2007 18:15 Go to previous message
bato
Messages: 6
Registered: July 2007
Location: Republic of Srpska, Bosni...
Junior Member
You can read explaination of archivelogRecordSpecifier in documentation.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta008.htm#i78730
Previous Topic: ora-01152
Next Topic: Restoring Database from backup made in noarchivelog mode using RMAN
Goto Forum:
  


Current Time: Wed May 15 09:23:16 CDT 2024