Thursday, November 26, 2015

ORA-00354: corrupt redo log block header

If you see ORA-00354 in your alert log file, as can be seen bellow
Tue Nov 24 14:36:25 2015
Thread 1 cannot allocate new log, sequence 16492
Private strand flush not complete
  Current log# 9 seq# 16491 mem# 0: D:\ORACLE\ORADATA\MYDB\REDO9_01.RDO
Thread 1 advanced to log sequence 16492

Sunday, November 22, 2015

RMAN-00600: internal error, arguments [9222] [] [] [] []

I faced following error message while creating a standby database from live database using RMAN DUPLICATE command.

C:\Users\administrator>rman target sys/pass11g@pri auxiliary sys/pass11g@aux

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 9 12:35:18 2015

Sunday, November 15, 2015

RMAN-05001 auxiliary filename string conflicts with a file used by the target database

If this error message is being returned during RMANDUPLICATE DATABASE command, it is because RMAN would try to created destination files at the same location where source database files exist; and since it cannot overwrite existing files, so it and returns error message. To avoid this error, NOFILENAME check option should be used with DUPLICATE command. Otherwise use one of the following to specify different file names

Wednesday, November 11, 2015

Heartbeat failed to connect to standby

If Primary database alert log is showing error message similar to the following,
PING[ARC1]: Heartbeat failed to connect to standby 'standby-db'. Error is 16058.
it means that primary database is not able to ship redo log data to

Thursday, November 5, 2015

Terminating the instance due to error 481

If you are trying to start a RAC instance and it is terminating immediately after STARTUP command, and alert log is showing following messages
MMNL started with pid=26, OS id=7068
NOTE: initiating MARK startup
Starting background process MARK