| automatic transfering of arch logs. [message #150478] |
Thu, 08 December 2005 02:05  |
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
|
Member |
|
|
hello everybody
i have updated my stanby db i have copy all dbf file and redolog files to my standy db and then create new standy control file and then applied all the archie log file to standby... but my proble is my archive log from primay are not transfaring to standy automaticaly i have chacked all the standby parameter all r perfect i m trying to solve this problem since 1 month .. i found some errros in alertlog file of standby
This is the last 40 lines of alertlog file of standy dbd
STANDBY ALERT LOG FILE
ALBFCTM_LIVE:/usr5/oracle/app/oracle/admin/ETALB/bdump >tail -40 alert_ETALB.log |m
ore
Wed Dec 7 17:53:10 2005
***Warning - Executing transaction without active Undo Tablespace
RFS: No standby redo logfiles available
RFS: No standby redo logfiles created
RFS: No standby redo logfiles available
RFS: No standby redo logfiles created
Wed Dec 7 17:57:23 2005
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Dec 7 17:58:26 2005
***Warning - Executing transaction without active Undo Tablespace
Wed Dec 7 18:02:39 2005
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Dec 7 18:03:42 2005
***Warning - Executing transaction without active Undo Tablespace
Wed Dec 7 18:07:55 2005
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Dec 7 18:08:58 2005
***Warning - Executing transaction without active Undo Tablespace
RFS: No standby redo logfiles available
RFS: No standby redo logfiles created
RFS: No standby redo logfiles available
RFS: No standby redo logfiles created
Wed Dec 7 18:13:12 2005
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Dec 7 18:14:14 2005
***Warning - Executing transaction without active Undo Tablespace
Wed Dec 7 18:18:28 2005
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Dec 7 18:19:30 2005
***Warning - Executing transaction without active Undo Tablespace
Wed Dec 7 18:23:44 2005
Restarting dead background process QMN0
QMN0 started with pid=14
Wed Dec 7 18:24:46 2005
***Warning - Executing transaction without active Undo Tablespace
PRIMARY ALERT LOG FILE
ALBFCTM_LIVE:/usr5/oracle/app/oracle/admin/ETALB/bdump >tail -40 alert_ETALB.log |m
ore
Creating archive destination LOG_ARCHIVE_DEST_1: '/usr7/ETALB/arch/ETALB_40694.arc'
ARC1: Completed archiving log 1 thread 1 sequence 40694
Wed Dec 7 18:16:38 2005
Creating archive destination LOG_ARCHIVE_DEST_2: 'ETALBSTDBY'
LGWR: Error 270 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'ETA
LBSTDBY'
Wed Dec 7 18:16:58 2005
LGWR: RFS network connection re-established at host 'ETALBSTDBY'
LGWR: Error 270 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'ETA
LBSTDBY'
LGWR: Error 270 opening RFS destination for reconnect
LGWR: Error 270 creating archivelog file 'ETALBSTDBY'
Wed Dec 7 18:16:58 2005
Errors in file /usr5/oracle/app/oracle/admin/ETALB/bdump/etalb_lgwr_534.trc:
ORA-00270: error creating archive log
LGWR: Completed archiving log 2 thread 1 sequence 40696
Thread 1 advanced to log sequence 40696
Current log# 2 seq# 40696 mem# 0: /usr6/ora_dbfiles/oradata/ETALB/redo02.log
Wed Dec 7 18:16:58 2005
ARC0: Evaluating archive log 3 thread 1 sequence 40695
ARC0: Beginning to archive log 3 thread 1 sequence 40695
Creating archive destination LOG_ARCHIVE_DEST_1: '/usr7/ETALB/arch/ETALB_40695.arc'
ARC0: Completed archiving log 3 thread 1 sequence 40695
Wed Dec 7 18:31:58 2005
Creating archive destination LOG_ARCHIVE_DEST_2: 'ETALBSTDBY'
LGWR: Error 270 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'ETA
LBSTDBY'
Wed Dec 7 18:32:18 2005
LGWR: RFS network connection re-established at host 'ETALBSTDBY'
LGWR: Error 270 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'ETA
LBSTDBY'
LGWR: Error 270 opening RFS destination for reconnect
LGWR: Error 270 creating archivelog file 'ETALBSTDBY'
Wed Dec 7 18:32:18 2005
Errors in file /usr5/oracle/app/oracle/admin/ETALB/bdump/etalb_lgwr_534.trc:
ORA-00270: error creating archive log
LGWR: Completed archiving log 1 thread 1 sequence 40697
Thread 1 advanced to log sequence 40697
Current log# 1 seq# 40697 mem# 0: /usr6/ora_dbfiles/oradata/ETALB/redo01.log
Wed Dec 7 18:32:18 2005
ARC1: Evaluating archive log 2 thread 1 sequence 40696
ARC1: Beginning to archive log 2 thread 1 sequence 40696
Creating archive destination LOG_ARCHIVE_DEST_1: '/usr7/ETALB/arch/ETALB_40696.arc'
ARC1: Completed archiving log 2 thread 1 sequence 40696
plz help me solve this problem.....
|
|
|
|
| Re: automatic transfering of arch logs. [message #151822 is a reply to message #150478] |
Mon, 19 December 2005 06:30  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I had seen your problem ---> What i want to tell u is as below
on the standby location, log transport services use the following processes
Remote file server (RFS)- This process receives redologs from primary database.
Archive Process (ARC)- this process archive the standby redo logs when standby redo logs & LGWR are used.
The action that you have to take is --> make sure the directory you have specified is a valid directory/file specification.
Environment variable are not defined for remote SQL*Net connections. Since redo logs are transmitted from the primary to the standby database over SQL*Net, this error makes sense in the context of standby database. since environment variable cannot be expanded, the solution, of course, is to replace the environment variable with its expanded equivalent.
You must ensure that the operating system network infrastructure between sites will support the redo traffic. Because the redo logs on the production database update the physical standby database, your network infrastructure must have sufficient bandwidth to handle the maximum redo traffic at peak load.
Please set the proper parameter in parameter file at primary database and standby database.
Regards
Sunilkumar
[Updated on: Mon, 19 December 2005 06:31] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
