Your documentation works when I followed it to the dot. Thanks a lot. I've been working on this for more than two weeks now. But after I watched this video, everything worked in my first try. Thanks a lot.
Hi there friend. I'm glad you put up this video. I am learning Oracle Administration and hopefully this year 2013 will transition me to work in IT from a non IT job that I have now. Thank you.
quite helpful. Can you please narrate about whats the difference between cloning with RMAN and cloning without RMAN, in which we take DBF files in an alternate location, create initOra file set db_name=standby db and backup controlfile to trace and initiate a new instance (windows only) . do you recommend doing this procedure if not then please shed some light why thanks
Hi Wysheid , Thanks for uploading such an important video. May I know while using the "run" block in the RMAN , why release channel had not been used? Also can u share the URL for Manual steps of database cloning?
Hi Wysheid Thanks for your reply. Can you please let me know which one we need to know well? 10G RAC installation or 11g RAC installation. Can you please share the steps for the same ?
Hi Wysheid, Thanks For the video( entire series). Is it possible to do a Point in Time clone to another database? the clonedb not in sync with primedb, but to clone it to some prior time period, that I could specify ? If so, can you help me understand? Thank You in Advance.
Hi, What is the necessity of coping backup pieces from prime to clone we are connecting to prime dB while restoration so does the clone dB will pull peices from prime or clone flash location. Thanks in advance, Rasool. Shaik
Sir, I have a doubt..At 29:49. You mentioned that we should transfer the backup pieces exactly in same location in destination. What if that whole Drive is not available in destination?
Is there any necessity of creating a password file? and how to connect to source and target database if don't know the password of system user( consider in the production database and if we don't privilege to change the password of system user)
Hello Wysheid- I have a same question as the one you've answered |connect target sys/passwd@servicename| but what if I had to restore where I have no connectivity to the source DB like if I were to provide this backup to vendor and they cannot connect to the source production db. Will the refresh fail ??
No , in that case u have to do the following 1) startup auxiliary instance 2) Restore spfile 3) Restore controlfile and mount the db 4) Restore datafiles and recover db
+ALLAHpleasehelp True ..but this is a lab environment , correct ..? . If your DB is below 200 GB , you can consider exp/imp .. but if the DB size is more RMAN cloning is far better than exp and imp .. Thanks, Wysheid Team
Do we know why this command was used "connect target sys/pwd@serv" since it was the rman backup that were consumed, what's the purpose of connecting to source db ?
+ALLAHpleasehelp Thanks for the valuable feedback. My videos are taken without any prior preparation . So there are chances some mistakes may happen. As a professional DBA , i am giving importance to deliver the concepts clear than the typos. Again thanks, i will try to correct them in future videos
Your documentation works when I followed it to the dot. Thanks a lot. I've been working on this for more than two weeks now. But after I watched this video, everything worked in my first try. Thanks a lot.
Hi there friend. I'm glad you put up this video. I am learning Oracle Administration and hopefully this year 2013 will transition me to work in IT from a non IT job that I have now. Thank you.
Awesome post...crisp voice and nice representation.
Thanks you Sir.
thnaks thank you very much for this video...
pls keep uploading such video....................
thanks for such a great video... awesome. please keep uploading.. thanks....
I took training from Wysheid on RMAN. He is so good. -- Logan
This was what i have been looking for. awesome upload. And please do upload how to upgrade 10g database to 11g database.
Sir, thats awesome
very concise.beautiful. Thanks
great work, thanks for sharing...
help full nic video.....
most definite sub and tu on this .
The topic above is discussed in a professional manner. Can you provide me the information where to get all video tutorials for Oracle 11g.
Hi Roopa,
Thanks for your comment . Please subscribe to the channel to get more 11g videos
quite helpful. Can you please narrate about whats the difference between cloning with RMAN and cloning without RMAN, in which we take DBF files in an alternate location, create initOra file set db_name=standby db and backup controlfile to trace and initiate a new instance (windows only) . do you recommend doing this procedure if not then please shed some light why
thanks
Hi Wysheid ,
Thanks for uploading such an important video. May I know while using the "run" block in the RMAN , why release channel had not been used? Also can u share the URL for Manual steps of database cloning?
Thank you.
i subscribed your channel by the way thanks ;)
awesome :)
Hi Wysheid
Thanks for your reply.
Can you please let me know which one we need to know well? 10G RAC installation or 11g RAC installation. Can you please share the steps for the same ?
Hi Wysheid, Thanks For the video( entire series). Is it possible to do a Point in Time clone to another database? the clonedb not in sync with primedb, but to clone it to some prior time period, that I could specify ? If so, can you help me understand? Thank You in Advance.
nice !
Hi,
What is the necessity of coping backup pieces from prime to clone we are connecting to prime dB while restoration so does the clone dB will pull peices from prime or clone flash location.
Thanks in advance,
Rasool. Shaik
Sir, I have a doubt..At 29:49. You mentioned that we should transfer the backup pieces exactly in same location in destination. What if that whole Drive is not available in destination?
1) you can create soft link 2) you can catalog the backup pieces in the new locations and restore
@@wysheid2009 Thank you very much.❤️
Is there any necessity of creating a password file? and how to connect to source and target database if don't know the password of system user( consider in the production database and if we don't privilege to change the password of system user)
Hello Wysheid-
I have a same question as the one you've answered |connect target sys/passwd@servicename| but what if I had to restore where I have no connectivity to the source DB like if I were to provide this backup to vendor and they cannot connect to the source production db. Will the refresh fail ??
No , in that case u have to do the following
1) startup auxiliary instance
2) Restore spfile
3) Restore controlfile and mount the db
4) Restore datafiles and recover db
will restore controlfile create control file with DBNAME as primdb or clonedb??
B Kanth
primary db
I recommend import export 5 min clone
+ALLAHpleasehelp True ..but this is a lab environment , correct ..? . If your DB is below 200 GB , you can consider exp/imp .. but if the DB size is more RMAN cloning is far better than exp and imp ..
Thanks,
Wysheid Team
Do we know why this command was used "connect target sys/pwd@serv" since it was the rman backup that were consumed, what's the purpose of connecting to source db ?
Hi Neeraj,
While performing the cloning , the RMAN takes the snaphot of the database physical structure by connecting to the source database.
yup
Sir.where is manual method video of doing same .. thank you in advance pls share link
Warning: Too many typo and backspaces! viewer distractions adviced
+ALLAHpleasehelp Thanks for the valuable feedback. My videos are taken without any prior preparation . So there are chances some mistakes may happen. As a professional DBA , i am giving importance to deliver the concepts clear than the typos. Again thanks, i will try to correct them in future videos
What if i have a full bkp of a database which is in NO ARCHIVELOG mode.. can i be able to do the clone of that database ?
Yes , Its possible
No idea what this guy is saying.
Its a video on database clone using RMAN :-)