Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET NLS_DATE_FORMAT=YYYYMMDD HH24:MI:SS
- Archivelog List Commands:
- 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 1000;
- list copy OF archivelog until sequence 1500;
- list copy OF archivelog FROM sequence 1000 until sequence 1500;
- Archivelog DELETE Commands:
- 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 1000;
- DELETE archivelog until sequence 1500;
- DELETE archivelog FROM sequence 1000 until sequence 1500;
- Note : USE noprompt TO avoid being prompted FOR each file
- DELETE noprompt archivelog until TIME 'SYSDATE-1';
- USE FORCE IF you try TO DELETE the archive LOG files which are NOT backed up:
- DELETE FORCE archivelog until TIME 'SYSDATE-1';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement