they do "set transaction ...."?? if so, yes, as the trigger is part of the same transaction
--- Kevin Lange <[EMAIL PROTECTED]> wrote: > 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----- > Sent: Friday, December 21, 2001 3:40 PM > To: Multiple recipients of list ORACLE-L > > > 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 ----- > To: Multiple recipients of list ORACLE-L > <mailto:[EMAIL PROTECTED]> > Sent: Wednesday, December 19, 2001 5:25 AM > > > 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 <mailto:sys/yyyy@kpmgi> rcvcat > rman/xxxxx@admserv <mailto: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 > > __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
