OraFAQ Forum: Server Administration » redo transport services

Home » RDBMS Server » Server Administration » redo transport services

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

redo transport services [message #282108]

Tue, 20 November 2007 22:31

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

hi,
How can I be sure that, my redo transport services has been enable and LGWR is transferring on another machine??

thanx.

Report message to a moderator

Re: redo transport services [message #282110 is a reply to message #282108]

Tue, 20 November 2007 22:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can I be sure that, my redo transport services has been enable and LGWR is transferring on another machine??

By looking on the "remote" system in the destination directory for files with "current" timestamps.

Report message to a moderator

Re: redo transport services [message #282124 is a reply to message #282108]

Tue, 20 November 2007 23:35

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

Sorry, I didnt understand.

Report message to a moderator

Re: redo transport services [message #282126 is a reply to message #282108]

Tue, 20 November 2007 23:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Can you see that recent redo log files get to the "other system"?

Report message to a moderator

Re: redo transport services [message #282134 is a reply to message #282108]

Tue, 20 November 2007 23:53

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

ya...I do. then......

thanx

Report message to a moderator

Re: redo transport services [message #282136 is a reply to message #282134]

Tue, 20 November 2007 23:54

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ya...I do. then...... ? you sure that redo log is transfer to remote desktop.

Report message to a moderator

Re: redo transport services [message #282154 is a reply to message #282108]

Wed, 21 November 2007 00:45

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

source:

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DS02.BD.NET LGWR ASYNC OPTIONAL NOREGISTER
VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE)' SCOPE=SPFILE;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=SPFILE;
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='send' SCOPE=SPFILE;

destination:

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=/home/arc_dest/srl_dbs1 MANDATORY 
VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)' SCOPE=SPFILE;

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='receive' SCOPE=SPFILE;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=SPFILE;

this is what I have done.

[Updated on: Wed, 21 November 2007 01:42] by Moderator

Report message to a moderator

Re: redo transport services [message #282158 is a reply to message #282154]

Wed, 21 November 2007 00:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Verify the Physical Standby Database Is Performing Properly
On the standby database

SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

Force a log switch to archive the current online redo log file.
On the primary database

ALTER SYSTEM ARCHIVE LOG CURRENT;

Verify the new redo data was archived on the standby database.

SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

Verify new archived redo log files were applied.

SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG
ORDER BY SEQUENCE#;

http://download.oracle.com/docs/cd/B14117_01/server.101/b10823/log_transport.htm#1148215

Report message to a moderator

Re: redo transport services [message #282182 is a reply to message #282108]

Wed, 21 November 2007 01:33

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

the output of every query is "no rows selected."

any other suggession???

Report message to a moderator

Re: redo transport services [message #282185 is a reply to message #282182]

Wed, 21 November 2007 01:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Are you sure ?
1. your database running in archivelog mode ?
2. did you properly configure standby database?

Report message to a moderator

Re: redo transport services [message #282186 is a reply to message #282185]

Wed, 21 November 2007 01:46

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

yap, this s in archived mode.
But.. confused abt the second 1. I need to configure a downstream stream configuration, thats why I did that.

thanx.

Report message to a moderator

Re: redo transport services [message #282206 is a reply to message #282108]

Wed, 21 November 2007 03:08

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

What is the output of the query?

select state from v$streams_capture;

Report message to a moderator

Previous Topic:	Database is not mounted
Next Topic:	WARNING: db_create_file_dest is same as db_recovery_file_dest

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:44:23 CST 2024