OraFAQ Forum: Server Administration » impact of shutdown abort in backup mode

Home » RDBMS Server » Server Administration » impact of shutdown abort in backup mode

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

impact of shutdown abort in backup mode [message #339741]

Fri, 08 August 2008 05:51

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I would like ask one thing in one scenario.

My database is in archivelog mode.
Hot backup is going on 50% tablespaces are under backup mode.
What happens if someone executes SHUTDOWN ABORT.
How much % of data loss will occurs?
Or what will be impact on the database.

Thanks,

Report message to a moderator

Re: impact of shutdown abort in backup mode [message #339744 is a reply to message #339741]

Fri, 08 August 2008 05:58

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

Senior Member
Account Moderator

Quote:

What happens if someone executes SHUTDOWN ABORT.

The instances shut down.

Quote:

How much % of data loss will occurs?

Quote:

Or what will be impact on the database.

None. You just have to back the backup mode to off.

Regards
Michel

Report message to a moderator

Re: impact of shutdown abort in backup mode [message #619082 is a reply to message #339744]

Thu, 17 July 2014 23:08

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi Michel,
Quote:

None. You just have to back the backup mode to off.

Can you explain what does the above one mean?

Regards,
Srini

Report message to a moderator

Re: impact of shutdown abort in backup mode [message #619089 is a reply to message #619082]

Fri, 18 July 2014 00:45

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

Senior Member
Account Moderator

Typo, it is:
None. You just have to reset the backup mode to off.

Report message to a moderator

Re: impact of shutdown abort in backup mode [message #619095 is a reply to message #619089]

Fri, 18 July 2014 00:53

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi Michel,
Quote:

None. You just have to reset the backup mode to off.

How it is done and does it applies for hot backup or cold backup as well or only when you perform shutdown abort?

Regards,
Srini

Report message to a moderator

Re: impact of shutdown abort in backup mode [message #619099 is a reply to message #619095]

Fri, 18 July 2014 01:05

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

Senior Member
Account Moderator

If you use RMAN, and I advise you to do it, you have to take care about this option.
If you want to know more, refer to the documentation.
Database Backup and Recovery Basics

Report message to a moderator

Re: impact of shutdown abort in backup mode [message #619104 is a reply to message #619099]

Fri, 18 July 2014 01:45

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thanks Michel

Report message to a moderator

Re: impact of shutdown abort in backup mode [message #619215 is a reply to message #339741]

Sun, 20 July 2014 00:38

GirishSharma
Messages: 22
Registered: March 2010

Junior Member

Why to ask, why not try, see and learn on a test db ?

Simple answer is if you gets some data loss, then answer is Yes, there is N% data loss, else 0%.

Regards
Girish Sharma

Report message to a moderator

Previous Topic:	SQL Error: ORA-00379
Next Topic:	How to verify a server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 01 06:10:48 CDT 2023