Re: errors with rman duplicate
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: vnr1995@xxxxxxxxx
- Date: Tue, 13 Mar 2007 18:54:33 +0300
Hey,
Have you test your last backup before you do the cloning? (duplicate)
I would suggest you to do the following in order to know that the bakcups
are valid.
restore validate database
The following errors from the error list which you have given:
ORA-19615: some files not found in backup set
ORA-19613: datafile 30 not found in backup set
Looks like these are missing from the backupset.
Try to look for the datafiles which actually need backups from the last
backups using REPORT NEED BACKUP command at RMAN.
On 3/13/07, vnr1995 <vnr1995@xxxxxxxxx> wrote:
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**
--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
Other related posts:
