Re: Snapshot Logfile

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • Date: Sun, 28 Aug 2005 11:28:04 -0400

Carel,

You are right. I meant Standby logfile (not snapshot logfile). The 14 rows 
output is cut & paste mistake (it should be 12 Rows).

rule of thumb:
'(max.nr.of logfiles for each thread +1 ) * maximum number of threads.'

So in my case I should have [ (3+1)*2=8 ] Stanby logfiles. Is that right?


I can simply add 8 stanpshot logfiles as below. Right?

ALTER DATABASE ADD STANDBY LOGFILE GROUP 11 
('/u01/oradata/primary/sredo11.log') size 10M;
:
:

ALTER DATABASE ADD STANDBY LOGFILE GROUP 18 
('/u01/oradata/primary/sredo18.log') size 10M;
Thanks
Sami

Other related posts: