Mushfique Khan
asked on
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!!!
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!!!
ASKER
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.
Query the DBA_DB_LINKS view and/or using SQL Developer (or TOAD) generate the code to replace them.
ASKER
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.
Please do update, if requires any more info and thanks a lot.
ASKER
got it too:
select * from dba_synonyms
where db_link is not null
select * from dba_synonyms
where db_link is not null
ASKER
Can you please advice/suggest, how to fix/correct this or do I need to start from scratch again ... ;-(
Please assist/guide ... thanks.