Re: RMAN output log
- From: Cristian Cudizio <cristian.cudizio@xxxxxxxx>
- Date: Mon, 06 Aug 2007 07:59:30 -0700
On Aug 6, 4:37 pm, cptkirkh <kh...@xxxxxxxx> 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 seems that you apply incremental backups to image copy, but there
is no initial complete backup: maybe this?
Is this script generated by OEM?
regards,
Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com
.
- References:
- RMAN output log
- From: cptkirkh
- RMAN output log
- Prev by Date: Re: changing pswds of standard accounts
- Next by Date: Re: Oracle RAC VIP networking question
- Previous by thread: RMAN output log
- Next by thread: Re: RMAN output log
- Index(es):
Relevant Pages
|
