| physical standby and redos log [message #125179] |
Thu, 23 June 2005 12:43  |
aline
Messages: 92
Registered: February 2002
|
Member |
|
|
hi,
sorrry first for my poor English 
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  |
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
|
|
|
|
 Re: physical standby and redos log [message #130384 is a reply to message #126519] |
Fri, 29 July 2005 12:18 |
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'
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
