 RMAN incremental backup failed [message #394963] |
Mon, 30 March 2009 22:52  |
natung
Messages: 2
Registered: March 2009
|
Junior Member |
|
|
Hi bro
I have backup policy by RMAN in ORACLE 10g
* SCRIPT
run
{
recover copy of database with tag 'incremental';
backup incremental level 1 for recover of copy with tag 'incremental' database;
delete noprompt obsolete;
}
* Log
- The FIRST running
RMAN> run
2> {
3> configure retention policy to recovery window of 7 days;
4> recover copy of database with tag 'incremental';
5> backup incremental level 1 for recover of copy with tag 'incremental' database;
6> delete noprompt obsolete;
7> }
8>
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
Starting recover at 2009-03-19 14:35:05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1663 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1661 devtype=DISK
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
no copy of datafile 6 found to recover
no copy of datafile 7 found to recover
no copy of datafile 8 found to recover
no copy of datafile 9 found to recover
no copy of datafile 10 found to recover
no copy of datafile 11 found to recover
no copy of datafile 12 found to recover
no copy of datafile 13 found to recover
no copy of datafile 14 found to recover
Finished recover at 2009-03-19 14:35:10
Starting backup at 2009-03-19 14:35:12
using channel ORA_DISK_1
using channel ORA_DISK_2
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 5 found
channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/oradata/TWO/a4m01.dbf
input datafile fno=00013 name=/oradata/TWO/a4m_q1/a4m_q1_03.dbf
input datafile fno=00011 name=/oradata/TWO/a4m_q1/a4m_q1_01.dbf
input datafile fno=00012 name=/oradata/TWO/a4m_q1/a4m_q1_02.dbf
input datafile fno=00001 name=/oradata/TWO/system01.dbf
channel ORA_DISK_1: starting piece 1 at 2009-03-19 14:35:14
channel ORA_DISK_2: starting compressed incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00008 name=/oradata/TWO/IDTS_A4M_data01.dbf
input datafile fno=00009 name=/oradata/TWO/IDTS_A4M_data02.dbf
input datafile fno=00006 name=/oradata/TWO/DATS_A4M_data01.dbf
input datafile fno=00007 name=/oradata/TWO/DATS_A4M_data02.dbf
input datafile fno=00010 name=/oradata/TWO/DATS_A4M_data03.dbf
input datafile fno=00014 name=/oradata/TWO/IDTS_A4M_data03.dbf
input datafile fno=00002 name=/oradreleased channel: ch1
RMAN-00571: ================================================channel ORA_DISK_1: finished piece 1 at 2009-03-19 15:10:40
piece handle=/backup/DBA_online_backup/681921314_53kaaip2_1_1 tag=TAG20090319T143512 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:35:30
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/oradata/TWO/sysaux01.dbf
output filename=/backup/DBA_online_backup/681923451_data_D-TWO_I-447419563_TS-SYSAUX_FNO-3_55kaakrr tag=INCREMENTAL recid=17 stamp=6
81923484
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/oradata/TWO/users01.dbf
output filename=/backup/DBA_online_backup/681923487_data_D-TWO_I-447419563_TS-USERS_FNO-5_56kaaksv tag=INCREMENTAL recid=18 stamp=68
1923493
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_2: finished piece 1 at 2009-03-19 15:29:21
piece handle=/backup/DBA_online_backup/681921314_54kaaip2_1_1 tag=TAG20090319T143512 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:54:09
Finished backup at 2009-03-19 15:29:24
Starting Control File and SPFILE Autobackup at 2009-03-19 15:29:26
piece handle=/backup/DBA_online_backup/c-447419563-20090319-00 comment=NONE
Finished Control File and SPFILE Autobackup at 2009-03-19 15:29:45
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
using channel ORA_DISK_1
using channel ORA_DISK_2
no obsolete backups found
Recovery Manager complete.
- The SECOND running:
RMAN> run
2> {
3> recover copy of database with tag 'incremental';
4> backup incremental level 1 for recover of copy with tag 'incremental' database;
5> delete noprompt obsolete;
6> }
7>
Starting recover at 2009-03-19 17:00:42
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2195 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1673 devtype=DISK
no copy of datafile 3 found to recover
no copy of datafile 5 found to recover
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy fno=00001 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-SYSTEM_FNO-1_4gk9p7b4
recovering datafile copy fno=00004 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-A4M_FNO-4_4lka8atg
recovering datafile copy fno=00011 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-A4M_Q1_FNO-11_4ek9p75o
recovering datafile copy fno=00012 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-A4M_Q1_FNO-12_4fk9p78f
recovering datafile copy fno=00013 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-A4M_Q1_FNO-13_49k9m5hj
channel ORA_DISK_1: reading from backup piece /backup/DBA_online_backup/681921314_53kaaip2_1_1
channel ORA_DISK_2: starting incremental datafile backupset restore
channel ORA_DISK_2: specifying datafile copies to recover
recovering datafile copy fno=00002 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-UNDOTBS1_FNO-2_48k9m5cn
recovering datafile copy fno=00006 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-DATS_A4M_FNO-6_40k9lode
recovering datafile copy fno=00007 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-DATS_A4M_FNO-7_46k9m4ja
recovering datafile copy fno=00008 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-IDTS_A4M_FNO-8_3uk9lmps
recovering datafile copy fno=00009 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-IDTS_A4M_FNO-9_3vk9lnk1
recovering datafile copy fno=00010 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-DATS_A4M_FNO-10_41k9lp6h
recovering datafile copy fno=00014 name=/backup/DBA_online_backup/data_D-TWO_I-447419563_TS-IDTS_A4M_FNO-14_47k9m53f
channel ORA_DISK_2: reading from backup piece /backup/DBA_online_backup/681921314_54kaaip2_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/19/2009 17:00:51
ORA-19870: error reading backup piece /backup/DBA_online_backup/681921314_53kaaip2_1_1
ORA-19625: error identifying file /backup/DBA_online_backup/data_D-TWO_I-447419563_TS-A4M_FNO-4_4lka8atg
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
Recovery Manager complete.
- Running over 3 times and result is not changed
I don't know why what is happenned because user ORACLE is asigned right on /backup/DBA_online_backup
drwxr-xr-x 2 oracle dba 8192 Mar 31 07:44 DBA_online_backup
how can i detect problem on this one???
Help me
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
