Home » RDBMS Server » Server Administration » impact of shutdown abort in backup mode
impact of shutdown abort in backup mode [message #339741] Fri, 08 August 2008 05:51 Go to next message
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,
Re: impact of shutdown abort in backup mode [message #339744 is a reply to message #339741] Fri, 08 August 2008 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
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?

0.

Quote:
Or what will be impact on the database.

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

Regards
Michel
Re: impact of shutdown abort in backup mode [message #619082 is a reply to message #339744] Thu, 17 July 2014 23:08 Go to previous messageGo to next message
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

Re: impact of shutdown abort in backup mode [message #619089 is a reply to message #619082] Fri, 18 July 2014 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
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.

Re: impact of shutdown abort in backup mode [message #619095 is a reply to message #619089] Fri, 18 July 2014 00:53 Go to previous messageGo to next message
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
Re: impact of shutdown abort in backup mode [message #619099 is a reply to message #619095] Fri, 18 July 2014 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
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

Re: impact of shutdown abort in backup mode [message #619104 is a reply to message #619099] Fri, 18 July 2014 01:45 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thanks Michel
Re: impact of shutdown abort in backup mode [message #619215 is a reply to message #339741] Sun, 20 July 2014 00:38 Go to previous message
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
Previous Topic: SQL Error: ORA-00379
Next Topic: How to verify a server
Goto Forum:
  


Current Time: Thu Dec 18 19:48:36 CST 2014

Total time taken to generate the page: 0.09433 seconds