Explain how to backup and restore archived log files

          

Explain how to backup and restore archived log files


Oracle database backup and recovery - Explain how to backup and restore archived log files posted by Babu Kunwar
<<Previous   Next>>

Explain how to backup and restore archived log files

We can archive logs using RMAN. RMAN provides option that once the backup is completed, we have the option to leave the logs in place, to delete only the logs that RMAN used for the backup, or to delete all copies of the archived logs that were backed up to tape.

The backup and restore can be done as:
RMAN> backup device type sbt archivelog all delete input;
In the case when we want to delete all the input files then we use delete all input option instead of all delete input.



Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
More links
PL/SQL control structures

Conditional control: IF and CASE Statements.
Iterative Control: LOOP and EXIT Statements.
GOTO statement takes the control to the labeled statement............

Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring