Duplicate ASM DB to Filesystem DB

All posts relating to Oracle database administration.

Moderator: Tim...

Duplicate ASM DB to Filesystem DB

Postby peterx » Thu Nov 15, 2012 2:44 pm

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.
peterx
Senior Member
 
Posts: 186
Joined: Wed Feb 09, 2011 7:07 am

Re: Duplicate ASM DB to Filesystem DB

Postby Tim... » Thu Nov 15, 2012 2:55 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Duplicate ASM DB to Filesystem DB

Postby peterx » Thu Nov 15, 2012 5:20 pm

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.
peterx
Senior Member
 
Posts: 186
Joined: Wed Feb 09, 2011 7:07 am

Re: Duplicate ASM DB to Filesystem DB

Postby Tim... » Thu Nov 15, 2012 5:38 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Duplicate ASM DB to Filesystem DB

Postby peterx » Thu Nov 15, 2012 5:55 pm

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!
peterx
Senior Member
 
Posts: 186
Joined: Wed Feb 09, 2011 7:07 am

Re: Duplicate ASM DB to Filesystem DB

Postby Tim... » Thu Nov 15, 2012 6:06 pm

Cool! :)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests

cron