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: Thu, 18 Oct 2007 09:29:46 -0700
Message-ID: <1192724986.496066.256320@v23g2000prn.googlegroups.com>


On Oct 17, 1:09 pm, sillz <beth.sto..._at_gmail.com> wrote:
> 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 -
>
> Also, here's teh RMAN output from BUExec.
>
> 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={E7A72­13E-
> 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 ...
>
> read more »- Hide quoted text -
>
> - Show quoted text -

Thanks Jerome, Sorry about the double post there.

I ran a modified version of the run block you gave me. I had to allocate a channel for maintenance first. All results come back expired. This is really perplexing.

I'm wondering now if I should just do my backups from RMAN instead of Backup Exec.

Here's the output of the commands.

RMAN> allocate channel for maintenance device type SBT_TAPE;

allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=41 devtype=SBT_TAPE channel ORA_MAINT_SBT_TAPE_1: Symantec/BackupExec/1.1.0

RMAN> RUN {
2> SEND
3>
'BSA_SERVICE_HOST=10.1.1.176,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE= 4> {E7A7213E-> A747-4AB9-B162-
B7189B5CEB53},NBBSA_DB_DEVICE_NAME=Oracle-Win::

5> \\servername.domainname.com\PROD';
6> RELEASE CHANNEL ch0;
7> }


sent command to channel: ORA_MAINT_SBT_TAPE_1

crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_iriu0k2j_1_1 recid=601 stamp=635457620 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_isiu0k6h_1_1 recid=602 stamp=635457746 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_iuiu0mfd_1_1 recid=604 stamp=635460078 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j0iu38eh_1_1 recid=606 stamp=635544018 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j1iu38i6_1_1 recid=607 stamp=635544134 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j2iu3alh_1_1 recid=608 stamp=635546290 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071009-00 recid=609 stamp=635546291 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j4iu5sqg_1_1 recid=610 stamp=635630417 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j5iu5t0k_1_1 recid=611 stamp=635630613 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j6iu5v5i_1_1 recid=612 stamp=635632819 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071010-00 recid=613 stamp=635632821 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j8iu8h6h_1_1 recid=614 stamp=635716818 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j9iu8hap_1_1 recid=615 stamp=635716954 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jaiu8hee_1_1 recid=616 stamp=635717070 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jbiu8jeb_1_1 recid=617 stamp=635719116 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071011-00 recid=618 stamp=635719117 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jdiub5ie_1_1 recid=619 stamp=635803215 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jeiub5nk_1_1 recid=620 stamp=635803381 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jfiub5sh_1_1 recid=621 stamp=635803537 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jgiub88u_1_1 recid=622 stamp=635805983 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071012-00 recid=623 stamp=635805984 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jiiuj2me_1_1 recid=624 stamp=636062415 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jjiuj2ru_1_1 recid=625 stamp=636062591 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jkiuj30h_1_1 recid=626 stamp=636062737 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jliuj504_1_1 recid=627 stamp=636064773 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071015-00 recid=628 stamp=636064774 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jniuln2f_1_1 recid=629 stamp=636148817 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_joiuln7c_1_1 recid=630 stamp=636148972 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jpiulp88_1_1 recid=631 stamp=636151049 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071016-00 recid=632 stamp=636151050 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jriuobee_1_1 recid=633 stamp=636235215 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jsiuobi3_1_1 recid=634 stamp=636235331 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jtiuodkq_1_1 recid=635 stamp=636237467 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071017-00 recid=636 stamp=636237469 Crosschecked 34 objects Received on Thu Oct 18 2007 - 11:29:46 CDT

Original text of this message

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