Duplicate ASM DB to Filesystem DB

[peterx]

hi Tim and all,

I want to ask if I have a 2 nodes RAC running on ASM, needed to clone / migrate / duplicate to another standalone instance running
or OS filesystem.

1. Any good method ?

2. If I want to use rman duplicate, do you have any example on this ? I search many is ASM to ASM or FS to ASM,
i never found ASM to FS !


thanks.

[Tim...]

Hi.

I don;t have a specific example of those, but as far as RMAN is concerned, if the CONVERT parameters are set to convert file system location to an ASM location (or vice versa) it doesn't care where the data file are.

http://www.oracle-base.com/articles/11g ... -11gr2.php

As for RAC to non-RAC, that doesn't make much difference, provided the duplicate has cluster_database=false in the parameter file.

Cheers

Tim...

[peterx]

hi Tim,

very thanks!

I try to follow this:

http://mohamedazar.files.wordpress.com/ ... to-non.pdf

also, long time ago, I consume your doc and got the method of "duplicate from live db".


I think i can almost finish the ASM to FS, but error occurred:

I use this command =
RMAN>
duplicate target database to DESTDB;
...
...
...

Code: Select all

input datafile copy RECID=9 STAMP=799463576 file name=/u02/oradata/rachome/datafile/users.259.785569335
datafile 5 switched to datafile copy
input datafile copy RECID=10 STAMP=799463576 file name=/u02/oradata/rachome/datafile/undotbs2.264.785569465

contents of Memory Script:
{
   set until scn  1883386;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 16-NOV-12
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '/u02/oradata/rachome/datafile/sysaux.257.785569335'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/16/2012 01:12:58
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 2 with sequence 44 and starting SCN of 1852669 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 47 and starting SCN of 1883378 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 46 and starting SCN of 1852672 found to restore



Is this my backup file has problem?
I use rman to backup my RAC FRA to disk.

Please help!

thanks.

[Tim...]

Hi.

It would appear you are trying to recover to a point in time earlier than the backup file itself. Either use an older backup file, or recover to a later point in time.

Cheers

Tim...

[peterx]

hi Tim,

very thanks, yes......i think you're right!

Also, finally, I think is related to my backup content.

I changed my backup method. And success duplicate the ASM DB to FS.

thanks for your help!

[Tim...]

Cool!