Author Archives: Sher khan

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com

ORA-01113: file 1 needs media recovery

Posted on November 28, 2023 by Sher khan

After Database restore SQL> ALTER DATABASE OPEN RESETLOGS;ALTER DATABASE OPEN RESETLOGS*ERROR at line 1:ORA-01113: file 1 needs media recoveryORA-01110: data file 1: ‘C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF’ SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;ORA-00279: change 5578888 generated at 11/28/2023 07:56:27 needed for thread … Continue reading →

Posted in Uncategorized | Leave a comment

Chnage the Path for the mdf and ldf file while Creating a SQL Database

Posted on January 31, 2019 by Sher khan

To change the default path for mdf and ldf files in SQL ServerUSE [master] GO EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’DefaultData’, REG_SZ, N’F:\Data\DB05′ GO EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’DefaultLog’, REG_SZ, N’F:\Data\DB05′ GO

Posted in SQL Server, Uncategorized | Leave a comment