Table recovery Table recovery was possible in earlier releases as well. Until previous releases, if we wanted to recover a table, we had the following options: Database point in time recovery (DBPITR) Tablespace point in time recovery (TSPITR) Flashback technology The RECOVER TABLE command is a new feature in 12C that allows a point in time recovery of a table or a table partition. The table is recovered into an auxiliary instance and there is the option to: import the recovered … [Read more...] about Oracle Database 12c New Feature – RMAN “RECOVER TABLE”
RMAN
How to recreate Control file in Oracle Database
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
Managing Oracle Database Backup with RMAN (Examples included)
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)
How to delete archives from only 1 archive destination when 2 or more are in use
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