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: RMAN output log

Re: RMAN output log

From: Alberto Frosi <alberto.frosi_at_gmail.com>
Date: Tue, 07 Aug 2007 07:28:34 -0000
Message-ID: <1186471714.678273.10180@o61g2000hsh.googlegroups.com>


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 Received on Tue Aug 07 2007 - 02:28:34 CDT

Original text of this message

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