Re: RMAN output log

On Aug 6, 5:26 pm, cptkirkh <kh..._at_scic.com> wrote:
> On Aug 6, 10:10 am, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
> > 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
> > damor..._at_x.washington.edu (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text -
>
> > - Show quoted text -
>
> What i wanted to try was the Oracle suggested backup formula that you
> have the option to choose in the OEM so Cristian you are correct. Is
> it possible that I should just use the customized option and choose
> the Full backup option and then check the box use as the base of an
> incremental backup strategy? Then setup a scheduled Incremental backup
> (Level 1) to run daily after that? Thnaks for your help.

Personally i've never used incremental backup.i don't like it. In previous versions
of Oracle they where more complex, it seems to me that with 10g they have reduced
the levels to simplify.
What you say sounds right, i can only tell you to try it (and then remember also to try a restore and recovery)

regards
 Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Mon Aug 06 2007 - 10:39:27 CDT