From kgel@ppoone.com Fri, 21 Dec 2001 14:13:59 -0800
From: Kevin Lange <kgel@ppoone.com>
Date: Fri, 21 Dec 2001 14:13:59 -0800
Subject: Does Setting Transactions to a Specific Rollback Segment Affect T
Message-ID: <F001.003E21B5.20011221140032@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: How to backup MTS database with RMAN



Hey 
gang;
  
If my developers use the large rollback segment to perform their updates to 
data, will any triggers firing on the affected tables also use that rollback 
segment ??   
<FONT face=Arial color=#0000ff 
size=2> 

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: kevin wang 
  [mailto:kwang@vivonet.com]Sent: Friday, December 21, 2001 3:40 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  How to backup MTS database with RMAN
  
  Hi, Hulmet,
  I tried.  To use RMAN on MTS database 
  environment, both database server machine and the RMAN machine(the machine you 
  run RMAN on it) should use dedicated server mode instead of shared mode. It 
  means the tnsnames.ora file on these two machines(or one machine) 
  should
  contain SERVER=DEDICATED line. Maybe only 
  application box can use shared-mode(server=shared).
  example: 
  SHAGGY =  (DESCRIPTION 
  =    (ADDRESS_LIST =      
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 
  1521))    )    (CONNECT_DATA 
  =      (SERVICE_NAME = 
  SHAGGY)      (server = 
  dedicated)    )  )
   
  Kevin Wang
  <BLOCKQUOTE dir=ltr 
  style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    ----- Original Message ----- 
    <DIV 
    style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
    <A title=Helmut.Daiminger@KirchGruppe.de 
    href="mailto:Helmut.Daiminger@KirchGruppe.de">Daiminger, Helmut 
    To: <A title=ORACLE-L@fatcity.com 
    href="mailto:ORACLE-L@fatcity.com">Multiple recipients of list ORACLE-L 
    
    Sent: Wednesday, December 19, 2001 5:25 
    AM
    Subject: How to backup MTS database 
    with RMAN
    
    Hi! 
    Since I'm pretty new to RMAN I have a rather 
    basic question: is it possible to backup databases running in multithreaded 
    server mode with RMAN? Or does this have to be dedicated server 
    mode?
    $ rman target <A 
    href="mailto:sys/yyyy@kpmgi">sys/yyyy@kpmgi rcvcat <A 
    href="mailto:rman/xxxxx@admserv">rman/xxxxx@admserv 
    Recovery Manager: Release 8.1.7.2.0 - 
    Production 
    RMAN-06005: connected to target database: 
    KPMGI (DBID=3995384462) <FONT face="Courier New" 
    size=2>RMAN-06008: connected to recovery catalog database 
    RMAN> register database; 
    RMAN-03022: compiling command: 
    register RMAN-03023: executing 
    command: register RMAN-08006: 
    database registered in recovery catalog <FONT face="Courier New" 
    size=2>RMAN-03023: executing command: full resync <FONT 
    face="Courier New" size=2>RMAN-03026: error recovery releasing channel 
    resources RMAN-00571: 
    =========================================================== <FONT 
    face="Courier New" size=2>RMAN-00569: =============== ERROR MESSAGE STACK 
    FOLLOWS =============== <FONT face="Courier New" 
    size=2>RMAN-00571: 
    =========================================================== <FONT 
    face="Courier New" size=2>RMAN-07005: error during channel cleanup 
    RMAN-07004: unhandled exception during 
    command execution on channel default <FONT face="Courier New" 
    size=2>RMAN-10035: exception raised in RPC: ORA-19550: cannot use 
    backup/restore functions while using dispatcher <FONT 
    face="Courier New" size=2>RMAN-10031: ORA-19550 occurred during call to 
    DBMS_BACKUP_RESTORE.CFILEUSECURRENT <FONT face="Courier New" 
    size=2>RMAN-03008: error while performing automatic resync of recovery 
    catalog RMAN-07004: unhandled 
    exception during command execution on channel default <FONT 
    face="Courier New" size=2>RMAN-10035: exception raised in RPC: ORA-19550: 
    cannot use backup/restore functions while using dispatcher <FONT 
    face="Courier New" size=2>RMAN-10031: ORA-19550 occurred during call to 
    DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT 
    Do I just have to take out mts_dispatchers = 
    "(protocol=TCP)" from the init.ora file? 
    This is 8.1.7.2.0 on Sun Solaris. 
    Thanks, <FONT face=Arial 
    size=2>Helmut