Home » Server Options » Data Guard » physical standby and redos log
physical standby and redos log [message #125179] Thu, 23 June 2005 12:43 Go to next message
aline
Messages: 92
Registered: February 2002
Member
hi,

sorrry first for my poor English Embarassed

I have a little question about standby

When I created once in the past, I copied all source files including redos log.

But If I understand well, there is no need for redos.

Is this true?
In this case, how the standby could live without redos??

And if I don't copy them, how the standby make during a switch or failover? If we are in maximum performance, there is a need to copy redos during a crash for example?

thk in advance,

[Updated on: Thu, 23 June 2005 12:44]

Report message to a moderator

Re: physical standby and redos log [message #126519 is a reply to message #125179] Tue, 05 July 2005 06:18 Go to previous messageGo to next message
spanek
Messages: 21
Registered: May 2005
Junior Member
Hi,
so first of all you do not need Redolog Files !

If you work in maximum performance mode you don't need STANDBY Redolog Files but it is possible that you loose data during an failover.

For Maximum Protection, Availability you need to create Standby Redologs !

regards

Stefan



icon1.gif  Re: physical standby and redos log [message #130384 is a reply to message #126519] Fri, 29 July 2005 12:18 Go to previous message
aline
Messages: 92
Registered: February 2002
Member
So, I tried to use standby redos logs with lgwr process for log apply service. (my first try with the ARCH process are very good).

But I have some problems with standby redos logs. Only one of 8 work!

So this is the code for standby log creation and the alert file.
Someone could explain me why only one redo is actually working?

Quote:


ALTER DATABASE ADD STANDBY LOGFILE group 9 '/opt/oracle/oradata/TEST/srl1.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE group 10 '/opt/oracle/oradata/TEST/srl2.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE group 11 '/opt/oracle/oradata/TEST/srl3.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE group 12 '/opt/oracle/oradata/TEST/srl4.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE group 13 '/opt/oracle/oradata/TEST/srl5.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE group 14 '/opt/oracle/oradata/TEST/srl6.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE group 15 '/opt/oracle/oradata/TEST/srl7.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE group 16 '/opt/oracle/oradata/TEST/srl8.f' SIZE 104857600;



Quote:


Fri Jul 29 18:42:00 2005
ARC1: Archive log thread 1 sequence 658 available in 10 minute(s)
ARC1: Completed archiving log 9 thread 1 sequence 658
Fri Jul 29 18:42:00 2005
RFS: Successfully opened standby logfile 9: '/opt/oracle/oradata/TEST/srl1.f'
Fri Jul 29 18:43:30 2005
ARC1: Evaluating archive log 9 thread 1 sequence 659
ARC1: Beginning to archive log 9 thread 1 sequence 659
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/oradata/TEST/archives/659.arc'
Fri Jul 29 18:43:30 2005
ARC1: Archive log thread 1 sequence 659 available in 10 minute(s)
ARC1: Completed archiving log 9 thread 1 sequence 659
Fri Jul 29 18:43:30 2005
RFS: Successfully opened standby logfile 9: '/opt/oracle/oradata/TEST/srl1.f'
Fri Jul 29 18:44:34 2005
ARC1: Evaluating archive log 9 thread 1 sequence 660
ARC1: Beginning to archive log 9 thread 1 sequence 660
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/oradata/TEST/archives/660.arc'
Fri Jul 29 18:44:34 2005
ARC1: Archive log thread 1 sequence 660 available in 10 minute(s)
ARC1: Completed archiving log 9 thread 1 sequence 660
Fri Jul 29 18:44:34 2005
RFS: Successfully opened standby logfile 9: '/opt/oracle/oradata/TEST/srl1.f'
Fri Jul 29 18:45:34 2005
ARC1: Evaluating archive log 9 thread 1 sequence 661
ARC1: Beginning to archive log 9 thread 1 sequence 661
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/oradata/TEST/archives/661.arc'

Previous Topic: Delete applyed archive log
Next Topic: Failover didn't quite work... what am I missing?
Goto Forum:
  


Current Time: Thu Mar 28 16:08:59 CDT 2024