form next time onwards plz use white background unable to see codes properly had to use full brightness. And commands not visible while writing bcz of UA-cam buttons try editing video and moving it up a bit so slider wont come in middle of commands.
This was very clear, so in this script, how can we get email alerts, when Rman backup has failed. If you have those email alert scripts, please share us. Thanks.. Always we were connect to the server, we have checking these backps have success or not..
We can clone the dB with out taking the backup because from 12c oracle introuced active cloning so automatically it will take the backup through online !!!
Arun, I have a doubt about the "restore controlfile to ..." DONE ON SOURCE DB instead of backup format "...." current controlfile : Why are we use restore instead of backup? at location 3:14 in video.
Dear, could you please help me with the scenario where my database server's operating system has failed and I need to reinstall it. Also the database was in no archive log mode and has no backup. But, the previous database files are still there in the ora home directory. Can I restore the database after reinstalling oracle and using .dbf files, control files, redo log files, pfile, spfile and other files of the previous database?
You should be able to use the database. Install Oracle, setup bash profile, take db to nomount, then mount and try to open once. Most probably it will ask for recovery, try to recover with available redo logs and then open it.
@@dbagenesisThank you so much for your reply. At last, I am now able to restore a database with such scenario. Only things I'm facing this time are some error message like- ORA-00604: error occurred at recursive SQL level 1, ORA-06553: PLS-801: internal error [56327], ORA-06553: PLS-801: internal error [56327]. Though all previous data was restored. Do you have any idea on this?
I have 2 vm's In first one i have simlab database. Created by dbca and one another vm there is also simlab database but manually created Is it possible to clone anyone of dB ?
u save my life, thanks for your complete step by step video, i was here for the rename DB after clone Step.
Glad to hear that
There are not very many resources available for this old database version. Thank you for this excellent post.
great class, my friend! thank you very much
Very clearly explained....good going
Thank you for your great help!
Happy to help!
Well done sir ., I’m a big fan of u😍
Glad to hear that! Thank you so much.
Awesome! Thanks
Thanks a lot for sharing your excellent video. Great !
Thank you!
Excellent explanation sir
thank you DBA Genesis
when i start playing this video i do not think this much your dba genesis buddy
Thank you so much.
You're welcome!
thanks for video :)
Welcome!
Gem video.. thank you
Welcome
Really awesome...
Thank you!
superb video and explanation also very good.
Thank you!
My question is test server you can install Oracle setup software only if yes or not
Thanks sharing the info, please make video on how to troubleshoot on increasing of temp tablespace
form next time onwards plz use white background unable to see codes properly had to use full brightness. And commands not visible while writing bcz of UA-cam buttons try editing video and moving it up a bit so slider wont come in middle of commands.
This was very clear, so in this script, how can we get email alerts, when Rman backup has failed. If you have those email alert scripts, please share us. Thanks..
Always we were connect to the server, we have checking these backps have success or not..
Excelent, thanks
You are welcome!
We can clone the dB with out taking the backup because from 12c oracle introuced active cloning so
automatically it will take the backup through online !!!
12c new future
thank you so much...
Welcome
its awesome video. it is very useful for me.
Thank you!
how to perform restore if backup in a shared network drive, without copying backup pies to the target server.
plz provide these steps. thanks
Quick questions: is the target server a completely different server? or same server on which you plan to restore?
Arun, I have a doubt about the "restore controlfile to ..." DONE ON SOURCE DB instead of backup format "...." current controlfile : Why are we use restore instead of backup? at location 3:14 in video.
How about target DB.should install oracle software before clone or create only home directory. please share I have a doubt on this.Thanks
You should install at least oracle software.
Dear, could you please help me with the scenario where my database server's operating system has failed and I need to reinstall it. Also the database was in no archive log mode and has no backup. But, the previous database files are still there in the ora home directory. Can I restore the database after reinstalling oracle and using .dbf files, control files, redo log files, pfile, spfile and other files of the previous database?
You should be able to use the database. Install Oracle, setup bash profile, take db to nomount, then mount and try to open once.
Most probably it will ask for recovery, try to recover with available redo logs and then open it.
@@dbagenesisThank you so much for your reply. At last, I am now able to restore a database with such scenario. Only things I'm facing this time are some error message like- ORA-00604: error occurred at recursive SQL level 1, ORA-06553: PLS-801: internal error [56327], ORA-06553: PLS-801: internal error [56327]. Though all previous data was restored. Do you have any idea on this?
great
Thank you!
Can we restore in existing test database, without changing control file, pfile
How we can clone database using stand-by database backup.
Primary: asm filesystem
Standby: normal filesystem
Db in sync .
What tool or what methods can I use to make sure I don't duplicate data when cloning?
how come you 'alter database open' without recovery ? without applying any archives
Why didnt u change the db_name in starting when we were replacing other parameters for n pfile?
Bacuse in control file restore DB name is of source else it will fail to restore .
At 13:59, can't we use db_file_name_convert ?
Yes we can, I have updated same on our support website --> Article RMAN Duplicate
I have 2 vm's
In first one i have simlab database. Created by dbca and one another vm there is also simlab database but manually created
Is it possible to clone anyone of dB ?
Yes, you can clone the DB but with a different name.