This blog presents Oracle DBA Videos.An Audio visual Demo of some of the operations a DBA encounters in his day to day life.
NOTE:
All the videos in this blog are High Definition Videos most with Audio. The videos are best watched in full screen with "HD option enabled". You would also find screenshots and some handy scripts for DBAs.
Wednesday, January 27, 2010
How to clone a database when the source database is unavailable?
Recently I came across a situation, where I had to clone a database from the rman backup of the source. The source database was decommissioned and there was no way to connect to the source database. How do I clone the auxiliary database with the source being unavailable? Because we usually connect to target and auxiliary and issue the command:
DUPLICATE TARGET DATABASE TO "TEST" (but we cant use this command, because target is unavailable).
Scenario: Source: PROD Files: /data01/PROD/oradata Target: TEST Files: /data01/TEST/oradata
Here is a work around I found (There probably other ways to do this): a) Temporarily name the target database as source ie PROD. b) Prepare the init
thanks. you may also try the sql recovery program, it quickly parses corrupted files of specified format and retrieves the source data from affected documents when possible. It may become a good addition to other ways of keeping your data safe
Hi, to avoid anonymous unwanted comments change the comment settings comment moderation to always
else someone will post nude pictures sexual links, to avoid that, change your comment settings. login to your blog dashboard settings-->comment--> comment moderation to always
thanks. you may also try the sql recovery program, it quickly parses corrupted files of specified format and retrieves the source data from affected documents when possible. It may become a good addition to other ways of keeping your data safe
ReplyDeleteHi,
ReplyDeleteto avoid anonymous unwanted comments change the comment settings comment moderation to always
else someone will post nude pictures sexual links, to avoid that, change your comment settings.
login to your blog dashboard
settings-->comment--> comment moderation to always
hope, this will helps you.
I got the same issue. thats why. i wrote this.
Regards,
Rajeshkumar
http://oracleinstance.blogspot.com