Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Does Setting Transactions to a Specific Rollback Segment Affect T

Does Setting Transactions to a Specific Rollback Segment Affect T

From: Kevin Lange <kgel_at_ppoone.com>
Date: Fri, 21 Dec 2001 14:13:59 -0800
Message-ID: <F001.003E21B5.20011221140032@fatcity.com>

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_at_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">

    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_at_kpmgi">sys/yyyy_at_kpmgi rcvcat <A     href="mailto:rman/xxxxx_at_admserv">rman/xxxxx_at_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:

Received on Fri Dec 21 2001 - 16:13:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US