Monthly Archives: May 2014

Recovery of a Missing Datafile that has no backups (database is open).

Datafile Lost due to OS level delete: ===================================== Recovery of a Missing Datafile that has no backups (database is open). If a non system datafile that was not backed up since the last backup is missing, recovery can be performed … Continue reading

Posted in Oracle | Tagged , , , | 3 Comments

CRS-2800 | Cannot start resource

set lines 190 set pages 150 select host_name,name,instance_name,database_role,status,open_mode,logins from v$instance,v$database; HOST_NAME NAME INSTANCE_NAME DATABASE_ROLE STATUS OPEN_MODE LOGINS —————————————————————- ——— —————- —————- ———— ——————– ———- shanojrac1 ORCL ORCL1 PRIMARY OPEN READ WRITE ALLOWED [grid@shanojrac1 root]$ srvctl status database -d orcl Instance … Continue reading

Posted in Oracle, Oracle RAC | Tagged , | Leave a comment

How to Audit User Activity in Oracle Database

Step 1. SQL> alter system set audit_trail=db scope=spfile; System altered. SQL> alter system set audit_sys_operations=true scope=spfile; Step 2. stop Database Step 3. start database. Step 4. check parameter SQL> show parameter audit_ NAME TYPE VALUE ———————————— ———– —————————— audit_file_dest string … Continue reading

Posted in Oracle | Tagged , , , | Leave a comment