When cloning (duplicating) a database to a higher version, traditionally (prior to 12c), you must use restore/recover of an RMAN backup. This is because the database in the destination must be opened with UPGRADE option. Therefore, the RMAN duplicate could not be used because RMAN automatically opens the auxiliary database with resetlogs. This would fail with error 'ORA-39700: database must be opened with UPGRADE option'. In RMAN 12c, a new option is available "NOOPEN" requesting RMAN to … [Read more...] about Upgrading to Oracle 12c using RMAN DUPLICATE with “NOOPEN” clause and “BACKUP LOCATION”
RMAN
Beginners Guide to RMAN compression for backups
As the databases keep growing, so does the space occupied by their backups. Fortunately, RMAN has built-in support to compress such large-sized backups which can be handy rather than using an OS utility such as TAR or so on. The following are the 3 kinds of compression techniques used by RMAN: Null compression Unused block compression Binary compression RMAN uses block compression by default and that's why you can't set it off (or on either). Two modes of block compression are … [Read more...] about Beginners Guide to RMAN compression for backups
Oracle Database 12c New Feature – RMAN “RECOVER TABLE”
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”
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