OraFAQ Forum: Data Guard » text getting automatically wrapped

Home » Server Options » Data Guard » text getting automatically wrapped

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

text getting automatically wrapped [message #137879]

Sun, 18 September 2005 07:59

lallmanish
Messages: 28
Registered: September 2005

Junior Member

hi

i am using oracle 10g-10.1.0.3 database and i have configured a
oracle dataguard recently.
recently my sql plus envt variable is behaving differently as the columns are getting wrapped and as i removed the parameters
related to dataguard,the result set started coming in one line.
i am surprised and unable to get a clue as what should be done?/

any suggestions welcome
regards
manish

Report message to a moderator

Re: text getting automatically wrapped [message #138065 is a reply to message #137879]

Mon, 19 September 2005 15:06

Frank Naude
Messages: 4595
Registered: April 1998

Senior Member

Not sure I understand what you are saying. Can you post an example?

Best regards.

Frank

Report message to a moderator

Re: text getting automatically wrapped [message #138119 is a reply to message #138065]

Tue, 20 September 2005 04:01

lallmanish
Messages: 28
Registered: September 2005

Junior Member

yeah sure

see earlier when i used to issue
select tstm_itemcode,substr(tstm_itemdesc,1,25) from tstockmast
where tstm_itemcode='A4PPR' and tstm_divcode='23' and tstm_compcode='01';

i could see the result as
TSTM_ITEMCODE SUBSTR(TSTM_ITEMDESC,1,25
--------------- -------------------------
A4PPR PAPER A4 SIZE

then i had configured data guard. and now i used the same command
sql>TSTM_ITEMCODE
---------------
SUBSTR(TSTM_ITEMDESC,1,25
-------------------------
MHDA4PPR PAPER A4 SIZE (MHD)

i get the result this way.
gain i removed those parameters
alter system reset fal_server
alter system reset fal_client
alter system reset standby_archive_dest
alter system reset log_archive_dest_3
alter system reset log_archive_dest_state_3
and now the result is
TSTM_ITEMCODE SUBSTR(TSTM_ITEMDESC,1,25
--------------- -------------------------
A4PPR PAPER A4 SIZE

strange??//

also frank i am facing one big problem with my main dataguard
connected to the production.
it was running properly and applying the logs with mrpo process running.
a couple of days befor there was a complete trip at the primary site. and now as i try to
use sql> alter database recover managed standby database using current logfile disconnect;
and select process,status,client_process from v$managed_standby
it shows mrp0
and after 1 minutes
it seems like that it gets killed and my recovery_mode starts
showing idle.i can see a lot of archives not applied and even if i try using media recovery it is not applied .
rather it asks at managed recovery mode not active- so i had to again put in the
managed recovery mode and then perform media recovery but no
use- none of the archive has applied
pllz help[ me

manish
manishlall@mhd.co.om

Report message to a moderator

Previous Topic:	PROCESS LGWR NOT SHOWING IN MANAGED RECOVERY MODE SUDDENLY
Next Topic:	Error while executing alter database recover standby database until cancel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 09:25:21 CDT 2025