Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Does Setting Transactions to a Specific Rollback Segment Affect T
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: