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 <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> om> cc: Sent by: Subject: Does Setting Transactions to a Specific Rollback Segment [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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@kpmgi rcvcat rman/xxxxx@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
