Subscriber Count


Subscribe to Posts by Email


12c Database : RMAN Enhancement : Duplicate from Active Database Enhancements

The ACTIVE DUPLICATE DATABASE option in 11g clone the source database by coping the full image of the data files to the auxiliary instance location through the network. This procedure doesn’t not required any pre backup existence to clone the database. However, in Oracle 12c, when ACTIVE DUPLICATE DATABASE is initiated, instead of sending the […]

12c Database : RMAN Enhancement : Rollfoward standby using network service without incremental backups

As discussed, earlier, Another important nice feature in RMAN from 12c is using network based recovery or incremental backup strategy from the servics. This eliminates taking incremental backups or copy those backup to standby and saves lot of time. Lets check, On Primary, check the latest log

Check on Primary

SQL> archive log […]

12c Database : RMAN Enhancement : Restore the datafiles directly from Standby using TNS Service

From 12c Onwards, RMAN has been enhanced to restore/recover the datafiles/tablespaces etc from the network services rather copying them manually. This enhanancement facilitates easy recovery operations when you have standby database without backups or activation etc. YOu can even recover the database from standby using service in RMAN in restore command.

Lets see how […]

12c Database : Step by Step standby creation using RMAN duplicate database

Step by Step standby creation using RMAN duplicate database

This post is about to create a standby database in container enabled database (Just want to check any changes required from previous versions steps) All steps are similar like previous versions except we have to create directory structures for PDB databases otherwise RMAN script will fail […]

12c Database : RMAN Enhancements : Restore/Recover the table from RMAN

Prior to 12c, restoring a table if accidently dropped is a cumbersome process via RMAN backups. The following are the steps are to be performed to do the same 1) Create a auxiliary instance 2) Duplicate the database 3) Manually export the dropped table 4) Import that into original database 5) clean up the auxiliary […]

12c Database : RMAN enhancements : use of select and other commands in RMAN Prompt

Starting 12c, from RMAN prompt the SELECT statement can be fired, Lets check some Select on V$ views RMAN> select file_name from dba_data_files; using target database control file instead of recovery catalog FILE_NAME ——————————————————————————– /u01/app/oracle/oradata/DB12c/system01.dbf /u01/app/oracle/oradata/DB12c/sysaux01.dbf /u01/app/oracle/oradata/DB12c/undotbs01.dbf /u01/app/oracle/oradata/DB12c/new/users01.dbf RMAN> select username,sid,status from v$session; USERNAME SID STATUS —————————— ———- ——– 2 ACTIVE 3 ACTIVE 4 ACTIVE […]

12c Database : RMAN Enhancements : Multisection backups for image copy backup

[oracle@Geek DBA12c admin]$ rman target / Recovery Manager: Release – Production on Fri Sep 13 21:15:43 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: DB12C (DBID=1279089071) RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 5; using target database control file instead of recovery catalog new RMAN configuration […]