TSI_DB_SK

Chyba v ARCbackup logu:

RMAN> connect target *
RMAN-06005: connected to target database: TOISLA (DBID=1635878950)

RMAN> connect catalog *
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

SOLUTION:
Probably BACKUP_CATALOG changed from "fcat10a.world" to "fcat11a.world"

----------------------------------------------------------------------------------------

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t2
RMAN-10035: exception raised in RPC: ORA-19502: write error on file "/opt/oradata/u02/ora_online_backup/DB_ETRA.2405.690224799.1", blockno 638977 (blocksize=512)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
Additional information: 638977
Additional information: 256
Additional information: 638989
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE


SOLUTION:
Script DBbackup_Disk.sh adjusted.

-----------------------------------------------------------------------------------------

RMAN-12018: channel ORA_SBT_TAPE_7 disabled, job failed on it will be run on another channel
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_SBT_TAPE_8 channel at 08/17/2009 13:19:22
ORA-19506: failed to create sequential file, name="AL_/TOISLA.43187.695135961.1/", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   The NW authentication for client 'cmslivf3' was refused by server 'ffmbackup01'
 because 'client `cmslivf3' is not properly configured on the NetWorker Server'
. (2:12:0)

SOLUTION:
Problem on backup-team side.

------------------------------------------------------------------------------------------

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/22/2009 16:45:38
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archive log in the recovery catalog
RMAN-06097: text of failing SQL statement: declare thread number ; sequence number ; recid number ; alRec dbms_rcvman . alRec_t ; begin dbms_rcvman . getArchivedLog ( alRec => alRec ) ; if ( :rlscn = alRec . rlgSCN and :stopthr = alRec . thread and ( ( alRec . sequence >= to_number ( :stopseq ) and :toclause = 0 ) or ( alRec . sequence > to_number ( :stopseq ) and :toclause = 1 ) ) ) then :flag := 1 ; else :flag := 0 ; :al_key:al_key_i := alRec . key ; :recid:recid_i := alRec . recid ; :stamp:stamp_i := alRec . stamp ; :thread := alRec . thread ; :se
RMAN-06099: error occurred in source file: krmk.pc, line: 30957

SOLUTION: V logarchive_dest_1 nieje ziaden archive log.
pouzi "alter system switch logfile" alebo uprav scrip ARCbackup.ksh.
Do casti:
#--------------------------------------------------------------
# Backup der Archive-Logs
#--------------------------------------------------------------
pred run { pridaj riadok:
sql 'alter system switch logfile';

------------------------------------------------------------------------------------------

channel ORA_SBT_TAPE_5: starting piece 1 at 2009-08-26 12:46:13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-10035: exception raised in RPC:
O
RMAN-10031: RPC Error: ORA-19624  occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN-10035: exception raised in RPC:
O
RMAN-10031: RPC Error: ORA-19624  occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN-10035: exception raised in RPC:
O
RMAN-10031: RPC Error: ORA-19624  occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN-10035: exception raised in RPC:
O
RMAN-10031: RPC Error: ORA-19624  occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 08/26/2009 12:46:16
RMAN-10032: unhandled exception during execution of job step 1:
ORA-19624: operation failed, retry possible
ORA-19506: failed to create sequential file, name="AL_/CCBAQ.357035.695911573.1/", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   Could not create the NWORA resource lock file (13) (103:105:13)
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625
ORA-06512: at line 187
RMAN-10035: exception raised in RPC:
ORA-19624: operation failed, retry possible
ORA-19506: failed to create sequential file, name="AL_/CCBAQ.357035.695911573.1/", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   Could not create the NWORA resource lock file (13) (103:105:13)
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625
RMAN-10031: RPC Error: ORA-19624  occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

SOLUTION:
ako root: toto treba spustit
nsrnmoadmin -r list > /dev/null 2>&1
ak nemas v /nsr/tmp nwora.res.lck subor

alebo:
as root
nsrnmoadmin -r add sid=ORACLE_SID home=ORACLE_HOME connect=dummy

----------------------------------------------------------------------------------------------------

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-10035: exception raised in RPC:
O
RMAN-10031: RPC Error: ORA-19624  occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 09/22/2009 09:07:01
RMAN-10032: unhandled exception during execution of job step 1:
ORA-19624: operation failed, retry possible
ORA-19502: write error on file "AL_/TEC.48616.698229024.1/", blockno 138753 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   asdf_output_section1() failed
xdr=0x1105ec1d0: bp=0x1105ec210: send_len=262144: type=12800: fhand=0x1105ec730: wrapper=0x1105ec750: directp=0x1105ec770 (1:4:9)
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625
ORA-06512: at line 224
RMAN-10035: exception raised in RPC:
ORA-19624: operation failed, retry possible
ORA-19502: write error on file "AL_/TEC.48616.698229024.1/", blockno 138753 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   asdf_output_section1() failed
xdr=0x1105ec1d0: bp=0x1105ec210: send_len=262144: type=12800: fhand=0x1105ec730: wrapper=0x1105ec750: directp=0x1105ec770 (1:4:9)
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 625
RMAN-10031: RPC Error: ORA-19624  occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE


SOLUTION:
http://forums.oracle.com/forums/thread.jspa?threadID=867572
-restartnut backup,
-ak stale skonci s chybou, kontaktuj BACKUP team.

--------------------------------------------------------------------------------------------------

RMAN-08002: starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 11/30/2009 14:45:33
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 11/30/2009 14:45:33
ORA-00001: unique constraint (RMVRS2.DF_U2) violated

SOLUTION:
1. alter table RMRVRS2.DF add constraint DF_U2 unique ("DBINC_KEY", "TS#", "TS_CREATE_SCN", "FILE#");

or

2.Metalink Problem Note: 402352.1
Create a new larger temp file instead  and drop the old one - you may also have to change the default temp
tablespace for the database before dropping the old one:

SQL>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;

---------------------------------------------------------------------------------------------------

RMAN-4711 ERROR DBbackup.ksh laeuft laenger als 24 Stunden

zmaz prazdny subor "backup" v adresar ${BACKUP_PATH}/DBbackup/
rm ${BACKUP_PATH}/DBbackup/backup