Home » RDBMS Server » Backup & Recovery » control file backup (oracle 10g)
control file backup [message #465397] Wed, 14 July 2010 01:36 Go to next message
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 #465406 is a reply to message #465397] Wed, 14 July 2010 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First restore, then recover.

You should read Database Backup and Recovery Basics.

Regards
Michel
Re: control file backup [message #465414 is a reply to message #465406] Wed, 14 July 2010 02:02 Go to previous messageGo to next message
younus.choudhary
Messages: 10
Registered: July 2010
Location: Hydrabad
Junior Member
thanks ..
but i have tried all these things it won't work
please help me out..
Re: control file backup [message #465426 is a reply to message #465414] Wed, 14 July 2010 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 #465759 is a reply to message #465757] Thu, 15 July 2010 09:24 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.
Re: control file backup [message #465760 is a reply to message #465759] Thu, 15 July 2010 09:27 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what should i do please help me out ...

Michel Cadot wrote on Wed, 14 July 2010 09:17
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


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 Go to previous messageGo to next message
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: control file backup [message #465762 is a reply to message #465761] Thu, 15 July 2010 09:30 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't tell, POST YOUR SESSION THAT SHOWS WHAT YOU DO AND GET.

Regards
Michel
Re: control file backup [message #465764 is a reply to message #465762] Thu, 15 July 2010 09:34 Go to previous messageGo to next message
younus.choudhary
Messages: 10
Registered: July 2010
Location: Hydrabad
Junior Member
do u have any mail id ??
so on that i can easily send my sessions..

my mail id :c.k.younusdba@gmail.com
Re: control file backup [message #465771 is a reply to message #465764] Thu, 15 July 2010 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: redolog file backup and recovery [message #465987 is a reply to message #465762] Fri, 16 July 2010 04:24 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 15 July 2010 16:27
Quote:
what should i do please help me out ...

Michel Cadot wrote on Wed, 14 July 2010 09:17
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


Post what you tried means: COPY AND PASTE YOUR SQL*PLUS SESSION.


Previous Topic: Query on RMAN backup retention policy
Next Topic: RMAN backup on Windows 2008
Goto Forum:
  


Current Time: Sat Oct 25 09:51:55 CDT 2014

Total time taken to generate the page: 0.05647 seconds