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

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
  <A title=Helmut.Daiminger_at_KirchGruppe.de
  href="mailto:Helmut.Daiminger_at_KirchGruppe.de">Daiminger, Helmut To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">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 <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) 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:

• <FONT face="Courier New" size=2>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:
• <FONT face="Courier New" size=2>RMAN-07005: error during channel cleanup RMAN-07004: unhandled exception during command execution on channel default <FONT face="Courier New" size=2>RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher <FONT face="Courier New" size=2>RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEUSECURRENT <FONT face="Courier New" size=2>RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default <FONT face="Courier New" size=2>RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher <FONT face="Courier New" size=2>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, <FONT face=Arial size=2>Helmut