This forum is currently locked. You can't register or post questions at this time. (read more)

Rerunning RMAN duplicate (ASM based database)

All posts relating to Oracle database administration.

Moderator: Tim...

poojanathani
Advisor
Posts: 452
Joined: Tue Dec 07, 2004 3:10 pm
Location: London, UK

Rerunning RMAN duplicate (ASM based database)

Postby poojanathani » Sat May 12, 2012 6:44 pm

Hi Tim,

When we run a rerun a failed RMAN duplicate, it normally skips past through the files that are already restored.
But in case of ASM datafiles, RMAN attempts to restore the data files again because the files names are generated ones.

Wondering if there's any way to get around this situation ?

Thanks

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Rerunning RMAN duplicate (ASM based database)

Postby Tim... » Mon May 14, 2012 11:06 am

Hi.

Don't think there is. Using OMF to generate file names guarantees they are unique, which is why you get this situation. You can manually clean them up before a new run.

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

poojanathani
Advisor
Posts: 452
Joined: Tue Dec 07, 2004 3:10 pm
Location: London, UK

Re: Rerunning RMAN duplicate (ASM based database)

Postby poojanathani » Tue May 15, 2012 10:24 am

Thanks Tim.
Yes, manual cleanup is an option, but I was trying to avoid it.
Mainly because I was hoping if time could be saved by skipping past through the already restored files

But if there isn't any option, can't do much really.

Regards

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Rerunning RMAN duplicate (ASM based database)

Postby Tim... » Tue May 15, 2012 10:28 am

Hi.

Never say never, but I don't know of one. :)

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

poojanathani
Advisor
Posts: 452
Joined: Tue Dec 07, 2004 3:10 pm
Location: London, UK

Re: Rerunning RMAN duplicate (ASM based database)

Postby poojanathani » Tue Jun 26, 2012 7:48 am

Hi Tim,
Checked the metalink note :
Manual Completion of a Failed RMAN Duplicate [ID 360962.1]

3. Manual Completion of Phase 3:Recovery

$ rman target / auxiliary sys/oracle@<alias>

RMAN> run {
set new name for datafile n to 'X'; ** see Notes below re incrementals
set until scn 1412841;
recover clone database;
alter clone database open resetlogs;
}

But the contents of my failed duplicate log file say -

set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
.
.
.
.

(I wasn't very comfortable to use "set newname" as it might impact production. Instead used "set newname for clone .." as in the log file)

But it didn't work.

Still trying to find out the alternatives.

Restore/Recovery (of 1TB database) failing at about 99% and having to do all over againt is very time consuming.

Regards,

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Rerunning RMAN duplicate (ASM based database)

Postby Tim... » Tue Jun 26, 2012 8:20 am

Hi.

You said a lot of stuff, but I don't think you've actually asked a question. :) What do you want to know?

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

poojanathani
Advisor
Posts: 452
Joined: Tue Dec 07, 2004 3:10 pm
Location: London, UK

Re: Rerunning RMAN duplicate (ASM based database)

Postby poojanathani » Thu Jun 28, 2012 8:01 am

Sorry for that .. Got carried away !
Question remains the same actually - Is there any way to command RMAN to skip past through the already restored files using SET NEWNAME or any other clause ?

Thanks

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Rerunning RMAN duplicate (ASM based database)

Postby Tim... » Thu Jun 28, 2012 2:10 pm

Hi.

OK. So you were asking the initial question again. Then I guess I will post my initial answer again. :)

"Don't think there is. Using OMF to generate file names guarantees they are unique, which is why you get this situation. You can manually clean them up before a new run."

You can raise an SR to see if there is something clever you can do, but I don't think so.

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 5 guests

cron