errors with rman duplicate

From: vnr1995 <vnr1995_at_gmail.com>
Date: Tue, 13 Mar 2007 11:39:16 -0400
Message-ID: <b86c876f0703130839w440282cbo29c9873034699622@mail.gmail.com>

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**

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 13 2007 - 10:39:16 CDT