they do "set transaction ...."?? if so, yes, as the trigger is part of
the same transaction
- Kevin Lange <kgel_at_ppoone.com> 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:ORACLE-L_at_fatcity.com>
> 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_at_kpmgi <mailto:sys/yyyy_at_kpmgi> rcvcat
> rman/xxxxx_at_admserv <mailto: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
>
>
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: wisernet100_at_yahoo.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).
Received on Fri Dec 21 2001 - 19:22:37 CST
