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