Technical articles address issues in various databases especially Oracle, MySQL, PostgreSQL. Also, various lessons to show how to tune database performance and security, or solve a problem.
Operating system crashes are one of the issues that might face you especially if your server is using windows. This article explains how backup oracle database from windows safe mode. and by example, I will explain the steps to start oracle in windows safe mode and backup it up.
Unfortunately, If you try to start the Oracle database while your Windows OS was in safe mode, It will fail giving an error message
Error 1058: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
Also, if you tried to use the command line by starting the instances or listener you will get the Listner error
TNS-12500 TNS: protocol adapter error. TNS-00530: Protocol adapter error
Enable Oracle Service.
Change the Oracle service status, This will enable you to start the oracle database in safe mode. In this example Oracle database instance is ORCL, and as a result, the service name is Oracle ServiceORCL.
You can use either Command line interface, execute the following command
sc config OracleServiceORCL start=auto
Or if you prefer using Windows graphical interface, then follow these steps to enable Oracle services in Windows services
Right-click on start windows then click on Computer Management.
In the right-side panel expand Service and Applications, then click Service Link.
On the left side, make sure that the Oracle database and listener services are not disabled. To enable the services, double-click to open OracleServicesORCL properties then select manual from the startup type drop-down menu.
Repeat the process for the listener service.
Configure the service to run on windows safe mode.
add the following entries to the windows registry, allowing the Oracle services to run in Operating system safe mode.
REG ADD "HKLM\SYSTEM\CurrentControlSet\Control\SafeBoot\Network\OracleServiceORCL" /VE /T REG_SZ /F /D "Service" REG ADD "HKLM\SYSTEM\CurrentControlSet\Control\SafeBoot\Minimal\OracleServiceORCL" /VE /T REG_SZ /F /D "Service"
Start oracle database
It’s essential to have your oracle database running to take a backup of the data you can start the service from the Computer management graphical interface. Just right-click on the service name then choose start.
or execute the following command from the Command prompt
net start OracleServiceORCL
To confirm that oracle is started. try to log in using sqlplus
sqlplus / as sysdba
Backup oracle database in safe mode:
To export the full database execute the following command
expdp directory=dump full=Y dumpfile=lastbackup_YYYYMMDD.dmp logfile=lastbackup_YYYYMMDD.log
This command used the database object directory named dump to save the database dump.
To create a directory using the following SQL statement.
SQL> CREATE DIRECTORY dump AS 'd:\dump_dir';
In Conclusion, If you were able to log in to your system in “Windows” safe mode, you will be able to back up the Oracle database from windows safe mode and recover your data from the database. follow the simple instruction mentioned earlier.