Skip to main content

Oracle database not starting

I have an Oracle database(Oracle 9.2.0.1.0) running on RedHat Linux 7.2. The server has 1GB ram. The service was running in Archivelog mode.Service is set to autostart.
Recently I found on restarting the server the listener started by the service did not.
I started the service using STARTUP MOUNT and using ALTER DATABASE I stopped the archivelogs. I have posted my next few commands, kindly help me.... SQL> startup mount
ORACLE instance started.
Total System Global Area  426316116 bytes
Fixed Size                  450900 bytes
Variable Size            268435456 bytes
Database Buffers          157286400 bytes
Redo Buffers                143360 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/oradata/testdb/testdb_system01.dbf'
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 12589066 generated at 08/16/2004 20:06:55 needed for thread 1
ORA-00289: suggestion : /oracle/oradata/testdb/archive/arch_431387338_9446_1.dbf
ORA-00280: change 12589066 for thread 1 is in sequence #9446


Specify log: {=suggested | filename | AUTO | CANCEL}
/oracle/oradata/testdb/archive/arch_431387338_9446_1.dbf
ORA-00308: cannot open archived log
'/oracle/oradata/testdb/archive/arch_431387338_9446_1.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/oracle/oradata/testdb/archive/arch_431387338_9446_1.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/oradata/testdb/cstdb_system01.dbf'
Now the only thing I have not done is '_allow_resetlogs_corruption' trick, but then that is the last step, unless someone thinks up something.
Thanks in advance.
Sameer

Question1: did you copy your dbf after you shutdown the database?

1.Put test in archive log mode and dont forget about the arch log destination:

2. copy your redo logs from PROD server to your test databse's arch log mountpoint

3.then at svrmgr"
"recover database using backup controlfile until cancel:

when it prompts you for the arch give the current redo.
then type "cancel"

that should fix the problem
then alter database open resetlogs

if you get same error apply more redos.


ORA-01194:

file string needs more recovery to be consistent
Cause:An incomplete recovery session was started, but an insufficient number of logs were applied to make the file consistent. The reported file was not closed cleanly when it was last opened by the database. It must be recovered to a time when it was not being updated. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.
Action:Either apply more logs until the file is consistent or restore the file from an older backup and repeat recovery.

Comments

Popular posts from this blog

INSTALL CISCO VPN CLIENT ON WINDOWS 10 (32 & 64 BIT). FIX REASON 442

This article shows how correctly install Cisco VPN Client (32 & 64 bit) on Windows 10 (32 & 64 bit) using simple steps, overcome the ‘ This app can’t run on this PC ’ installation error , plus fix the Reason 442: Failed to enable Virtual Adapter error message . The article applies to New Windows 10 installations or Upgrades from earlier Windows versions and all versions before or after Windows 10 build 1511 .  To simplify the article, we’ve broken it into the following two sections: How to Install Cisco VPN client on Windows 10 (clean installation or upgrade from previous Windows), including Windows 10 build prior or after build 1511 . How to Fix Reason 442: Failed to enable Virtual Adapter on Windows 10 Figure 1. The Cisco VPN Client Reason 442: Failed to enable Virtual Adapter error on Windows 10 HOW TO INSTALL CISCO VPN CLIENT ON WINDOWS 10 (NEW INSTALLATIONS OR O/S UPGRADES) The instructions below are for new or clean Windows 10 inst...

How to create a Hirens Boot CD 15.2 USB Disk

Hiren’s BootCD (HBCD) is a bootable CD that contains a set of tools that can help users to fix their computer if their system fails to boot. More specifically, HBCD contains hardware diagnostic programs, partition tools, data recovery utilities, antivirus tools and many other tools to fix your computer problems.  I write this article because I use Hiren’s BootCD frequently to troubleshoot computer problems, specially when a computer doesn’t boot anymore due to a virus attack or due to a corrupted file system. In this article you will find instructions on how to put Hiren’s BootCD on a USB flash drive (stick) in order to troubleshoot computer problems in the future.

Internet Connection Sharing has been disabled by the Network Administrator. (Solved)

Problem: Logged in to computer with domain account has administrator privileges, and wanted to share my computer’s wifi to my mobile phone. When open the network sharing dialog, the dialog says: Internet Connection Sharing has been disabled by the Network Administrator.