Re: Snapshot Logfile

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

--
http://www.freelists.org/webpage/oracle-l