Oracle 23c New Features for DBA'sThe 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 […]
|
||||
|
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 […] 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 […] 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 […] 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 […] 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 […] [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 […] |
||||
Follow Me!!!