| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: All Recent Backups Appear "EXPIRED" through RMAN
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={E7A7213E-
> 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={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=636148815channel 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
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=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=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.DBFchannel 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
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 - 15:09:23 CDT
 |
 |