Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: All Recent Backups Appear "EXPIRED" through RMAN

Re: All Recent Backups Appear "EXPIRED" through RMAN

From: sillz <beth.stover_at_gmail.com>
Date: Wed, 17 Oct 2007 09:12:13 -0700
Message-ID: <1192637533.757101.308760@i38g2000prf.googlegroups.com>


On Oct 17, 9:03 am, sillz <beth.sto..._at_gmail.com> wrote:
> On Oct 17, 12:26 am, vitalis..._at_gmail.com (Jerome Vitalis) wrote:
>
>
>
>
>
> > sillz wrote:
> > > We're using Oracle Database Server, Standard Edition version 9.2.0.7.
> > > Windows 2003 SP2. We have created backup sets using autobackup turned
> > > on, archive mode on and Backup Exec as the backup solution.
>
> > According to your persistant RMAN configuration, and if you do not
> > allocate specific tape channels for your backups, we can gather that
> > Backup Exec is not used directly as a media manager within RMAN. It puts
> > the backup pieces on tapes afterwards, and it deletes them from disks.
> > Right?
>
> > Then what you observe is normal since the backup pieces aren't at their
> > original location anymore. Restore them with Backup Exec and run
> > "crosscheck backup;" once more time.
>
> > To prevent such inconsistencies, you can run a "change backup ...
> > unavailable;" command after Backup Exec deletes the backups from disk.
> > Then those backups will never expire. Of course, run "change backup ...
> > available;" after you restore them to disk if you want RMAN to make use of
> > them.
> > -----
> > échangez opinions et commentaires dans les forums de discussion.http://www.usenetgratuit.com/
>
> Thanks Jerome,
>
> I'm not sure what you mean when you say that "BackupExec is not used
> directly as a media manager within RMAN."
>
> If I look at the BackupExec job log, here are the RMAN commands -- it
> opens a channel for tape:
>
> RUN {
> ALLOCATE CHANNEL ch0
> TYPE 'SBT_TAPE';
> SEND
> 'BSA_SERVICE_HOST=10.1.1.176,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={E7A721­3E-
> A747-4AB9-B162-B7189B5CEB53},NBBSA_DB_DEVICE_NAME=Oracle-Win::\
> \servername.mydomain.com\PROD';
> BACKUP
> INCREMENTAL LEVEL=0
> FORMAT 'BE_U'
> DATABASE FORCE PLUS ARCHIVELOG FORCE;
>
> RELEASE CHANNEL ch0;
> }
>
> We're not backing up to disk and then archiving to tape -- we're
> backing up to tape.
>
> We're having problems with BackupExec seeing the server, so we can't
> use it to restore right now. We've had a case open with SYmantec for
> over a month and thye can't figure it out.
>
> Because we can't use BUE, we've turned to restoring using RMAN.
>
> Any other ideas why all of my backups would be showing as expired?
>
> Beth- Hide quoted text -
>
> - Show quoted text -

Here's the RMAN output

Recovery Manager: Release 9.2.0.7.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------

 RUN {
 ALLOCATE CHANNEL ch0

     TYPE 'SBT_TAPE';
 SEND
'BSA_SERVICE_HOST=10.10.10.10,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={E7A7213E- A747-4AB9-B162-B7189B5CEB53},NBBSA_DB_DEVICE_NAME=Oracle-Win::\ \myserver.mydomain.com\PROD';
 BACKUP

     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE;

 RELEASE CHANNEL ch0;
 }

connected to target database: PROD (DBID=11771011)

using target database controlfile instead of recovery catalog allocated channel: ch0
channel ch0: sid=38 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting backup at 16-OCT-07
current log archived
channel ch0: starting archive log backupset channel ch0: specifying archive log(s) in backup set

input archive log thread=1 sequence=8744 recid=7857 stamp=635990398
input archive log thread=1 sequence=8745 recid=7858 stamp=635990848
input archive log thread=1 sequence=8746 recid=7859 stamp=635991145
input archive log thread=1 sequence=8747 recid=7860 stamp=635991620
input archive log thread=1 sequence=8748 recid=7861 stamp=635992000
input archive log thread=1 sequence=8749 recid=7862 stamp=635992207
input archive log thread=1 sequence=8750 recid=7863 stamp=636012994
input archive log thread=1 sequence=8751 recid=7864 stamp=636015799
input archive log thread=1 sequence=8752 recid=7865 stamp=636015816
input archive log thread=1 sequence=8753 recid=7866 stamp=636015830
input archive log thread=1 sequence=8754 recid=7867 stamp=636015844
input archive log thread=1 sequence=8755 recid=7868 stamp=636020889
input archive log thread=1 sequence=8756 recid=7869 stamp=636021085
input archive log thread=1 sequence=8757 recid=7870 stamp=636021504
input archive log thread=1 sequence=8758 recid=7871 stamp=636022217
input archive log thread=1 sequence=8759 recid=7872 stamp=636022949
input archive log thread=1 sequence=8760 recid=7873 stamp=636026383
input archive log thread=1 sequence=8761 recid=7874 stamp=636028385
input archive log thread=1 sequence=8762 recid=7875 stamp=636029130
input archive log thread=1 sequence=8763 recid=7876 stamp=636030175
input archive log thread=1 sequence=8764 recid=7877 stamp=636030768
input archive log thread=1 sequence=8765 recid=7878 stamp=636033146
input archive log thread=1 sequence=8766 recid=7879 stamp=636040250
input archive log thread=1 sequence=8767 recid=7880 stamp=636040798
input archive log thread=1 sequence=8768 recid=7881 stamp=636042123
input archive log thread=1 sequence=8769 recid=7882 stamp=636047034
input archive log thread=1 sequence=8770 recid=7883 stamp=636051004
input archive log thread=1 sequence=8771 recid=7884 stamp=636062413
input archive log thread=1 sequence=8772 recid=7885 stamp=636064772
input archive log thread=1 sequence=8773 recid=7886 stamp=636076949
input archive log thread=1 sequence=8774 recid=7887 stamp=636077574
input archive log thread=1 sequence=8775 recid=7888 stamp=636078211
input archive log thread=1 sequence=8776 recid=7889 stamp=636078241
input archive log thread=1 sequence=8777 recid=7890 stamp=636078341
input archive log thread=1 sequence=8778 recid=7891 stamp=636078427
input archive log thread=1 sequence=8779 recid=7892 stamp=636078878
input archive log thread=1 sequence=8780 recid=7893 stamp=636079290
input archive log thread=1 sequence=8781 recid=7894 stamp=636099120
input archive log thread=1 sequence=8782 recid=7895 stamp=636100306
input archive log thread=1 sequence=8783 recid=7896 stamp=636102126
input archive log thread=1 sequence=8784 recid=7897 stamp=636102141
input archive log thread=1 sequence=8785 recid=7898 stamp=636102156
input archive log thread=1 sequence=8786 recid=7899 stamp=636105689
input archive log thread=1 sequence=8787 recid=7900 stamp=636111942
input archive log thread=1 sequence=8788 recid=7901 stamp=636126695
input archive log thread=1 sequence=8789 recid=7902 stamp=636130342
input archive log thread=1 sequence=8790 recid=7903 stamp=636133940
input archive log thread=1 sequence=8791 recid=7904 stamp=636148815
channel ch0: starting piece 1 at 16-OCT-07 channel ch0: finished piece 1 at 16-OCT-07 piece handle=BE_jniuln2f_1_1 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:02:37 Finished backup at 16-OCT-07

Starting backup at 16-OCT-07
channel ch0: starting incremental level 0 datafile backupset channel ch0: specifying datafile(s) in backupset input datafile fno=00010 name=G:\ORACLE\ORADATA\PROD\COMPANY_DATA.DBF input datafile fno=00012 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA.DBF
input datafile fno=00013 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA02.DBF
input datafile fno=00014 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA03.DBF
input datafile fno=00015 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA04.DBF
input datafile fno=00016 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA05.DBF
input datafile fno=00017 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA06.DBF
input datafile fno=00018 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA07.DBF
input datafile fno=00019 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA08.DBF
input datafile fno=00020 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA09.DBF
input datafile fno=00021 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA10.DBF
input datafile fno=00033 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA11.DBF
input datafile fno=00038 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA12.DBF
input datafile fno=00040 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA13.DBF

input datafile fno=00002 name=G:\ORACLE\ORADATA\PROD\RBS01.ORA
input datafile fno=00031 name=G:\ORACLE\ORADATA\PROD\PLMS_DATA01.DBF
input datafile fno=00022 name=G:\ORACLE\ORADATA\PROD
\APPLICATION_INDEX.DBF
input datafile fno=00023 name=G:\ORACLE\ORADATA\PROD \APPLICATION_INDEX02.DBF
input datafile fno=00024 name=G:\ORACLE\ORADATA\PROD \APPLICATION_INDEX03.DBF
input datafile fno=00025 name=G:\ORACLE\ORADATA\PROD \APPLICATION_INDEX04.DBF
input datafile fno=00026 name=G:\ORACLE\ORADATA\PROD \APPLICATION_INDEX05.DBF
input datafile fno=00035 name=G:\ORACLE\ORADATA\PROD\DEVELOP_DATA1.DBF
input datafile fno=00036 name=G:\ORACLE\ORADATA\PROD\DEVELOP_DATA2.DBF
input datafile fno=00027 name=G:\ORACLE\ORADATA\PROD
\APPLICATION_INDEX06.DBF
input datafile fno=00039 name=G:\ORACLE\ORADATA\PROD \APPLICATION_INDEX07.DBF
input datafile fno=00041 name=G:\ORACLE\ORADATA\PROD \APPLICATION_DATA14.DBF
input datafile fno=00011 name=G:\ORACLE\ORADATA\PROD\COMPANY_INDEX.DBF
input datafile fno=00004 name=G:\ORACLE\ORADATA\PROD\BO_DATA.DBF
input datafile fno=00042 name=G:\ORACLE\ORADATA\PROD
\APPLICATION_DATA15.DBF
input datafile fno=00034 name=G:\ORACLE\ORADATA\PROD\BO.DBF
input datafile fno=00037 name=G:\ORACLE\ORADATA\PROD\MVLOGS01.DBF
input datafile fno=00003 name=G:\ORACLE\ORADATA\PROD\RBS02.ORA
input datafile fno=00043 name=G:\ORACLE\ORADATA\PROD
\APPLICATION_INDEX08.DBF
input datafile fno=00001 name=G:\ORACLE\ORADATA\PROD\SYSTEM01.DBF
input datafile fno=00009 name=G:\ORACLE\ORADATA\PROD\MAT_VIEW02.DBF
input datafile fno=00008 name=G:\ORACLE\ORADATA\PROD\MAT_VIEW01.DBF
input datafile fno=00032 name=G:\ORACLE\ORADATA\PROD\PLMS_INDEX01.DBF
input datafile fno=00007 name=G:\ORACLE\ORADATA\PROD\MAT_INDEX01.DBF
input datafile fno=00005 name=G:\ORACLE\ORADATA\PROD\IMPROM_DATA.DBF
input datafile fno=00006 name=G:\ORACLE\ORADATA\PROD\IMPROM_INDEX.DBF
input datafile fno=00028 name=G:\ORACLE\ORADATA\PROD\STAGING.DBF
input datafile fno=00029 name=G:\ORACLE\ORADATA\PROD\TOOLS01.DBF
input datafile fno=00030 name=G:\ORACLE\ORADATA\PROD\USERS01.DBF
channel ch0: starting piece 1 at 16-OCT-07 channel ch0: finished piece 1 at 16-OCT-07 piece handle=BE_joiuln7c_1_1 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:34:35 Finished backup at 16-OCT-07

Starting backup at 16-OCT-07
current log archived
channel ch0: starting archive log backupset channel ch0: specifying archive log(s) in backup set input archive log thread=1 sequence=8792 recid=7905 stamp=636151047 channel ch0: starting piece 1 at 16-OCT-07 channel ch0: finished piece 1 at 16-OCT-07 piece handle=BE_jpiulp88_1_1 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:00:02 Finished backup at 16-OCT-07

Starting Control File Autobackup at 16-OCT-07 piece handle=c-11771011-20071016-00 comment=API Version 2.0,MMS Version 1.1.0.0
Finished Control File Autobackup at 16-OCT-07

released channel: ch0

Recovery Manager complete. Received on Wed Oct 17 2007 - 11:12:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US