- 25 Jul, 2021
- 0 Comments
- 36 Secs Read
Archive log Backup Command
In this blog, We will see the archive log backup command.
Archivelog List Commands:
1 2 3 4 5 6 7 | list archivelog all; list copy of archivelog until time 'SYSDATE-1'; list copy of archivelog from time 'SYSDATE-1'; list copy of archivelog from time 'SYSDATE-1' until time 'SYSDATE-2'; list copy of archivelog from sequence 2000; list copy of archivelog until sequence 3000; list copy of archivelog from sequence 2000 until sequence 3000; |
Archivelog Delete Commands:
Following commands can be used to delete the old archive logs
1 2 3 4 5 6 7 | delete archivelog all;delete archivelog until time 'SYSDATE-1'; delete archivelog from time 'SYSDATE-1'; delete archivelog from time 'SYSDATE-1' until time 'SYSDATE-2'; delete archivelog from sequence 2000; delete archivelog until sequence 3000; delete archivelog from sequence 2000 until sequence 3000; |