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 […] Most of the times when the index key length is bigger you cannot do the rebuild the index online , this is due to the fact that IOT table will be created by Oracle while rebuilding online and the key length is exceeded. ORA-01450: maximum key length (3215) exceeded More read on this, […] From 12c onwards, we can create a mixed indexes (bitmap and btree both) on same columns which is very useful in DW environments. Before to 12c you will receive the such column is already indexed error or index already exists if you want to create the same. I have a copy of dba_objects as […] 12c Introduced the datafiles movement online, Earlier to 12c we have to a) offline the datafile b) Move the datafile to new location using os command c) Rename the datafile for data dictionary update d) Online the datafile From 12c, its just need a command "alter database move datafile" Lets see how it works […] |
||||
Follow Me!!!