Re: Does Setting Transactions to a Specific Rollback Segment Affect T

Kevin,

Look up the excellent presentation at http://www.evdbt.com/library.htm on rollbacks. It's call "Cats, Dogs and ORA-01555". There's a MS Word doc and a power point presentation.

Also look up rollbacks at Steve Adams site and Jonathan Lewis' site.

The short answer to your question is 'Maybe'.

Jared

                                                                                       
                             
                    Kevin Lange                                                        
                             
                    <kgel_at_ppoone.c       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    om>                  cc:                                           
                             
                    Sent by:             Subject:     Does Setting Transactions to a 
Specific Rollback Segment      
                    root_at_fatcity.c        Affect T                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    12/21/01 02:00                                                     
                             
                    PM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L                                                        
                             
                                                                                       
                             
                                                                                       
                             

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 ??

     -----Original Message-----
     From: kevin wang [mailto:kwang_at_vivonet.com]
     Sent: Friday, December 21, 2001 3:40 PM
     To: Multiple recipients of list ORACLE-L
     Subject: 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
      ----- Original Message -----
      From: Daiminger, Helmut
      To: 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 sys/yyyy_at_kpmgi rcvcat rman/xxxxx_at_admserv


      Recovery Manager: Release 8.1.7.2.0 - Production


      RMAN-06005: connected to target database: KPMGI (DBID=3995384462)
      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
      RMAN-03023: executing command: full resync
      RMAN-03026: error recovery releasing channel resources
      RMAN-00571:
      ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
      ===============
      RMAN-00571:
      ===========================================================
      RMAN-07005: error during channel cleanup
      RMAN-07004: unhandled exception during command execution on channel
      default
      RMAN-10035: exception raised in RPC: ORA-19550: cannot use
      backup/restore functions while using dispatcher
      RMAN-10031: ORA-19550 occurred during call to
      DBMS_BACKUP_RESTORE.CFILEUSECURRENT
      RMAN-03008: error while performing automatic resync of recovery
      catalog
      RMAN-07004: unhandled exception during command execution on channel
      default
      RMAN-10035: exception raised in RPC: ORA-19550: cannot use
      backup/restore functions while using dispatcher
      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,
      Helmut

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).