Home » RDBMS Server » Backup & Recovery » Urgent Help
Urgent Help [message #402417] Sun, 10 May 2009 03:09 Go to next message
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, Smile
Re: Urgent Help [message #402418 is a reply to message #402417] Sun, 10 May 2009 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You will find this file in your latest backup.
You will recover it if you have the archived logs since this backup.

Regards
Michel

[Updated on: Sun, 10 May 2009 03:15]

Report message to a moderator

Re: Urgent Help [message #402420 is a reply to message #402417] Sun, 10 May 2009 03:34 Go to previous messageGo to next message
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 #402422 is a reply to message #402420] Sun, 10 May 2009 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
File is 2, file name can be found from v$datafile.
Steps depend on how you take your backups and which ones you have.

Regards
Michel
Re: Urgent Help [message #402423 is a reply to message #402417] Sun, 10 May 2009 04:08 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: flashback database to how far back ?
Next Topic: Full backup + archive logs = redundant?
Goto Forum:
  


Current Time: Thu Dec 08 12:25:22 CST 2016

Total time taken to generate the page: 0.09356 seconds