RMAN

What are control files? The control file is a binary file that defines the current state of the physical database. The control file is one of the core files at the heart of the Oracle database. Together, this means that the Oracle instance itself is the only means by which the contents of the control file should ever be modified. The DBA should only modify it indirectly by means of altering the database. Loss or corruption of the control file requires a database recovery. The control file is … [Read more...] about How to recreate Control file in Oracle Database

Installed with the database, Recovery Manager (RMAN) is an Oracle database client which performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering the database. The RMAN environment consists of the utilities and databases that play a role in backing up your data. At a minimum, the environment for RMAN must include the following: The target database. This is the database to be … [Read more...] about Managing Oracle Database Backup with RMAN (Examples included)

If you want to delete the archives of 1 LOG_ARCHIVE_DEST using rman command and want to keep the archive logs from other LOG_ARCHIVE_DEST_[n] for some other purpose, then use DELETE LIKE-clause in RMAN. This way you can maintain the archives in one location and keep the same copy of the archives in another location. Consider the below example: 1. You have 2 archive destinations to keep the archive logs. /u01/app/oracle/arch/test2 /u01/app/oracle/test/arch2 SQL> show parameter … [Read more...] about How to delete archives from only 1 archive destination when 2 or more are in use