Visit Counter

Friday, January 23, 2015

ORA-19506: failed to create sequential file name="/ora_idx/ssaerp/backup/forstandby_ltpteqk7_1_1", parms=""



RMAN> backup incremental from scn 95670 database FORMAT '/ora_idx/ssaerp/backup/forstandby_%U' tag 'FORSTANDBY';

Starting backup at 01/23/2013
using channel ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: starting full datafile backupset
channel ORA_SBT_TAPE_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/ora_dat/ssaerp/xdb_SSAERP01.dbf
input datafile fno=00007 name=/ora_idx/ssaerp/xdb_SSAERP01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 01/23/2013
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 01/23/2013 14:45:42
ORA-19506: failed to create sequential file, name="/ora_idx/ssaerp/backup/forstandby_ltpteqk7_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  the specified policy is not of the correct client type


RMAN> run {
2> allocate channel t1 type disk;
3> backup incremental from scn 95670 database FORMAT '/ora_idx/ssaerp/backup/forstandby_%U' tag 'FORSTANDBY';
4> release channel t1;
5> }



Starting backup at 01/23/2013
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00006 name=/ora_dat/ssaerp/xdb_SSAERP01.dbf
input datafile fno=00007 name=/ora_idx/ssaerp/xdb_SSAERP01.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at 01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_lupterr7_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:05:05
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00008 name=/ora_dat/ssaerp/xdb_SSAERP02.dbf
input datafile fno=00019 name=/ora_idx/ssaerp/idb_SSAERP02.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at 01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_lvptes4o_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:05:06
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00009 name=/ora_dat/ssaerp/xdb_SSAERP03.dbf
input datafile fno=00020 name=/ora_idx/ssaerp/idx_SSAERP03.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at 01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_m0ptesea_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:05:05
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00010 name=/ora_dat/ssaerp/xdb_SSAERP04.dbf
input datafile fno=00021 name=/ora_idx/ssaerp/idx_SSAERP04.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_m1ptesnr_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:05:15
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00011 name=/ora_dat/ssaerp/xdb_SSAERP05.dbf
input datafile fno=00022 name=/ora_idx/ssaerp/idx_SSAERP05.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at 01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_m2ptet1n_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:05:05
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00012 name=/ora_dat/ssaerp/xdb_SSAERP06.dbf
input datafile fno=00023 name=/ora_idx/ssaerp/idx_SSAERP06.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at 01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_m3ptetb8_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:05:15
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00013 name=/ora_dat/ssaerp/xdb_SSAERP07.dbf
input datafile fno=00024 name=/ora_idx/ssaerp/idx_SSAERP07.dbf

.........



input datafile fno=00002 name=/ora_dat/ssaerp/undotbs01.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at 01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_meptf0me_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:01:55
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00005 name=/ora_dat/ssaerp/system02.dbf
input datafile fno=00004 name=/ora_dat/ssaerp/users01.dbf
input datafile fno=00003 name=/ora_dat/ssaerp/sysaux01.dbf
input datafile fno=00001 name=/ora_dat/ssaerp/system01.dbf
channel t1: starting piece 1 at 01/23/2013
channel t1: finished piece 1 at01/23/2013
piece handle=/ora_idx/ssaerp/backup/forstandby_mfptf0q2_1_1 tag=FORSTANDBY comment=NONE
channel t1: backup set complete, elapsed time: 00:00:55
Finished backup at 01/23/2013

Starting Control File and SPFILE Autobackup at 01/23/2013
piece handle=/ora/app/oracle/bkcont/c-3389811866-20150123-00 comment=NONE
Finished Control File and SPFILE Autobackup at 01/23/2013

released channel: t1

RMAN>