Re: errors with rman duplicate

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_at_gmail.com> 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."

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