ORA-00353: during startup of instance from archiver process

When starting one of the databases we received the ORA-00353 error. It indicates that archiver process couldn’t archive one of the redo logs due to corruption. Oracle tried to read both the logmembers from the same group but they both were corrupted and instance crashes when trying to open it. ARC0: STARTING ARCH PROCESSES COMPLETE ARCH: Log corruption near block 88727 change 12629319 time ? … Continue reading ORA-00353: during startup of instance from archiver process

DBA_HIST_DATABASE_INSTANCE

In 10g there is a view called DBA_HIST_DATABASE_INSTANCE which has database instance information. It has history on information such as instance startup time, last ASH sample id. Example: SQL> column startup_time format a35 SQL> alter session set nls_timestamp_format=’DD-MON-YYYY HH24:MI:SS’; Session altered. SQL> SELECT startup_time, last_ash_sample_id FROM dba_hist_database_instance WHERE dbid = 1992878807 order by startup_time; STARTUP_TIME LAST_ASH_SAMPLE_ID —————————— —————— 12-AUG-2009 21:12:19 447735 21-AUG-2009 17:48:29 494755 .. … Continue reading DBA_HIST_DATABASE_INSTANCE

How to tell if the database was started with spfile or pfile?

There are couple of ways of finding if the database was started with spfile or pfile. One way would be tell show the check the value of parameter spfile, if it returns blank then database was started by pfile. — belows show database was started by spfile SQL> show parameter spfile; NAME TYPE VALUE —— —— ———————————————— spfile string /u01/apps/oracle/10g/dbs/spfileorcltest.ora Another way to find would … Continue reading How to tell if the database was started with spfile or pfile?