Home » RDBMS Server » Server Administration » Oracle 12c (12.1.0.2 SE) together with Windows 10 "Fast Startup" option (Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit, Windows 10 (Build 1607))
Oracle 12c (12.1.0.2 SE) together with Windows 10 "Fast Startup" option [message #666920] Fri, 01 December 2017 04:48 Go to next message
Mx
Messages: 2
Registered: November 2017
Junior Member
We run a system (PC which is built into a production machine) with Windows 10 and "Fast Startup" option enabled ( see tenforums 4189-turn-off-fast-startup-windows-10-a.html ). That RDBMS version is basically certified for Win10.

I already consulted Oracle documentation to find out whether there is an issue with "Fast Startup" in respect to data reliability but I couldn't find anything about that.

Has somebody experiences with Windows 10 "Fast startup" feature in conjunction with Oracle 12c?

The reason why we switched "Fast startup" on: The former version of the product ran Oracle 11.2.x which performs ways faster than 12.1 when shutting down (shutdown immediate) and starting up. No idea why 12c is so much slower (we see a difference of approx. 20 seconds 10 vs. 30 seconds). Since we are backed up by a UPS and have to deal with power-loss situations, 20 seconds longer is a no-go for us.

Re: Oracle 12c (12.1.0.2 SE) together with Windows 10 "Fast Startup" option [message #666921 is a reply to message #666920] Fri, 01 December 2017 05:28 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I don't see why Fast Startup would have anything to do with the database startup. The DB shutdown occurs before the Windows shutdown, and the DB startup occurs after the Windows startup. Furthermore, I don't understand what a UPS has to do with this. Sorry to be dense, but can you explain?

If your problem is simply that the DB shutdown and startup takes too long, that can probably be fixed. For shutdown you could adjust the service under which the Oracle instance runs to perform a SHUTDOWN ABORT rather than a SHUTDOWN IMMEDIATE. You'll see this in the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraDB12Home1. To speed up the startup, you'll need to post the relevant section of the alert log to see where the time is going.
Re: Oracle 12c (12.1.0.2 SE) together with Windows 10 "Fast Startup" option [message #666923 is a reply to message #666920] Fri, 01 December 2017 06:29 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Mx wrote on Fri, 01 December 2017 04:48
Since we are backed up by a UPS and have to deal with power-loss situations, 20 seconds longer is a no-go for us.

If an extra 20 seconds pushes your UPS over the edge, I'd say you are already living too close to the edge and need to upgrade your UPS -- regardless of any Windows or Oracle issues.
Re: Oracle 12c (12.1.0.2 SE) together with Windows 10 "Fast Startup" option [message #666982 is a reply to message #666923] Mon, 04 December 2017 04:36 Go to previous messageGo to next message
Mx
Messages: 2
Registered: November 2017
Junior Member
Additional explanation

We have some strange restrictions on our maschine for startup.
The customer want to start the machine and be enabled to process within < 60 sec.
The additonal 20 sec Oracle 12c on Windows 10 needs are criticized by customer and product management.

In case of power fail the ups is used to have enough time to shutdown immediate without data loss.
But on restart the database always need to long to meet our customer requieremnets (which are very strange).

Therefore we decided to use Windows 10 "Fast startup".

Our question is has somebody experience with this configration.
Are the known issues with data reliabiliy with this configuration.

Re: Oracle 12c (12.1.0.2 SE) together with Windows 10 "Fast Startup" option [message #666983 is a reply to message #666982] Mon, 04 December 2017 04:42 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Perhaps you need to go through this with an Oracle DBA. He will explain two things:

First, the Fast Start has nothing to do with the database startup.
Second, if the machine dies because of a power failure, there will be no loss of data.
Previous Topic: PDB upgrade and exclusion lists
Next Topic: global temporay table does not work!
Goto Forum:
  


Current Time: Fri Mar 29 00:54:51 CDT 2024