ORACLE DBA

 Database Upgrade from 11202 to 12101  Copy two sql files to /tmp location [oracle@yesbolisetty admin]$ cd /tmp/upgrade/ [oracle@yesbolisetty upgrade]$ ls -lrt total 396 -rwxr-xr-x 1 oracle oinstall   5231 Nov  9 14:10 preupgrd.sql -rwxr-xr-x 1 oracle oinstall 381893 Nov  9 14:16 utluppkg.sql Step 2: connect to 11g database and execute preupgrd.sql script [oracle@yesbolisetty upgrade]$ dba SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 9 14:16:35 2013 Copyright (c) 1982, 2010, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @preupgrd.sql Loading Pre-Upgrade Package... Executing Pre-Upgrade Checks... Pre-Upgrade Checks Complete.       ************************************************************ Results of the checks are located at:  /u02/app/oracl...

Hi Friends, Collected important Oracle Database 12c new features ( ఒరాకిల్ 12సి  అంశాలు  ) Online migration of an active data file Online table partition or sub-partition migration Invisible column Multiple indexes on the same column DDL logging Temporary undo in- and- outs New backup user privilege How to execute SQL statement in RMAN Table level recovery in RMAN Restricting PGA size 1. Online rename and relocation of an active data file Unlike in the previous releases, a data file migration or renaming in Oracle database 12c R1 no longer requires a number of steps i.e. putting the tablespace in READ ONLY mode, followed by data file offline action. In 12c R1, a data file can be renamed or moved online simply using the ALTER DATABASE MOVE DATAFILE SQL statement. While the data file is being transferred, the end user can perform queries, DML and DDL tasks. Additionally, data files can be migrated between storages e.g. from non-ASM to ASM and vice versa. ...