Home » Server Options » Data Guard » text getting automatically wrapped
text getting automatically wrapped [message #137879] Sun, 18 September 2005 07:59 Go to next message
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
Re: text getting automatically wrapped [message #138065 is a reply to message #137879] Mon, 19 September 2005 15:06 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Not sure I understand what you are saying. Can you post an example?

Best regards.

Frank
Re: text getting automatically wrapped [message #138119 is a reply to message #138065] Tue, 20 September 2005 04:01 Go to previous message
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
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:
  


Current Time: Thu Mar 28 08:49:10 CDT 2024