| Urgent Help [message #402417] |
Sun, 10 May 2009 03:09  |
bro000
Messages: 3
Registered: May 2009
|
Junior Member |
|
|
Hi every one,
I try to open database but I found this errors:
ORA-01172: recovery of thread 1 stuck at block 25 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed
I need the help to solve this problem and I don't Know how I can recover the file and where I found this file?
thanks, 
|
|
|
|
|
|
| Re: Urgent Help [message #402420 is a reply to message #402417] |
Sun, 10 May 2009 03:34  |
bro000
Messages: 3
Registered: May 2009
|
Junior Member |
|
|
first i don't know from the error what is file name and in Oacle file I have 3 Backup file . How I can recover it? please explain to me by steps.
Thanks for your greet help
|
|
|
|
|
|
| Re: Urgent Help [message #402423 is a reply to message #402417] |
Sun, 10 May 2009 04:08 |
bro000
Messages: 3
Registered: May 2009
|
Junior Member |
|
|
I don't made any bakeup but I don't use this database from long time
I typed in Dos command :
Select * from V$datafile; and below the result:
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
------------------------------------
FIRST_NONLOGGED_SCN FIRST_NON
------------------- ---------
0 8192
FILE# CREATION_CHANGE# CREATION
---------- ---------------- --------
CHECKPOINT_CHANGE# CHECKPOIN UNRECOV
------------------ --------- -------
LAST_TIME OFFLINE_CHANGE# ONLINE_CHA
--------- --------------- ----------
CREATE_BYTES BLOCK_SIZE
------------ ----------
NAME
------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
------------------------------------
FIRST_NONLOGGED_SCN FIRST_NON
------------------- ---------
NONE
FILE# CREATION_CHANGE# CREATION
---------- ---------------- --------
CHECKPOINT_CHANGE# CHECKPOIN UNRECOV
------------------ --------- -------
LAST_TIME OFFLINE_CHANGE# ONLINE_CHA
--------- --------------- ----------
CREATE_BYTES BLOCK_SIZE
------------ ----------
NAME
------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
------------------------------------
FIRST_NONLOGGED_SCN FIRST_NON
------------------- ---------
0
FILE# CREATION_CHANGE# CREATION
---------- ---------------- --------
CHECKPOINT_CHANGE# CHECKPOIN UNRECOV
------------------ --------- -------
LAST_TIME OFFLINE_CHANGE# ONLINE_CHA
--------- --------------- ----------
CREATE_BYTES BLOCK_SIZE
------------ ----------
NAME
------------------------------------
PLUGGED_IN BLOCK1_OFFSET
---------- -------------
AUX_NAME
------------------------------------
FIRST_NONLOGGED_SCN FIRST_NON
------------------- ---------
|
|
|
|
| Re: Urgent Help [message #402427 is a reply to message #402423] |
Sun, 10 May 2009 06:06 |
 |
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
This is unreadable.
Format your query and result, only display relevant column (so not select *).
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).
Remember:
| Quote: | Steps depend on how you take your backups and which ones you have.
|
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
