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,

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ Yes it is correct
2/ You can't

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 18:48:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.