Database Backup and Recovery (MOSC)

MOSC Banner

Database fail to startup

edited Feb 5, 2011 6:59PM in Database Backup and Recovery (MOSC) 7 commentsAnswered
I have Oracle 9i databse with no archivlog mode, yesterday i have troubleshooting with my database

*******************************************************************************************

ORA-01194: Le fichier 1 nÙ„cessite plus de rÙ„cupÙ„ration pour مtre cohÙ„rent
ORA-01110: fichier de donnÙ„es 1 : 'D:\ORACLE\ORADATA\ORA9I\SYSTEM01.DBF'

then , i have read the note Note:435201.1

*******************************************************************************************

set pagesize 20000
	
set linesize 180
set pause off
set serveroutput on
set feedback on
set echo on
set numformat 999999999999999
Spool recovery_info.txt
select substr(name, 1, 50), status from v$datafile;
select substr(name,1,40), recover, fuzzy, checkpoint_change# from v$datafile_header;
select GROUP#,substr(member,1,60) from v$logfile;
select * from v$recover_file;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center