Thursday, October 15, 2015

Wrongly added datafile in ASM, migrating the non-ASM datafile to ASM datafile

›
Wrongly added datafile in ASM, migrating the non-ASM datafile to ASM datafile: One of our junior DBA added the datafile to tablespace (w...
Friday, September 18, 2015

How to check the last DML time on object

›
How to check the last update time on object 1) select * from all_tab_modifications where table_name = '<table_name>'; ( may...
Monday, December 15, 2014

RMAN-06183: datafile or datafile copy xxxx_data_01.dbf (file number 9) larger than MAXSETSIZE

›
RMAN-06183: datafile or datafile copy prod_data_01.dbf (file number 9) larger than MAXSETSIZE Error: Starting backup at 15-DEC-14 ...

ORA-27211: Failed to load Media Management Library

›
ORA-27211: Failed to load Media Management Library Error description: RMAN-00571: ===================================================...
Tuesday, October 7, 2014

debug session in SQL Developer

›
Problem: Getting the following error when debugging a function under GENEVA_DATA user in hostname: ORA-01031: insufficient privileges O...
Wednesday, May 21, 2014

Interview questions

›
First round What will u do when the switchover hungs? hw do u perform the switchover? what are the prechecks u do ? how to setup the...
Wednesday, May 7, 2014

oracle 11gR2 Grid infrastructure (RAC)

›
Starting with Oracle Database 11g Release 2, Oracle Clusterware and Oracle ASM are installed into a single home directory, which is called...