Home » RDBMS Server » Server Administration » redo transport services
redo transport services [message #282108] Tue, 20 November 2007 22:31 Go to next message
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.
Re: redo transport services [message #282110 is a reply to message #282108] Tue, 20 November 2007 22:37 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: redo transport services [message #282124 is a reply to message #282108] Tue, 20 November 2007 23:35 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
Sorry, I didnt understand.

Re: redo transport services [message #282126 is a reply to message #282108] Tue, 20 November 2007 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Can you see that recent redo log files get to the "other system"?
Re: redo transport services [message #282134 is a reply to message #282108] Tue, 20 November 2007 23:53 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
ya...I do. then......


thanx
Re: redo transport services [message #282136 is a reply to message #282134] Tue, 20 November 2007 23:54 Go to previous messageGo to next message
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.
Re: redo transport services [message #282154 is a reply to message #282108] Wed, 21 November 2007 00:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: redo transport services [message #282182 is a reply to message #282108] Wed, 21 November 2007 01:33 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
the output of every query is "no rows selected."

any other suggession???
Re: redo transport services [message #282185 is a reply to message #282182] Wed, 21 November 2007 01:42 Go to previous messageGo to next message
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?
Re: redo transport services [message #282186 is a reply to message #282185] Wed, 21 November 2007 01:46 Go to previous messageGo to next message
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.
Re: redo transport services [message #282206 is a reply to message #282108] Wed, 21 November 2007 03:08 Go to previous message
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;

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


Current Time: Sun Dec 11 08:32:27 CST 2016

Total time taken to generate the page: 0.04206 seconds