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..
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?
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 !!!
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.
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
Well done sir ., I’m a big fan of u😍
Glad to hear that! Thank you so much.
Very clearly explained....good going
Thank you for your great help!
Happy to help!
Excellent explanation sir
when i start playing this video i do not think this much your dba genesis buddy
Thanks a lot for sharing your excellent video. Great !
Thank you!
thanks for video :)
Welcome!
superb video and explanation also very good.
Thank you!
thank you DBA Genesis
Thank you so much.
You're welcome!
My question is test server you can install Oracle setup software only if yes or not
Gem video.. thank you
Welcome
Awesome! Thanks
Thanks sharing the info, please make video on how to troubleshoot on increasing of temp tablespace
Really awesome...
Thank you!
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..
its awesome video. it is very useful for me.
Thank you!
Can we restore in existing test database, without changing control file, pfile
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?
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.
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
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?
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.
What tool or what methods can I use to make sure I don't duplicate data when cloning?
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 .
thank you so much...
Welcome
how come you 'alter database open' without recovery ? without applying any archives
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
How we can clone database using stand-by database backup.
Primary: asm filesystem
Standby: normal filesystem
Db in sync .
Why used so complex steps for the the rman cloning
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.
great
Thank you!