Re: [Networker] SSID Issue

What version of Oracle/RMAN and NNO are you using. With 10gR2 and RMAN
4.2 our script looks like:

run {
        set command id to 'OTAPROD';

        allocate channel t1 type 'SBT_TAPE' parms
'ENV=(NSR_DATA_VOLUME_POOL=OTAFull,NSR_FXBUSY_RETRIES=720)';

        backup database force format='%d_DATA_%U'
        plus archivelog force format='%d_ARCH_%U'
        delete all input;

        release channel t1;
        }
 

The force is there because we do a full backup every night and we are
paranoid.

----
Matthew Huff       | One Manhattanville Rd
OTA Management LLC | Purchase, NY 10577
www.otaotr.com     | Phone: 914-460-4039
aim: matthewbhuff  | Fax:   914-460-4139   




-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Chozhiyar Kulangara, Abul Khasim [OS-IE]
Sent: Friday, October 05, 2007 9:36 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] SSID Issue

Hi Matthew,


My RMAN command include one channel allocation command and following
backup commands 

backup database format '%d.%s.%p';
backup current controlfile format '%d.%s.controlfile';
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

Thanks
Abul.


-----Original Message-----
From: Matthew Huff [mailto:mhuff AT ox DOT com] 
Sent: Friday, October 05, 2007 7:01 PM
To: EMC NetWorker discussion; Chozhiyar Kulangara, Abul Khasim [OS-IE]
Subject: RE: [Networker] SSID Issue

What's your RMAN script look like? 


----
Matthew Huff       | One Manhattanville Rd
OTA Management LLC | Purchase, NY 10577
www.otaotr.com     | Phone: 914-460-4039
aim: matthewbhuff  | Fax:   914-460-4139   




-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Chozhiyar Kulangara, Abul Khasim [OS-IE]
Sent: Friday, October 05, 2007 9:25 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] SSID Issue
Importance: High

Hi,

When I trying to backup one database using RMAN it failed with message
 "already exists: ssid 1291435470".

Can anyone know why it is happening and is there any chance to take the
backup without deleting existing ssid.

Note:  Checked and found that this ssid is used for old save set of same
database.




Pasted RMAN log messages

RMAN-03009: failure of backup command on sbt4 channel at 10/05/2007
00:03:48
ORA-19506: failed to create sequential file, name="RGMADEV2.522.1",
parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   nwora_open_backup: backup file XXXXXX.522.1 already exists: ssid
1291435470



Thanks
Abul
INDIA

To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER