Posted by Mir Sayeed Hassan on 25th July 2018
Script to Delete Log Files in Oracle Database by using the Crontab Job The given script is tested in our test env The logfiles are deleTrace File i.e (,trc,.trm) , Audit File (.aud), Listener log (.trc,.trm) & .xml files In order to manage space in better way, the best practice is to clear the logs Read More
Posted in DBA Scripts | Comments Off on Script to Delete Log Files in Oracle Database by using the Crontab Job
Posted by Mir Sayeed Hassan on 15th July 2018
ORA-16072: a minimum of one standby database destination is required This error occurs in one of our production database after restore & recover in a database open stage SQL> startup mount ORACLE instance started. Total System Global Area 396726272 bytes Fixed Size 2253504 bytes Variable Size 318770496 bytes … Read more..
Posted in ORA-Error | Comments Off on ORA-16072: a minimum of one standby database destination is required
Posted by Mir Sayeed Hassan on 7th July 2018
ORA-01156: recovery or flashback in progress may need access to files [oracle@primdb onlinelog]$ !sq sqlplus / as sysdba SQL> alter database drop standby logfile group 1; alter database drop standby logfile group 1 * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files Solution: You… Read more..
Posted in ORA-Error | Comments Off on ORA-01156: recovery or flashback in progress may need access to files