Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN duplicate after using Commvault restore to disk

unknown-3431574Nov 23 2017 — edited Nov 24 2017

I realise this is product specific, but thought I'd post here to see if anybody has had similar issues.

Oracle version is 12.1.0.2 on Windows 2012 R2 Datacenter

We use Commvault as our backup tool and we were wanting to duplicate from a backup taken prior to a resetlogs of the source database.

As per the Oracle documentation this can only be done if you're using either an rman catalog or duplicating from disk based backups.

We used the Commvault 'Restore to Disk' facility to copy the rman backup pieces for the relevant backup to disk on the host for the duplicate database.

When running the 'duplicate ... from ...' we encountered the following error ;

ORA-19870: error while restoring backup piece E:\ORADB\XXXX\YYYY_DISK_BASED_DUPLICATE\727032\DD_FILES\C-3943741802-20171121-01

ORA-19505: failed to identify file "E:\ORADB\XXXX\YYYY_DISK_BASED_DUPLICATE\727032\DD_FILES\C-3943741802-20171121-01"

ORA-27046: file size is not a multiple of logical block size

OSD-04000: logical block size mismatch (OS 512)

The blocksize for the tape backup was 1048576, so my feeling is that this is where the root of the issue lies and was wondering if anyone else had tried this and found a solution.

I've been playing with dd (we use MKS Toolkit on some Windows hosts) but without any success.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2017
Added on Nov 23 2017
11 comments
2,751 views