Option#1:  Recover the deleted .dbf file from Linux process in-memory location I you have accidentally deleted the Oracle database .dbf files when database is Open, then you can recover the deleted dbf file from Linux in-memory held by the Oracle DB process.  This is possible because when you delete a file in Linux only inode of it is deleted but processes that are already connected to the file will remain using it via already opened file handle.  This file will be available until the running process is active.   Find the DB writer process: [root@ProdDB01 /]# ps -edf | grep […]

Error:  You may encounter below error while connecting to Oracle DB. ————————— ODBC 32Bit Test Program ————————— SQLSTATE: 08004 Native Error Code:1033 Driver Message:[Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in progress Need Any suggestions to avoid error ? ————————— Yes No —————————   Troubleshooting: The error message usually indicates that the Oracle DB is in the middle of starting up or shutting down.   You can give it couple to minutes and retry to see if the database is up and running fine.   If it doesn’t turn up, look into the Oracle dump log files. tail -15 /opt/dbfiles/inst3/bdump/alert_inst3.log

[root@ProdDB01 ~]# lsnrctl help LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 21-MAR-2014 07:21:53 (c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved. The following operations are available An asterisk (*) denotes a modifier or extended command: start               stop                status services            version             reload save_config         trace               spawn dbsnmp_start        dbsnmp_stop         dbsnmp_status change_password     quit                exit set*                show* [root@ProdDB01 ~]#   [root@ProdDB01 ~]# lsnrctl help show LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 21-MAR-2014 07:22:54 (c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved. The following operations are available after show An asterisk (*) denotes a modifier or extended command: rawmode                 displaymode             trc_file […]