473,379 Members | 1,253 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

archived active redo logfile group corrupted

Niy
can not open database because of this, what I can
do in this sceneiaro? complete or incomplete recovery?

database was closed because of media crash. so also
need instance recovery
Jul 19 '05 #1
1 2776
ni***@hotmail.com (Niy) wrote in message news:<55**************************@posting.google. com>...
can not open database because of this, what I can
do in this sceneiaro? complete or incomplete recovery?

database was closed because of media crash. so also
need instance recovery


incomplete recovery, up to the log preceding the corrupt one.
You'll going to loose data, regrettably.
Complete recovery will fail because of the corrupt log.
Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Hari Om | last post by:
Hi Gurus, I was reading Oracle DBA Handbook and read article about OFA - Optimal Flexible Architecutre and it showed what are the different tablespaces used in any db. These are: SYSTEM,...
1
by: Raquel | last post by:
Ok, so these are the two pieces of information regarding the location of archived logs during a rollforward recovery in a recoverable database: 1. OVERFLOWLOGPATH configuration parameter can...
3
by: babylon | last post by:
any facilities in csharp that can help me implmenting undo/redo in my application? thx
5
by: Harry Haller | last post by:
For some reason Google groups does not seem to be working with this group. <http://groups-beta.google.com/advanced_search> Is it archived anywhere else?
1
by: tangus via DotNetMonster.com | last post by:
Hello all, I'm really struggling with getting some Active Directory code to work in ASP.NET. Can you please provide assistance? I am executing the following code: Dim enTry As DirectoryEntry =...
5
by: Robin Tucker | last post by:
Ok now my intellisense has gone t's-up again - I also cannot use undo/redo in the editor. I deleted the NCB file in case that was corrupt but no poonanas, its still fubar (how many explitives can...
3
by: donnyma | last post by:
I have a problem that looks like it has not been discussed before in these groups. I have a simple SQLAgent job that runs sp_who (could be anything, but let's just say sp_who for this example). ...
4
by: madzambonis | last post by:
Here is the situation.... We have Primary Server A linked to Standby Server B via HADR. Primary Server A has recently installed LOGARCHMETH1 to archive logs and a 2nd homegrown script that...
0
by: Reshmi Jacob | last post by:
Hi My problem occurs in a network with 40-50 systems working from a server. Current users will be kicked out with "ORA-01092: ORACLE instance terminated. Disconnection forced", and users trying...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.