1 - 2 minutes readCase 2: Recover form corrupted or missing data file (When database Open)

Anup May 20, 2011

0 Comments

Reader Mode

Error At run time:

SQL> conn / as sysdba

Connected.

SQL> select * from scott.emp;

select * from scott.emp

ERROR at line 1:

ORA-01116: error in opening database file 4

ORA-01110: data file 4: ‘/home/oracle/DB/INDIAN/users01.dbf’

ORA-27041: unable to open file

Intel SVR4 UNIX Error: 2: No such file or directory

Additional information: 3

Step 1: Check data file Status.

SQL> select * from v$backup;

FILE# STATUS CHANGE# TIME

———- —————— ———- ———

1 NOT ACTIVE 0

2 NOT ACTIVE 0

3 NOT ACTIVE 0

4 FILE NOT FOUND 0

5 NOT ACTIVE 0

Step 2: offline missing datafile

SQL> alter database datafile ‘ offline;

Step 3: Recover datafile;

SQL> recover datafile 4;

Post Views: 30

Categories: Backup/Recovery

Type of RMAN Backup Tutorial

Reader Mode Full Backups A full backup reads the entire file and copies all blocks into the backup set, only skipping datafile blocks that have…

Anup June 13, 2009

0 Comments

Simple Steps to Find Password for an Application User in Oracle Applications

Reader Mode To achieve this you need to create a small package and run a query which I wrote below: Step 1: Create Package Specification…

Anup October 5, 2023

0 Comments

How to Move OCR and Voting Disk to ASM Diskgroup in 11gR2

Reader Mode We can use the following steps to migrate OCR and Vote Disk from RAW to ASM Disk. Step 1:- Check the current OCR…

Anup October 5, 2023

0 Comments

Generate Create Tablespace Script

Reader Modeset serveroutput on size 1000000 DECLARE CURSOR get_ts IS SELECT * FROM dba_tablespaces WHERE tablespace_name != ‘SYSTEM’; CURSOR get_df (p_ts VARCHAR2) IS…

Anup October 5, 2023

0 Comments

Case 1: Recovery from corrupted or missing datafile

Reader Mode This scenario deals with a situation where a datafile has gone missing, or is corrupted beyond repair. For concreteness, we look at a…

Anup May 20, 2011

0 Comments

Related Articles

Responses