• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

Clone databases using RMAN backup

Hi, need some assistance, have to clone 2 dbs; one RAC/2 nodes & one standalone from rman backup of another & different db/s (RAC & standalone) running on different Solaris box.

Do update, if able to assist or can provide some steps/hints/links or any kind of assistance, will be highly appreciated.

Thanks in advance.
Mushfique Khan
Mushfique Khan
  • 4
  • 3
2 Solutions
Hi I hope this help with your tasks

what ia have done when i'm doing data guard to replicate the database is this:

rman target / log=/path/you/want/rman_backup.log
ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT '/path-of-the-backup/date/%U';

and for the restore:

Be sure to have a  copy of the pfile where you want  to restore, if you only have spfile then create an pfile, and while you are restoring be sure have the cluster parameter as false into the pfile.

rman nocatalog

  connect target /

shutdown abort;
startup nomount;

    alter database mount;
    CATALOG START WITH '/path/where-is the backup/' NOPROMPT;
    restore database;
    recover database;

Note:probably you will need to restore control files first before do all restore, check on you log what is the name of that backup of control files.

after finish the restore then:

shutdown immediate;

sqlplus  / as sysdba
Perhaps you would get better instructions if you Read The Fine Manual:
Oracle® Database Backup and Recovery User's Guide
Mushfique KhanDirector OperationsAuthor Commented:
thanks folks, I was able to restore, using RMAN, basically I left it in the night and when got back in morning, saw that something got failed due to 100% file system error.

Can you please advice/suggest, how to fix/correct this or do I need to start from scratch again ... ;-(

Please assist/guide ... thanks.
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

You may need to make space or re-locate some files using the "SET NEWNAME FOR ..."

When you restart the restore, rman will detect and skip files already restored...

Good luck!

PS: Make sure you do not move files already restored!!!
Mushfique KhanDirector OperationsAuthor Commented:
Was able to fix all these and now the clone/refresh got completed, need one assistance here, how to update db links, because they are pointing to wrong database now, is there any way to figure it out and correct/update all of the db links?
You will need to re-create them.
Query the DBA_DB_LINKS view and/or using SQL Developer (or TOAD) generate the code to replace them.
Mushfique KhanDirector OperationsAuthor Commented:
Thanks for this MikeOM_DBA, but this not about recreating, basically they are linking to a different db; e.g., we clone RAC2 to RAC1, but the db links are still linking to RAC2, where as they should be RAC1, task is to find out how many of db links are still targeting to RAC2 and update/correct or even recreate them linking to RAC1 ... is this clarify the situation.

Please do update, if requires any more info and thanks a lot.
Mushfique KhanDirector OperationsAuthor Commented:
got it too:

select * from dba_synonyms
where db_link is not null
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now