OraFAQ Forum: Backup & Recovery » while taking hotback .. instance got shutdown.. how to bring it backup

Home » RDBMS Server » Backup & Recovery » while taking hotback .. instance got shutdown.. how to bring it backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

while taking hotback .. instance got shutdown.. how to bring it backup [message #261372]

Wed, 22 August 2007 07:19

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 ..

Report message to a moderator

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

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Restart your backup.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68651
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

Report message to a moderator

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you get any error after RECOVERY?

Report message to a moderator

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

Michel Cadot
Messages: 68651
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

Report message to a moderator

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

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

Report message to a moderator

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you solve your problem?

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

No.You were right.

Did you get job Wink

Report message to a moderator

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

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..

Report message to a moderator

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Good Luck for future Thumbs Up

Report message to a moderator

Previous Topic:	ORA-01152: file 1 was not restored from a sufficiently old backup
Next Topic:	how to configure RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 10:13:00 CDT 2024