Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

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 […]

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 […]

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

[oracle@Geek DBA12c admin]$ rman target / Recovery Manager: Release 12.1.0.1.0 – 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 […]