|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01113: file 5 needs media recovery [message #554249 is a reply to message #554241] |
Fri, 11 May 2012 11:24   |
 |
Seant
Messages: 6
Registered: May 2012
Location: USA
|
Junior Member |
|
|
Michel,
1. I am in no AtchiveLog mode
2. result of your command
SQL> elect d.status, v.status, v.enabled from v$datafile v, dba_data_files d whe
re d.file_id = v.file# and v.file# = 5
SP2-0734: unknown command beginning "elect d.st..." - rest of line ignored.
SQL> select d.status, v.status, v.enabled from v$datafile v, dba_data_files d wh
ere d.file_id = v.file# and v.file# = 5
2
SQL> select d.status, v.status, v.enabled from v$datafile v, dba_data_files d wh
ere d.file_id = v.file# and v.file# = 5;
select d.status, v.status, v.enabled from v$datafile v, dba_data_files d where d
.file_id = v.file# and v.file# = 5
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
3. I have a snapshot of working environment that i made before starting yesterday, but even if i restore it back i have to move from old location to new due to disk space issue.
4. i have around 116 rows but copying only
THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM SWITCH_CHANGE#
---------- ---------- ------------- --------- --------------
1 106 3703009 10-MAY-12 3756201
Thanks,
Sean
|
|
|
|
|
|
|
|
| Re: ORA-01113: file 5 needs media recovery [message #554275 is a reply to message #554274] |
Fri, 11 May 2012 13:26 |
 |
Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:ORA-00279: change 3660589 generated at 05/10/2012 11:10:26 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\SPF433\ARCHIVELOG\2012_05_11\O1_MF_
1_104_%U_.ARC
ORA-00280: change 3660589 for thread 1 is in sequence #104
Have you archived log sequence 104?
You are now at sequence 107 (last archived is 106).
Have you these archived logs 104 to 106?
By the way, file status can't be active, it OFFLINE, ONLINE or RECOVER.
Also add "ENABLED" column to the query and copy and paste its execution like:
SQL> select status, enabled from v$datafile where file#=5;
STATUS ENABLED
------- ----------
ONLINE READ WRITE
Regards
Michel
[Updated on: Fri, 11 May 2012 13:29] Report message to a moderator |
|
|
|
|
|
| Re: ORA-01113: file 5 needs media recovery [message #554281 is a reply to message #554276] |
Fri, 11 May 2012 15:40 |
John Watson
Messages: 8805
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You are in noarchivelog mode: in this mode, there is no possibility of recovery, and backups (or file copies) can be made only when the databased is closed. Therefore you have no possibility of recovery. Your only option is a complete restore of the database from your last backup.
If you can't do this, there is one other possibility, that will lose all the data in the damaged files:alter database datafile 5 offline drop;
alter database open;
This is irreversible, so think carefully first.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
