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

how to find database is running on PFILE or SPFILE

Below script will tells us if the database is running on PFILE or SPFILE  SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile'; OR SQL> show parameter spfile; NAME TYPE VALUE —— —— ———————————————— spfile string /u01/apps/oracle/10g/dbs/spfileorclkhan.ora parameter will tell you the location where the SPFILE is present as well.
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