Home » RDBMS Server » Backup & Recovery » rman error
rman error [message #162117] Wed, 08 March 2006 18:53 Go to next message
kapil2005
Messages: 44
Registered: March 2005
Member
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch0 channel at 03/07/2006 23:16:13
ORA-19506: failed to create sequential file,
name="PPCS_al_Ukhhdd8gf_1_1_s5777_p1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
sbti_backup: Call to open_backup_session failed.

Recovery Manager complete.


The scripts was running fine for long time and all off a sudden it is giving me this error, all unix guys have done is reboot the EDM server. any help is appreciated
Thank you
Re: rman error [message #162268 is a reply to message #162117] Thu, 09 March 2006 08:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This seems to do with the MML API.
Did you check the logs on media manager?
Re: rman error [message #162279 is a reply to message #162117] Thu, 09 March 2006 09:21 Go to previous messageGo to next message
kapil2005
Messages: 44
Registered: March 2005
Member
yes, here is the
$cat sbtio.log:
SBT-10139 02/21/2006 04:55:38 E: sbti_backup: Call to open_file_for_write failed.: sbt_error=7501, ebci_error=1007.
SBT-25354 03/06/2006 19:05:56 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-25361 03/06/2006 19:05:56 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-22621 03/07/2006 16:49:09 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-22626 03/07/2006 16:49:09 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-9282 03/08/2006 16:48:14 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-9275 03/08/2006 16:48:14 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
Re: rman error [message #162280 is a reply to message #162117] Thu, 09 March 2006 09:22 Go to previous messageGo to next message
kapil2005
Messages: 44
Registered: March 2005
Member
Here is the RMAN log:

2> connect catalog rman_92/backoffu2@RMAN_CATALOG
3> connect target /
4>
5>
6>
7> set snapshot controlfile name to '/r17/backup/PMIL/PMIL_060308_16:15:00_snapshot.ctl';
8>
9> run
10> {
11>
12> allocate channel ch0 type 'sbt_tape';
13> allocate channel ch1 type 'sbt_tape';
14> backup database
15> format 'd%d_df_U%U_s%s_p%p'
16> include current controlfile
17> filesperset=8;
18>
19> sql 'alter system archive log current';
20>
21> backup
22> format '%d_al_U%U_s%s_p%p'
23> filesperset=12
24> (archivelog all);
25>
26>
27> backup
28> format '%d_cntl_U%U_s%S_p%p'
29> (current controlfile);
30>
31> release channel ch0;
32> allocate channel ch0 type disk;
33> backup
34> format '/r17/backup/PMIL/%d_al_U%U_s%s_p%p'
35> filesperset=12
36> (archivelog until time 'sysdate-1'
37> delete input);
38>
39>
40> release channel ch0 ;
41> release channel ch1 ;
42>
43> }
44>
45>
connected to recovery catalog database

connected to target database: PMIL (DBID=1342501222)

executing command: SET SNAPSHOT
snapshot controlfile name set to: /r17/backup/PMIL/PMIL_060308_16:15:00_snapshot.ctl
new RMAN configuration parameters are successfully stored

allocated channel: ch0
channel ch0: sid=51 devtype=SBT_TAPE
channel ch0: EDM Oracle client

allocated channel: ch1
channel ch1: sid=54 devtype=SBT_TAPE
channel ch1: EDM Oracle client

Starting backup at 2006-03-08 16:15:13
channel ch0: starting full datafile backupset
channel ch0: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=/r15/oradata01/PMIL/pmil_system01.dbf
input datafile fno=00005 name=/r15/oradata01/PMIL/pmil_users01.dbf
channel ch0: starting piece 1 at 2006-03-08 16:15:13
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00004 name=/r15/oradata01/PMIL/pmil_mildoc_data01.dbf
input datafile fno=00003 name=/r15/oradata01/PMIL/pmil_mildoc_indx01.dbf
input datafile fno=00002 name=/r15/oradata01/PMIL/pmil_undotbs01.dbf
channel ch1: starting piece 1 at 2006-03-08 16:15:13
released channel: ch0
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch0 channel at 03/08/2006 16:48:20
ORA-19506: failed to create sequential file, name="dPMIL_df_Uqehdf60h_1_1_s1870_p1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
sbti_backup: Call to open_backup_session failed.

Recovery Manager complete.
Re: rman error [message #162282 is a reply to message #162280] Thu, 09 March 2006 09:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This is just my guess.
You are running the backups as usual as Oracle user or from DBA group. Somehow, after the reboot the filesystem permissions are reset. Make sure that, the user executing the backup scripts has permissions on /usr/openv/*


Re: rman error [message #162286 is a reply to message #162117] Thu, 09 March 2006 09:51 Go to previous messageGo to next message
kapil2005
Messages: 44
Registered: March 2005
Member
I have 2 questions for you, we are using EDM5.1 software from EMC. so we have client libaries installed on Database Server and we have a seperate box for server version EDM software.
so my question is , where should i check for permissions on EDM client box which is our database server or EDM server box?
on Client i have software installed as /usr/epoch/EB/CLIENT
and i have symbolic link in $ORACLE_HOME/lib to /usr/epoch/EB_DB/libobk_64.sl
Re: rman error [message #162289 is a reply to message #162286] Thu, 09 March 2006 10:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have no idea as i have not worked with this tool.
I would just check all over. I ***guess*** this is to do with filesystem permissions.
Re: rman error [message #162626 is a reply to message #162117] Sun, 12 March 2006 09:41 Go to previous messageGo to next message
kapil2005
Messages: 44
Registered: March 2005
Member
Ok , i am working with oracle we will see what they will say.
Thanks for your help
Re: rman error [message #172482 is a reply to message #162626] Tue, 16 May 2006 16:03 Go to previous messageGo to next message
ssommer_eq
Messages: 1
Registered: May 2006
Junior Member
I'm having the same problem myself. All of a sudden on two HP-UX machines the backups are failing. Were you able to resolve you issues and if so, may I ask how?

SBT-28879 05/08/2006 19:30:39 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-28368 05/10/2006 19:30:51 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-1290 05/13/2006 19:30:29 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-29899 05/14/2006 19:30:40 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-23057 05/16/2006 14:20:04 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
SBT-25889 05/16/2006 14:54:46 E: sbti_backup: Call to open_backup_session failed.: sbt_error=7501, ebci_error=1001.
Re: rman error [message #186994 is a reply to message #162117] Thu, 10 August 2006 08:23 Go to previous message
JennyOstr
Messages: 1
Registered: August 2006
Location: NJ
Junior Member
Kapil -

I'm experience the same problem with one of my databases. Did you resolve this? If yes, please, let me know becuase my SA does not know what to do and where to look for this error.

Thanks,
Jenny.
Previous Topic: have this morning full backup(rman:dbfiles/archivelog),but lost some archvielog from this afternoon?
Next Topic: Disaster recovery!! Please help me !!!
Goto Forum:
  


Current Time: Sun Dec 04 02:40:11 CST 2016

Total time taken to generate the page: 0.13933 seconds