0
votes
1answer
335 views

ORA-15081: failed to submit an I/O operation to a disk

I have a test environment for Oracle single instance on ASM 11.2.0.3. I have restored database from tape and during the recovery, the system crashed by some I/O error. I restarted the server, ...
0
votes
0answers
164 views

Oracle Transaction recovery: lock conflict caught and ignored

In alert log there are a lot of "Transaction recovery: lock conflict caught and ignored" statements. I've found some information, that this error is caused when there is an active dead transaction. ...
1
vote
2answers
320 views

RMAN list archivelogs that are needed for to recover specified backup

I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed. Now, I want to determine what archivelogs should I backup to be sure that my ...
0
votes
2answers
201 views

why archived log size is small but fast recovery area still has a lot free space

when recovery database I met a strange problem,my recovery script as follow: RUN { SET UNTIL TIME 'DEC 25 2013 09:00:00' ; RESTORE DATABASE; RECOVER DATABASE; } but rman report as ...
1
vote
1answer
115 views

Recover corrupted blocks in Oracle 10g XE

I am using Oracle 10g XE. I've noticed corrupted block error in datafile 1 in alert log. As I've found Oracle XE doesn't support Block Media Recovery(needs to be Enterprise Edition). So I did the ...
1
vote
1answer
169 views

Recover oracle 10g database from old data files

I have an Oracle 10g database. Unfortunately, our machine and system crashed and all the backups and Oracle archive logs, but we have old image copies of our data files and one of the control file ...
0
votes
3answers
174 views

Oracle DB Recovery

Before I start, I just want to mention that I am not a DBA, I am a programmer/developer who also happens to look after the database. So if I say something wrong, my apologies in advance. We recently ...
1
vote
3answers
352 views

Restore Oracle tablespace to 2 days before

I have multiple test tablespaces in an Oracle SID. One of the tablespace is updated with wrong data. It works fine 2 days before. I want to restore the tablespace to 2 days before. Can anyone ...
-4
votes
1answer
80 views

Oracle database and data has been corrupted. Is there a way to get it back? [closed]

The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
2
votes
1answer
520 views

How to Recover My Oracle 9i Database From Just The Datafiles

The state of the system when I started was that there was a single, working instance of Oracle Database 9i. I proceeded to install Oracle 11g choosing to Install Software Only. Upon completion, ...
4
votes
1answer
446 views

Retrieving data if control file is lost in oracle Database

Suppose if the databases control file is lost permanently (no backup). Can we retrieve the data from data file in Oracle database?
4
votes
2answers
271 views

Change Location of VALIDATE RECOVERY FILES work area

Is there a way to tell the VALIDATE RECOVERY FILES command to use a different location with more available disk space? When I run the command in RMAN, it fails with the following error stack: ...
3
votes
1answer
3k views

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

I have the following situation: Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM. I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
2
votes
1answer
668 views

How to disable instance recovery in ORACLE?

I want my DB to stop instance recovery during opening, how to do it? I want it because it crashes when trying to do instance recovery, I am testing some cases and want to disable it Is there any ...
1
vote
1answer
143 views

Oracle Backup/Recovery architecture

When we write the following: allocate channel ch1_tape type sbt; set controlfile autobackup format for device type sbt to '%F'; restore controlfile from autobackup; RELEASE CHANNEL ch1_tape; By ...
2
votes
1answer
126 views

Oracle Backup and Recovery Issue

I have backed up database located on Host1 and restored/recovered it on Host2. After a while, I backed up DB on Host1 again. Now I want DBs on Host1 and Host2 be the same using last backup. How can ...
2
votes
3answers
537 views

Oracle get sql redo from log_history

I run into a problem with a customer which had no proper backup. His last backup (meaning exp-dump) is from 1st Aug 2011. However he lost due to batch DELETE statements all data. My plan was now to ...
0
votes
3answers
194 views

What all are the recoverable points of failure in an Oracle database?

I am testing a product against an Oracle database for failure scenarios. The product talks to Oracle through a session and maintains a few tables. I want to make sure that whenever Oracle recovers ...