DBA Hub

📋Steps in this guide1/1

Archive log Backup Command

In this blog, We will see the archive log backup command.

oracle configurationintermediate
by OracleDba
13 views
1

Overview

In this blog, We will see the archive log backup command. Archivelog List Commands: Archivelog Delete Commands: Following commands can be used to delete the old archive logs

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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;

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;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!