RE: How to backup MTS database with RMAN

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 19 Dec 2001 08:31:21 -0800
Message-ID: <F001.003E0310.20011219080025@fatcity.com>

Helmut,

From
the Oracle Documentation:

To use RMAN with an MTS
database:
Net8 configuration varies greatly
from system to system. The following procedure illustrates only one method.

This scenario assumes that the
following net service name in the tnsnames.ora file connects to the target database using the MTSarchitecture, where inst1 is a value of the SERVICE_NAMES initialization parameter:

inst1_mts =

(description=    
(address=(protocol=tcp)(host=inst1_host)(port1521))    
(connect_data=(service_name=inst1)(server=shared))  )

   1.Create a net service

name in the tnsnames.ora file that connects to the non-shared SID. For example, enter:
     inst1_ded

=

(description=         
(address=(protocol=tcp)(host=inst1_host)(port1521))         
(connect_data=(service_name=inst1)(server=dedicated))

)
 2.Connect using

SQL*Plus using both the MTS and dedicated service names to confirm the mode of each session. For example, to connect
to a dedicated session you can issue:

 SQL>

connect sys/oracle_at_inst1_ded
Connected. SQL> SELECT server FROM v$session WHERE sid = (SELECT DISTINCT sid FROM v$mystat);



SERVER
--------- DEDICATED 1
row selected.

To connect to an MTS session, you can
issue:

SQL> connect
sys/oracle_at_inst1_mtsConnected.SQL> SELECT server FROM v$session WHERE sid = (SELECT DISTINCT sid FROM v$mystat);

SERVER
---------SHARED 1 row selected.
Connect to the target database

(and optionally the recovery catalog) using the dedicated service name. For example, enter:

% rman target sys/oracle_at_inst1_ded
catalog rman/rman_at_rcat
HTH
Tom
Mercadante Oracle Certified
Professional

-----Original Message-----From: Daiminger, Helmut [mailto:Helmut.Daiminger_at_KirchGruppe.de]Sent: Wednesday, December 19, 2001 8:25 AMTo: Multiple recipients of list ORACLE-LSubject: 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_at_kpmgi rcvcat
 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

Received on Wed Dec 19 2001 - 10:31:21 CST