oracle 修改备份路径,rman更改备份路径问题

呵呵 不好意思，上午我那个命令路径copy错了，不过即使是路径正确的话也不行啊

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u00/dbbackup/220-back/%U';

old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oradatabase/back/221--back/%U';

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/u00/dbbackup/220-back/%U';

new RMAN configuration parameters are successfully stored

released channel: ORA_DISK_1

RMAN> list backup;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

1       Incr 0  726.37M    DISK        00:05:50     2010-05-06 04:25:07

BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20100506T041916

Piece Name: /u00/dbbackup/221-back/01lcvgi5_1_1

List of Datafiles in backup set 1

File LV Type Ckp SCN    Ckp Time            Name

---- -- ---- ---------- ------------------- ----

1    0  Incr 66023842   2010-05-04 12:43:40 /u00/oracle/standbydb/system01.dbf

2    0  Incr 66023842   2010-05-04 12:43:40 /u00/oracle/standbydb/undotbs01.dbf

3    0  Incr 66023842   2010-05-04 12:43:40 /u00/oracle/standbydb/sysaux01.dbf

4    0  Incr 66023842   2010-05-04 12:43:40 /u00/oracle/standbydb/users01.dbf

5    0  Incr 66023842   2010-05-04 12:43:40 /u00/oracle/standbydb/example01.dbf

7    0  Incr 66023842   2010-05-04 12:43:40 /u00/oracle/standbydb/rman.dbf

12   0  Incr 66023842   2010-05-04 12:43:40 /u00/oracle/standbydb/lizi.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

2       Incr 0  7.11M      DISK        00:00:06     2010-05-06 04:25:22

BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20100506T041916

Piece Name: /u00/dbbackup/221-back/02lcvgtc_1_1

Control File Included: Ckp SCN: 66023842     Ckp time: 2010-05-04 12:43:40

SPFILE Included: Modification time: 2010-05-06 04:17:27

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

3       Incr 1  80.00K     DISK        00:06:03     2010-05-07 08:57:48

BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20100507T085144

Piece Name: /u00/dbbackup/221-back/03ld2kt1_1_1

List of Datafiles in backup set 3

File LV Type Ckp SCN    Ckp Time            Name

---- -- ---- ---------- ------------------- ----

1    1  Incr 66023843   2010-05-07 08:48:14 /u00/oracle/standbydb/system01.dbf

2    1  Incr 66023843   2010-05-07 08:48:14 /u00/oracle/standbydb/undotbs01.dbf

3    1  Incr 66023843   2010-05-07 08:48:14 /u00/oracle/standbydb/sysaux01.dbf

4    1  Incr 66023843   2010-05-07 08:48:14 /u00/oracle/standbydb/users01.dbf

5    1  Incr 66023843   2010-05-07 08:48:14 /u00/oracle/standbydb/example01.dbf

7    1  Incr 66023843   2010-05-07 08:48:14 /u00/oracle/standbydb/rman.dbf

12   1  Incr 66023843   2010-05-07 08:48:14 /u00/oracle/standbydb/lizi.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

4       Incr 1  7.11M      DISK        00:00:05     2010-05-07 08:57:57

BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20100507T085144

Piece Name: /u00/dbbackup/221-back/04ld2l8g_1_1

Control File Included: Ckp SCN: 66023979     Ckp time: 2010-05-07 08:48:38

SPFILE Included: Modification time: 2010-05-07 08:50:33

RMAN> restore database;

Starting restore at 2010-05-10 14:36:49

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /u00/oracle/standbydb/system01.dbf

restoring datafile 00002 to /u00/oracle/standbydb/undotbs01.dbf

restoring datafile 00003 to /u00/oracle/standbydb/sysaux01.dbf

restoring datafile 00004 to /u00/oracle/standbydb/users01.dbf

restoring datafile 00005 to /u00/oracle/standbydb/example01.dbf

restoring datafile 00007 to /u00/oracle/standbydb/rman.dbf

restoring datafile 00012 to /u00/oracle/standbydb/lizi.dbf

channel ORA_DISK_1: reading from backup piece /u00/dbbackup/221-back/01lcvgi5_1_1

ORA-19870: error reading backup piece /u00/dbbackup/221-back/01lcvgi5_1_1

ORA-19505: failed to identify file "/u00/dbbackup/221-back/01lcvgi5_1_1"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

failover to previous backup

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 05/10/2010 14:36:50

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 12 found to restore

RMAN-06023: no backup or copy of datafile 7 found to restore

RMAN-06023: no backup or copy of datafile 5 found to restore

RMAN-06023: no backup or copy of datafile 4 found to restore

RMAN-06023: no backup or copy of datafile 3 found to restore

RMAN-06023: no backup or copy of datafile 2 found to restore

RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>