Archivelog backup and deletion


Hi,

Below steps will help you to backup and delete archives

1. BACKUP ARCHIVELOG ALL delete input;

This backups up and deletes archive







2. BACKUP ARCHIVELOG UNTIL TIME 'sysdate' NOT BACKED UP 1 times;.
This will backup archives not backed-up yet



DELETE NOPROMPT ARCHIVELOG UNTIL TIME 'sysdate' BACKED UP 1 times to device type disk;

This is amazing deletes archives backup ed one time till 'sysdate'.


Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

Oracle Tablespace Size

Hi, Below Script will help you find Oracle Table Size, free and Used percentage. clear breaks clear computes clear columns set pagesize 50 set linesize 120 set heading on column tablespace_name heading 'Tablespace' justify left format a20 truncated column tbsize heading 'Size|(Mb) ' justify left format 9,999,999.99 column tbused heading 'Used|(Mb) ' justify right format 9,999,999.99 column tbfree heading 'Free|(Mb) ' justify right format 9,999,999.99 column tbusedpct heading 'Used % ' justify left format a8 column tbfreepct heading 'Free % ' justify left format a8 break on report compute sum label 'Totals:' of tbsize tbused tbfree on report select t.tablespace_name, round(a.bytes,2) tbsize, nvl(round(c.bytes,2),'0') tbfree, nvl(round(b.bytes,2),'0') tbused, to_char(round(100 * (nvl(b.bytes,0)/nvl(a.bytes,1)),2)) || '%' tbusedpct, to_char(round(100 * (nvl(c.bytes,0)/nvl(a.bytes,1)),2)) || '%' tbfr...
Read more

Oracle Dba Jobs Interview Question and Answers. PART-2

Continued from: http://ghufranahmedkhan.blogspot.com/2015/06/oracle-dba-jobs-interview-question-and.html 1. How many memory layers are in the shared pool? Ans:  The shared pool portion of the SGA contains three major areas: library cache(contains parsed sql statements,cursor information,execution plans), dictionary cache (contains cache -user account information,privileges information,data file,segment and extent information), buffers for parallel execution messages, and control structure. 2. How do you find out from the RMAN catalog if a particular archive log has been backed-up? Ans:  list archivelog all; 3. How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up? Ans: df -kh and du-sh 4. Define the SGA and: i)  How you would configure SGA for a mid-sized OLTP environment? ii) What is involved in tuning the SGA? Ans: SGA: The System Global Area (SGA) is a grou...
Read more

Oracle Dba Jobs Interview Question and Answers. PART-1

Salam, These are the Oracle DBA Interview Questions, these are compiled together at one place so that at the last movement you can have a look and go for the Interview. 1.  Basic  Level 1.1          Q- Which are the default passwords of SYSTEM/SYS?               ANS- MANAGER / CHANGE_ON_INSTALL 1.2          Q- How can you execute a script file in SQLPLUS?               ANS - To execute a script file in SQLPlus, type @ and then the file name. 1.3          Q- Where can you find official Oracle documentation?              ANS - tahiti.oracle.com 1.4          Q- What is the address of the Official Oracle Suppo...
Read more