Re: RMAN output log

On 7 Ago, 10:21, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
> On Aug 7, 9:28 am, Alberto Frosi <alberto.fr..._at_gmail.com> wrote:
>
>
>
> > On Aug 6, 4:37 pm, cptkirkh <kh..._at_scic.com> wrote:
>
> > > I am runnign 10.1.0.3 on windows server 2003 and for the first time i
> > > have tried to run the ORacle suggested backup to the flash recovery
> > > area. I placed a limit on the flash recovery area and i am curious
> > > about what the output log is telling me. Here is a copy of my output
> > > log and i have placed next to the lines that confuse me. Coulc
> > > someone explian to me waht these mean? Also when I go into the OEM
> > > and look at my current backups it only lists the system and sysaux
> > > datafiles. I have also included my RMAN script. Thanks in advance.
>
> > > Recovery Manager: Release 10.1.0.3.0 - Production
>
> > > Copyright (c) 1995, 2004, Oracle. All rights reserved.
>
> > > RMAN>
>
> > > connected to target database: PORKY (DBID=890890261)
>
> > > using target database controlfile instead of recovery catalog
>
> > > RMAN> 2> 3> 4> 5>
>
> > > allocated channel: oem_disk_backup
>
> > > channel oem_disk_backup: sid=119 devtype=DISK
>
> > > Starting recover at 06-AUG-07 --why is trying to recover??
>
> > > no copy of datafile 2 found to recover
>
> > > no copy of datafile 4 found to recover
>
> > > no copy of datafile 5 found to recover
>
> > > channel oem_disk_backup: starting incremental datafile backupset
> > > restore
>
> > > channel oem_disk_backup: specifying datafile copies to recover
>
> > > recovering datafilecopy fno=00001 name=F:\ORACLE\PRODUCT
> > > \10.1.0\FLASH_RECOVERY_AREA\PORKY\DATAFILE\O1_MF_SYSTEM_3C7F1CFJ_.DBF
>
> > > recovering datafilecopy fno=00003 name=F:\ORACLE\PRODUCT
> > > \10.1.0\FLASH_RECOVERY_AREA\PORKY\DATAFILE\O1_MF_SYSAUX_3C7F09HJ_.DBF
>
> > > channel oem_disk_backup: restored backup piece 1
>
> > > piece handle=F:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\PORKY
> > > \BACKUPSET\2007_08_05\O1_MF_NNND1_TAG20070805T225751_3CF73HBB_.BKP
> > > tag=TAG20070805T225751
>
> > > channel oem_disk_backup: restore complete
>
> > > Finished recover at 06-AUG-07
>
> > > Starting backup at 06-AUG-07
>
> > > no parent backup or copy of datafile 4 found -- which datafile can it
> > > not find?
>
> > > no parent backup or copy of datafile 5 found
>
> > > no parent backup or copy of datafile 2 found
>
> > > channel oem_disk_backup: starting datafile copy
>
> > > input datafile fno=00004 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
> > > \USERS01.DBF
>
> > > output filename=F:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\PORKY
> > > \DATAFILE\O1_MF_USERS_3CG3BQ8M_.DBF tag=ORA$OEM_LEVEL_0 recid=556
> > > stamp=629881804
>
> > > channel oem_disk_backup: datafile copy complete, elapsed time:
> > > 00:09:45
>
> > > channel oem_disk_backup: starting datafile copy
>
> > > input datafile fno=00005 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
> > > \USERS02.DBF
>
> > > output filename=F:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\PORKY
> > > \DATAFILE\O1_MF_USERS_3CG3WZ53_.DBF tag=ORA$OEM_LEVEL_0 recid=557
> > > stamp=629882345
>
> > > channel oem_disk_backup: datafile copy complete, elapsed time:
> > > 00:09:06
>
> > > channel oem_disk_backup: starting datafile copy
>
> > > input datafile fno=00002 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
> > > \UNDOTBS01.DBF
>
> > > output filename=F:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\PORKY
> > > \DATAFILE\O1_MF_UNDOTBS1_3CG4G08G_.DBF tag=ORA$OEM_LEVEL_0 recid=558
> > > stamp=629882436
>
> > > channel oem_disk_backup: datafile copy complete, elapsed time:
> > > 00:01:25
>
> > > channel oem_disk_backup: starting compressed incremental level 1
> > > datafile backupset
>
> > > channel oem_disk_backup: specifying datafile(s) in backupset
>
> > > input datafile fno=00003 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
> > > \SYSAUX01.DBF
>
> > > input datafile fno=00001 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
> > > \SYSTEM01.DBF
>
> > > channel oem_disk_backup: starting piece 1 at 06-AUG-07
>
> > > channel oem_disk_backup: finished piece 1 at 06-AUG-07
>
> > > piece handle=F:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\PORKY
> > > \BACKUPSET\2007_08_06\O1_MF_NNND1_TAG20070806T070021_3CG4JQ02_.BKP
> > > comment=NONE
>
> > > channel oem_disk_backup: backup set complete, elapsed time: 00:00:15
>
> > > Finished backup at 06-AUG-07
>
> > > Starting Control File and SPFILE Autobackup at 06-AUG-07
>
> > > piece handle=E:\BACKUPS\C-890890261-20070806-00 comment=NONE
>
> > > Finished Control File and SPFILE Autobackup at 06-AUG-07
>
> > > released channel: oem_disk_backup
>
> > > RMAN>
>
> > > Recovery Manager complete.
>
> > > Here is my RMAN script.
> > > Daily Script:
> > > run {
> > > allocate channel oem_disk_backup device type disk;
> > > recover copy of database with tag 'ORA$OEM_LEVEL_0';
> > > backup incremental level 1 cumulative copies=1 for recover of copy
> > > with tag 'ORA$OEM_LEVEL_0' database;
>
> > > }
>
> > Hi all,
> > The backup hot first must be done a full backup or an incremental 0,
> > and after you can apply your stategy for an incremental backup.
> > A solution may be:
> > Sun: incremental 0
> > Mon, Tue, Thu, Fri and Sat: incremental level 2 non cumulative
> > Wed: incremental level 1 non cumulative
> > I've applied a solution for incremental 0 every night, it's like a
> > backup complete with only a difference that i can attach other type of
> > incremental backup.
> > Another solution may be like cristian propose, backup full in the
> > night with all archive log.
> > bye
>
> > Alberto Frosi
>
> I've forgot to say an important thing, incremental backups
> is an option available only with enterprise edition until 9i,
> from 10g (correct me if i'm wrong) it is available also with standard
> edition.
> Block change tracking, a new feature of 10g (yes i know, 10g is here
> from
> 2004 but all of you know that there are customers with 8 and 7) is
> available
> with Enterprise Edition. In my opinion it is an interesting feature
> but introduces
> a bit of management complexity due to storage management for the
> change tracking
> file (if i'm not confusing different things)
>
> regards,
>
> Cristian Cudiziohttp://oracledb.wordpress.comhttp://cristiancudizio.wordpress.com

Yes it's the incremental backup with RMAN is only avaible on 9i Enterprise Edition on 10g and above i don't know. if you have 9,8, 7 Personal Edition is not possible execute a incremental backup but only full backup with relative archive log. Regards,

Alberto Frosi Received on Tue Aug 07 2007 - 05:42:33 CDT