errors with rman duplicate
- From: vnr1995 <vnr1995@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 13 Mar 2007 11:39:16 -0400
Hi,
I ran into problems while cloning a db using rman. Auxiliary(AUXI), and
target(MERLIN), and rman executables are of version 10.2.0.2.0, and on
solaris 10 sparc 64.
I first ran the duplicate script, it restored 15 dbfs, and thrown some
errors. Then I reran the same script, whatever dbfs restored earlier are
skipped, and got the same errors.
Any insight?
Thanks, Ven
skipping datafile 2; already restored to file
/ORA_OEM/data/AUXI/dbf/sysaux01.dbf
skipping datafile 3; already restored to file
/ORA_OEM/data/AUXI/dbf/UNDO1.dbf
skipping datafile 4; already restored to file
/ORA_OEM/data/AUXI/dbf/UNDO2.dbf
skipping datafile 24; already restored to file
/ORA_OEM/data/AUXI/dbf/local_data02.4.dbf
skipping datafile 1; already restored to file
/ORA_OEM/data/AUXI/dbf/system.1.dbf
skipping datafile 18; already restored to file
/ORA_OEM/data/AUXI/dbf/local_idx02.3.dbf
skipping datafile 31; already restored to file
/ORA_OEM/data/AUXI/dbf/local_data02.11.dbf
skipping datafile 12; already restored to file
/ORA_OEM/data/AUXI/dbf/local_data01.7.dbf
skipping datafile 20; already restored to file
/ORA_OEM/data/AUXI/dbf/local_idx02.2.dbf
skipping datafile 23; already restored to file
/ORA_OEM/data/AUXI/dbf/local_data02.3.dbf
skipping datafile 15; already restored to file
/ORA_OEM/data/AUXI/dbf/local_idx01.2.dbf
skipping datafile 19; already restored to file
/ORA_OEM/data/AUXI/dbf/local_idx02.4.dbf
skipping datafile 32; already restored to file
/ORA_OEM/data/AUXI/dbf/local_data02.12.dbf
skipping datafile 9; already restored to file
/ORA_OEM/data/AUXI/dbf/local_data01.4.dbf
skipping datafile 11; already restored to file
/ORA_OEM/data/AUXI/dbf/local_data01.6.dbf
skipping datafile 33; already restored to file
/ORA_OEM/data/AUXI/dbf/local_idx01.3.dbf
channel d1: starting datafile backupset restore
channel d1: specifying datafile(s) to restore from backup set
restoring datafile 00013 to /ORA_OEM/data/AUXI/dbf/local_data01.8.dbf
restoring datafile 00027 to /ORA_OEM/data/AUXI/dbf/local_data02.7.dbf
restoring datafile 00030 to /ORA_OEM/data/AUXI/dbf/local_data02.10.dbf
channel d1: reading from backup piece
/home/oracle/backup/MERLIN/MERLIN__spicfgu1_1_1.FULL
channel d2: starting datafile backupset restore
channel d2: specifying datafile(s) to restore from backup set
restoring datafile 00021 to /ORA_OEM/data/AUXI/dbf/local_data02.1.dbf
restoring datafile 00026 to /ORA_OEM/data/AUXI/dbf/local_data02.6.dbf
restoring datafile 00029 to /ORA_OEM/data/AUXI/dbf/local_data02.9.dbf
channel d2: reading from backup piece
/home/oracle/backup/MERLIN/MERLIN__smicfgu1_1_1.FULL
channel d3: starting datafile backupset restore
channel d3: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /ORA_OEM/data/AUXI/dbf/local_data01.1.dbf
restoring datafile 00025 to /ORA_OEM/data/AUXI/dbf/local_data02.5.dbf
restoring datafile 00028 to /ORA_OEM/data/AUXI/dbf/local_data02.8.dbf
channel d3: reading from backup piece
/home/oracle/backup/MERLIN/MERLIN__slicfgu1_1_1.FULL
ORA-19870: error reading backup piece
/home/oracle/backup/MERLIN/MERLIN__spicfgu1_1_1.FULL
ORA-19502: write error on file "/ORA_OEM/data/AUXI/dbf/local_data02.10.dbf",
blockno 3593 (blocksize=16384)
ORA-27063: number of bytes read/written is incorrect
Additional information: 32768
Additional information: 131072
Outer dbms_backup_restore.restoreCancel() failed
ORA-19870: error reading backup piece
/home/oracle/backup/MERLIN/MERLIN__smicfgu1_1_1.FULL
ORA-19502: write error on file "/ORA_OEM/data/AUXI/dbf/local_data02.9.dbf",
blockno 6561 (blocksize=16384)
ORA-27063: number of bytes read/written is incorrect
Additional information: 98304
Additional information: 131072
Outer dbms_backup_restore.restoreCancel() failed
ORA-19870: error reading backup piece
/home/oracle/backup/MERLIN/MERLIN__slicfgu1_1_1.FULL
ORA-19502: write error on file "/ORA_OEM/data/AUXI/dbf/local_data02.8.dbf",
blockno 6209 (blocksize=16384)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 131072
Outer dbms_backup_restore.restoreCancel() failed
channel d1: reading from backup piece
/home/oracle/backup/MERLIN/MERLIN__snicfgu1_1_1.FULL
channel d2: reading from backup piece
/home/oracle/backup/MERLIN/MERLIN__soicfgu1_1_1.FULL
released channel: d1
released channel: d2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/13/2007 11:23:14
RMAN-03015: error occurred in stored script Memory Script
ORA-19870: error reading backup piece
/home/oracle/backup/MERLIN/MERLIN__snicfgu1_1_1.FULL
ORA-19615: some files not found in backup set
ORA-19613: datafile 30 not found in backup set
RMAN> **end-of-file**
Other related posts:
