Hello Team,
In my setup one of the database RMAN backup is failing .. The error details mentioning below.
Bellow is the detail list of all events that took place on our server
=== ODM Question === Deleted archivelogs from a location that was full. Performed a "crosscheck copy of archivelog all" to normalize Archivelog sequences. Then run an RMAN backup which yielded these errors... .Please help us on this.
RMAN> backup database 2> ;
Starting backup at 06-DEC-10 using channel ORA_SBT_TAPE_1 using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting full datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00006 name=/rept/oradata/u02/PRODREPT/REPTT01_1.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 06-DEC-10 channel ORA_SBT_TAPE_2: starting full datafile backup set channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set input datafile file number=00007 name=/rept/oradata/u02/PRODREPT/REPTT02_1.dbf channel ORA_SBT_TAPE_2: starting piece 1 at 06-DEC-10 RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 12/06/2010 16:39:57 ORA-19506: failed to create sequential file,, parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: lnm_index_cfx_connect retry failed. See privious error messages. (3:3:11)
Verified channels via RMAN
RMAN> show channel;
RMAN configuration parameters for database with db_unique_name PRODREPT are: CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=tzdarhq-bksrv,NSR_DATA_VOLUME_POOL=REPT,NSR_CLIENT=rept-lh |
ABBA.MTENGA@TZ.AIRTEL.COM - December 7, 2010 12:13:22 PM GMT+03:00 [Customer Problem Description] |
Problem Description: Deleted archivelogs from a location that was full. Performed a "crosscheck copy of archivelog all" to normalize Archivelog sequences. Then run an RMAN backup which yielded these errors...
RMAN> backup database 2> ;
Starting backup at 06-DEC-10 using channel ORA_SBT_TAPE_1 using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting full datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00006 name=/rept/oradata/u02/PRODREPT/REPTT01_1.dbf channel ORA_SBT_TAPE_1: starting piece 1 at 06-DEC-10 channel ORA_SBT_TAPE_2: starting full datafile backup set channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set input datafile file number=00007 name=/rept/oradata/u02/PRODREPT/REPTT02_1.dbf channel ORA_SBT_TAPE_2: starting piece 1 at 06-DEC-10 RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 12/06/2010 16:39:57 ORA-19506: failed to create sequential file,, parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: lnm_index_cfx_connect retry failed. See privious error messages. (3:3:11)
Verified channels via RMAN
RMAN> show channel;
RMAN configuration parameters for database with db_unique_name PRODREPT are: CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=tzdarhq-bksrv,NSR_DATA_VOLUME_POOL=REPT,NSR_CLIENT=rept-lh |
minksg
546 Posts
0
December 8th, 2010 04:00
Hi,
this is def a thread for the support forums. Stand by, I'll move it.
Mabro1
666 Posts
0
December 8th, 2010 04:00
I have moved this discussion to the Networker Support Forum to ensure your question gets to the right audience.
Regards,
Mark
ble1
2 Intern
2 Intern
•
14.3K Posts
0
December 8th, 2010 10:00
- make sure your oracle user (the one which runs rman) is listed in admin list
- make sure you have license
- make sure you run nsrnmoadmin -r list on oracle client
If it still fails check daemon.raw on both client and server for time when you started RMAN backup.