Home » RDBMS Server » Backup & Recovery » RMAN archive log backup (Oracle 10.2.0.4)
RMAN archive log backup [message #437817] Wed, 06 January 2010 02:44 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I want to backup all archivelogs and delete archivelogs before 1 day so i am using below RMAN statements. Is that correct?

BACKUP ARCHIVELOG ALL;
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-1';


If yes then please let me know how i can write those 2 statements as one line?

Thanks,
Re: RMAN archive log backup [message #437827 is a reply to message #437817] Wed, 06 January 2010 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes it is correct
2/ You can't

Regards
Michel
Re: RMAN archive log backup [message #437858 is a reply to message #437817] Wed, 06 January 2010 05:07 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Michel.
Previous Topic: RMAN : ORA-27041: unable to open file while file exists at location
Next Topic: rman can't backup (strange satuation) (merged)
Goto Forum:
  


Current Time: Sun Dec 11 08:09:48 CST 2016

Total time taken to generate the page: 0.14446 seconds