Re: RMAN output log

cptkirkh 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;
> }

It can't find the files from the previous backup. To identify what RMAN thinks is data file 4 ...

set linesize 121
col file_name format a90

SELECT file_name, file_id
FROM dba_data_files
ORDER BY 2;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org