| control file backup [message #465397] |
Wed, 14 July 2010 01:36  |
younus.choudhary
Messages: 10
Registered: July 2010
Location: Hydrabad
|
Junior Member |
|
|
hi this is younus
please help me out from my database which is got damaged
problem is
i was taking backup and recovery of controlfiles
i tryed
$recover database using backup controlfile until cancel;
it shows like
linux error:unable to open file
unable to open oracle/product/10.2.0/db_1/dbs/arch1_1_61206673.dbf
which is not present is dbs directory
what can i do for this???
|
|
|
|
|
|
|
|
| Re: control file backup [message #465426 is a reply to message #465414] |
Wed, 14 July 2010 02:17  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Post what you tried.
Post you have in your backups.
Post what you have now in the database.
Post what is your archivelog mode.
Post the list of files from v$datafile.
Post the iist of log files from v$logfile.
Post the list of control files from v$parameter.
Post the content of database directories.
Read the book I mentioned, without the basics you can't do anything, recory is not a job you can guess.
regards
Michel
[Updated on: Wed, 14 July 2010 02:20] Report message to a moderator |
|
|
|
| Re: control file backup [message #465757 is a reply to message #465426] |
Thu, 15 July 2010 09:19 |
younus.choudhary
Messages: 10
Registered: July 2010
Location: Hydrabad
|
Junior Member |
|
|
i have tried but won't give correct result..
if i don't have any online redolog files and i want to perform controfile backup then what should i do ???
and each and every time it shows like
file 1 need more media recovery to be consistant...
/setup/prod/system01.dbf
i recover that one also but it shows no such file or directory
but physicaly file is there ..
and i have tried this one
after database open with resetlogs;
it shows above error
what should i do please help me out ...
|
|
|
|
|
|
| Re: control file backup [message #465760 is a reply to message #465759] |
Thu, 15 July 2010 09:27 |
|
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:what should i do please help me out ...
Michel Cadot wrote on Wed, 14 July 2010 09:17Post what you tried.
Post you have in your backups.
Post what you have now in the database.
Post what is your archivelog mode.
Post the list of files from v$datafile.
Post the iist of log files from v$logfile.
Post the list of control files from v$parameter.
Post the content of database directories.
Read the book I mentioned, without the basics you can't do anything, recory is not a job you can guess.
regards
Michel
Post what you tried means: COPY AND PASTE YOUR SQL*PLUS SESSION.
[Updated on: Thu, 15 July 2010 09:28] Report message to a moderator |
|
|
|
| Re: control file backup [message #465761 is a reply to message #465426] |
Thu, 15 July 2010 09:28 |
younus.choudhary
Messages: 10
Registered: July 2010
Location: Hydrabad
|
Junior Member |
|
|
Post what you tried.
Post you have in your backups.
Post what you have now in the database.
Post what is your archivelog mode.
Post the list of files from v$datafile.
Post the iist of log files from v$logfile.
Post the list of control files from v$parameter.
Post the content of database directories.
1)and one thing my logfile status is not present i have tried this
select group#,status,member from v$logfile;
2)my critical data which is more important for me.
3)archive log mode is enabled
4)all are datafiles are present
5)but logfiles are missing
6)all controlfiles are there
7)just a single user is there which is newly created ..
|
|
|
|
|
|
|
|
|
|
| Re: redolog file backup and recovery [message #465987 is a reply to message #465762] |
Fri, 16 July 2010 04:24 |
younus.choudhary
Messages: 10
Registered: July 2010
Location: Hydrabad
|
Junior Member |
|
|
thanks sir
i got my problem .....
but i am facing problem in my redolog files
those files are get deleted..
while opening database it shows error
ora-01589: must use resetlogs or noresetlogs option for database open
then i tried
sql>alter database open resetlogs;
error:online backup of file 1 needs more recovery to be consistent
datafile 1:'/setup/you/system.01.dbf'
can u help me how to solve it ??
and also m attached my snap shots please check out..
[Updated on: Fri, 16 July 2010 04:27] Report message to a moderator |
|
|
|
| Re: redolog file backup and recovery [message #465994 is a reply to message #465987] |
Fri, 16 July 2010 05:00 |
|
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Michel Cadot wrote on Thu, 15 July 2010 16:27Quote:what should i do please help me out ...
Michel Cadot wrote on Wed, 14 July 2010 09:17Post what you tried.
Post you have in your backups.
Post what you have now in the database.
Post what is your archivelog mode.
Post the list of files from v$datafile.
Post the iist of log files from v$logfile.
Post the list of control files from v$parameter.
Post the content of database directories.
Read the book I mentioned, without the basics you can't do anything, recory is not a job you can guess.
regards
Michel
Post what you tried means: COPY AND PASTE YOUR SQL*PLUS SESSION.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
