Home » RDBMS Server » Backup & Recovery » while taking hotback .. instance got shutdown.. how to bring it backup
while taking hotback .. instance got shutdown.. how to bring it backup [message #261372] Wed, 22 August 2007 07:19 Go to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

1) While taking hot backup .. there was a power issue and the system was shutdown how to bring it backup ..



Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261377 is a reply to message #261372] Wed, 22 August 2007 07:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restart your backup.

Regards
Michel
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261434 is a reply to message #261377] Wed, 22 August 2007 10:34 Go to previous messageGo to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

You mean i donot need to recover first .. since the database was in backup mode .. I think database will not be consitent as the backup was going on .
I am not a very much experienced guy but this is what i did ..also i firmly think this is the solution .. now that i have tried

I just tried it worked ..
what i did was
>startup mount
>select * from v$recover_file
this displayed which all files needed recovery
>alter database recover datafile 1,2,3,4

then the recovery was complete.

Finally

> alter database open

...

please some help me if there is another solution

Regards
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261446 is a reply to message #261434] Wed, 22 August 2007 11:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No. This is the way to do it.
You have to "alter database end backup" if you don't want to backup again. Otherwise, restart your backup.
Files are in "recovery needed" state because they were in backup mode but database is OK as you saw it when you executed the "recover" command. Oracle just verifies that the files are fine (maybe makes a little bit of work).

Regards
Michel

Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261452 is a reply to message #261446] Wed, 22 August 2007 11:37 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you get any error after RECOVERY?
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261469 is a reply to message #261452] Wed, 22 August 2007 12:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I assumed that:
Quote:
>alter database recover datafile 1,2,3,4

then the recovery was complete.

Finally

> alter database open

means it was OK but maybe I'm wrong.

Regards
Michel
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261489 is a reply to message #261469] Wed, 22 August 2007 15:18 Go to previous messageGo to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

Thanks everyone for immediate reply..
you are awesome.. i didnot expect some one to look into this so quickly...

Regards
shah
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261490 is a reply to message #261489] Wed, 22 August 2007 15:19 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Question Did you solve your problem?
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261491 is a reply to message #261452] Wed, 22 August 2007 15:20 Go to previous messageGo to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

DreamzZ wrote on Wed, 22 August 2007 22:07
Did you get any error after RECOVERY?



after recovery i didnot get any error. i could find all my latest transactions.
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261492 is a reply to message #261372] Wed, 22 August 2007 15:22 Go to previous messageGo to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

This question was actually asked in an interview .. so this should be the answer right.. or do i need to add anything to it

Shah
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261494 is a reply to message #261492] Wed, 22 August 2007 15:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
No.You were right.

Did you get job Wink
icon8.gif  Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261495 is a reply to message #261494] Wed, 22 August 2007 15:43 Go to previous messageGo to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

I could not recollect all these steps in the interview.. i just said i would simply startup the database.. the interviewer asked me are you sure you would just start the database.. i said yes.. then said i would start in mount stage and try to perform recovery.

I waiting the reply ... the interviewer said he will give his feedback to HR.. not sure i keeping my fingers crossed..

there are some other questions which i did not answer..
Re: while taking hotback .. instance got shutdown.. how to bring it backup [message #261496 is a reply to message #261495] Wed, 22 August 2007 15:51 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Good Luck for future Thumbs Up
Previous Topic: ORA-01152: file 1 was not restored from a sufficiently old backup
Next Topic: how to configure RMAN
Goto Forum:
  


Current Time: Wed Dec 07 22:20:36 CST 2016

Total time taken to generate the page: 0.10845 seconds