Issue taking backup
774582Jan 24 2011 — edited Jan 26 2011Hi Friends..
My os is windows sever 2003
My database version is 11gR2 64bit.. also i have also installed Oracle client 11gr2 32bit (for Toad to work)
I have developed a script that takes backup via RMAN
below is the script fullbackup.bat which in turn runs full.txt
set oracle_sid=gold
RMAN TARGET=/ @*full.txt* > C:\app\Administrator\flash_recovery_area\GOLD\BACKUPSET\full.log
Beloww is the errror log..
Recovery Manager: Release 11.1.0.6.0 - Production on Mon Jan 24 01:35:06 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12560: TNS:protocol adapter error
Steps taken to resolve it.
1)Changed sqnet.ora from NTS to NONE..and changed the script and ran again
set oracle_sid=gold
RMAN TARGET rman/rman@gold @*full.txt* > C:\app\Administrator\flash_recovery_area\GOLD\BACKUPSET\full.log
so got error RMAN 12005 AND 19550
ORA-19550: cannot use backup/restore functions while using dispatcher
Then changed tnsnames.ora for GOLD sid from SHARED to DEDICATED..
But still the error persists.. I have googled previous forums as well..but got no success.
I dont know y would this happen.it was running smoothly before today from last 2months..what happened suddenly..
If you guys can help me please..its very urgent for me as i have to take RMAN backups daily..
Hope i made my self clear enough..