| rman error [message #162117] |
Wed, 08 March 2006 18:53  |
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 #162279 is a reply to message #162117] |
Thu, 09 March 2006 09:21  |
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 |
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 #162286 is a reply to message #162117] |
Thu, 09 March 2006 09:51 |
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 #172482 is a reply to message #162626] |
Tue, 16 May 2006 16:03 |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
