Re: How to backup MTS database with RMAN

kevin wang Wed, 19 Dec 2001 11:52:24 -0800

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

Re: How to backup MTS database with RMAN

Reply via email to