Batch file to create oracle dump automatically in windows

Create a .bat file in windows and write the following lines in it.

set DateStamp=%date:~-4,4%%date:~4,2%%date:~7,2%
set file_dump=fulldb_%DateStamp%.dmp
set file_log=log_%DateStamp%.log
set backup_folder=D:\autobackup
exp schema/password@localhost:1521/db19c owner=schema1 file=%backup_folder%\%file_dump% log=%backup_folder%\%file_log%

Moreover we can use windows task scheduler to run this bat file automatically and repeatedly

Oracle Inconsistent Control Files Error ORA-00214

Oracle Inconsistent Control Files Error ORA-00214 is a very common oracle database error. This posts guide to resolve the Oracle Inconsistent Control Files Error ORA-00214. These steps are both for Windows and LINUX users.

Follow the following steps if you are facing inconsistent control files error ORA-00214 in oracle database. 

Step 1 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

open the sqlplus and connect as sysdba user by the following command

conn / as sysdba

and enter password

Step 2 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

Execute the following commands

shutdown immediate;

STARTUP NOMOUNT;

Step 3 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

Execute the following commands and you may change the path of control file if any.

alter system set control_files='C:\>oracle\product\10.20.0\db10g1\CONTROL01.CTL' scope=spfile;

show parameter control_files;

shutdown immediate;

startup mount;

recover database;

alter database open;

Step 4 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

If the error of inconsistent control files continues repeat step 2 and 3. And change the control01.CTL to control02.CTL or  control03.CTL