Category: DataBase

When we did a cloning/recover the database with noarchivelog mode, we got the problem that some datafile need to be recover. It will be difficulty since no archivelog that can help us to recover it. Otherwise we can copy all datafiles from offline backup of the source database. But it will takes time to copy/ftp/restore especially if the database size are hundreds GB or even TB. But there is a solution to recover the database with noarchivelog mode, please check this out :  When we did a cloning, startup nomount :           $ sqlplus ‘/as sysdba’ SQL*Plus: Release 10.2.0.4.0 – Production […]

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