Home » RDBMS Server » Backup & Recovery » ORa-01135
ORa-01135 [message #193512] Mon, 18 September 2006 00:54 Go to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hai ,,

need a urgent help.. I have a tablespace having two datafiles.
I was trying to resize (increase) the particular tablespace (2nd data_file).
Iam getting the error - ora -01135. But the tablespace is in available status in dba_data_files,but in V$datafile it shows that particular datafile status is showing recover.Our db is in archive log mode ..

Please tell me what to do in this case.ths is urgent

regards
jay...
Re: ORa-01135 [message #193576 is a reply to message #193512] Mon, 18 September 2006 05:53 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
From SQL*Plus:

CONNECT SYS/... AS SYSDBA

ALTER DATABABSE DATAFILE ... OFFLINE;

RECOVER DATAFILE ...

ALTER DATABASE DATAFILE ... ONLINE;
Previous Topic: HOW TO BACK UP MY DATABASE
Next Topic: Gathering Schema Stats
Goto Forum:
  


Current Time: Wed Dec 07 20:10:14 CST 2016

Total time taken to generate the page: 0.09174 seconds