Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Issue taking backup

774582Jan 24 2011 — edited Jan 26 2011
Hi 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..

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 23 2011
Added on Jan 24 2011
15 comments
326 views