|
||||
|
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 […] From 12c Onwards, DBA_users has two new columns, Last_login and Oracle_maintained SQL> desc dba_users Name Null? Type ——————————- ——– ———————- USERNAME NOT NULL VARCHAR2(128) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(4000) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(128) […] 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 […] Another nice performance tool from Oracle which process real time sessions and shows in nice output. Here it is
A very simple elegant, light weight tool to monitor the performance of the database, Just copy the executable from the note 1500864.1 and set your environment and run the command to monitor […] Few books released so far on 12c features or includes 12c Features, but all are not India (Asia) editions so they might be expensive, Watch out for this books in Flipkart and you may get for lesser prices once they get released here in India. 12c New Features book from Robert Freeman As usual […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!