how to restore rman backup on different server

Подписаться 11 тыс.

Просмотров 31 тыс.

50% 1

#RMAN #RESTORATION #ORACLE
how to restore rman backup to new server
how to restore rman backup on same server
how to restore the rman backup to different server
how to restore rman backup on different server
Check all Command on following link
ocptechnology.com/restore-rma...
restore rman full backup to different server with different directory structure,
restore oracle database from rman backup to another server windows,
rman restore database from different backup location,
restore rman backup to different server with different database name,
steps to migrate oracle database from one server to another,
how to restore single datafile from rman backup,
restore control file from autobackup,
how to restore oracle database from tape backup,
Oracle Interview application play.google.com/store/apps/de...
Join Our Official Telegram Channel
👉t.me/ocptechnology
Chat with me on:
👉Join WhatsApp Group: whatsapp.com/channel/0029VaS0...
👉Join Telegram Group: t.me/+GyzG3cZgs3I4NWI1
My Facebook page / ocptechnology
My Second Channel / digitalshripal
My Instagram / ocptechnology
My Website ocptechnology.com/
My twitter / ocptechnology

Опубликовано:

14 июл 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 91

@saisruthi9609 4 года назад

Good video very useful to me. Please make one video transportable tablespace migration method also.happy friendship day

@ocptechnology 4 года назад

Thanks for your compliment, for tablespace migration you can watch following video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HfraLd2eRQ8.html Happy Friendship Day to you

@zardinho 4 года назад

The most easy to understand content of this subject that I ever seen! Congratulations, it helped me a lot.

@ocptechnology 4 года назад

Thank you brother

@shajalpandey1041 4 года назад

The best one certainly. There is clarity in explanation. Bravo!

@ocptechnology 4 года назад

Thanks for watching and your valuable feedback 😊

@park4567 4 года назад

Thank you for making this video. I was able to create the DB on the new server.

@ocptechnology 4 года назад

Thanks for watching brother

@KalleJohansson 4 года назад

Thank you so much - this was straight forward and easy and will help a lot

@ocptechnology 4 года назад

Thanks for watching

@OfflineSetup Год назад

excellent ... I wish more youtubers could be so clear and informative

@ocptechnology Год назад

thank you dear

@jazgh01 4 года назад

It has helped me a lot. Thank you. From Mexico

@ocptechnology 4 года назад

Thanks for watching, from India

@sadanb4876 5 лет назад

Extremely superb .much thanks brother .. please keep doing

@ocptechnology 5 лет назад

Thank you brother

@JohnBagabe 3 года назад

Very nice and indeed useful, Thank you

@akramimran72 2 года назад

Respect to you!!!, thank you for a wonderfull help.

@ocptechnology 2 года назад

Thank you dear

@twinkletwinkle2306 3 года назад

Thank you so much brother. It helps me a lot. Please Keep posting more videos । God bless you !!!

@ocptechnology 3 года назад

Thank you

@johnjosephtuibeo4021 3 года назад

You save my job man! keep it up!

@ocptechnology 3 года назад

Thanks for watching bro

@md.mehadihasan51 4 года назад

Best Tutorial ever I seen

@suneert.p7205 10 месяцев назад

Superb tutorial... Informative.. Cheers👍👍👍

@ocptechnology 10 месяцев назад

Thank you dear

@samreenshaikh1740 3 года назад

Very well explained superb

@sadanb4876 4 года назад

Very simple and super 👌 explained.

@ocptechnology 4 года назад

Thank you brother

@purplesta1n 4 года назад

Thank you for this awesome tutorial. What steps do I have to take if I want to use a different DB Name on the new host?

@josecausado1976 Год назад

Thank you very much for your video, but how would it be after a while passes as a differential backup is restored to the destination?

@user-iy9fp9uw5p 5 месяцев назад

just distrubed, love your videos!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! can you do more videos on performance tunning. Thanks!

@ocptechnology 5 месяцев назад

Thank you dear, I'll upload a performance video soon

@pauloandrade6843 5 лет назад

U r the man

@ramyasubramanian6207 2 года назад

Thanks alot for this video

@ocptechnology 2 года назад

Your welcome dear

@sanjeevkumarnarayanaswamy761 3 года назад

Beautiful video. Is it possible to make video on "restore RMAN incremental Level-0 and level-1 backup on different server

@ocptechnology 3 года назад

yes I'll upload it as soon as possible

@sadanb4876 3 года назад

Awesome

@user-yr1vz2po9y Месяц назад

thanks it was helpful

@ocptechnology Месяц назад

Thanks dear

@sathchithanand 5 лет назад

Great master

@ocptechnology 5 лет назад

Thank you brother

@muhsinbayer4537 2 года назад

Thanks!

@ocptechnology 2 года назад

😀

@pdesai77 2 года назад

Hi, one issues i ran in to is i copied pfile and started the clone db with nomount from pfile. however, when i go to RMAN --> rman target / it stays that connect connected to target database (not started) any guidance? I did export ORACLE_SID, set oracle_sid,

@ocptechnology 2 года назад

After nomount restore control file with rman then startup mount and then start recovery

@rahultambe6212 3 года назад

Nice vedio

@ocptechnology 3 года назад

Thank you dear

@rachanareddy4747 2 года назад

Thank you

@ocptechnology 2 года назад

Welcome dear

@ros.rafffran 4 года назад

Thanks I'll use to move /migrate a new phiscal server and from 11/4 to 19/3 , I'll let you know. Anyway one of the best on web!! Well Done

@ocptechnology 4 года назад

Thanks for watching, do subscribe my channel

@ashokkumar96760 10 месяцев назад

Hi , This is Ashok can you please do a video for me on " i taken backup of Source DB on 01.09.2023 and i copied it to Target Database server as nfs - type in mountoint u01. now i lost my controlfiles in that backup which is in Target server. "How to recover lost Controlfiles from backup in Target server. and Restore with that control files on 27.09.2023.

@JohnBagabe 3 года назад

Is it possiple to follow same steps restoring full rman backup from HP-UX server to be Restored on Redhat Linux Server(New Server) ? tel me thank you

@ocptechnology 3 года назад

Yes bro same steps

@JohnBagabe 3 года назад

@@ocptechnology Thank you, will do it and will update back, thanks

@AltafHussain-hy6fo Год назад

Hello, How to find memory total size and used size in oracle ( SGA and PGA total size and used size )

@jkvalley2332 3 года назад

1 question dear. can we restore db 11g to 19c RMAN backups from Solaris 10 to Oracle Linux 8 env, New machine with same Directory structure.?

@ocptechnology 3 года назад

Database version should be same for both machines source and destinations yes you can restore on the 19c machine but in that case you should be do upgradation steps

@jkvalley2332 3 года назад

@@ocptechnology Many thankx dear. Operating system .should be same ?

@ocptechnology 3 года назад

No, but if you are using linux -64 then restore on any linux -64 or if you are using windows-64 platform then you can restore on windows 64

@tohfatulislammilton9707 4 года назад

Dear please, 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?

@ocptechnology 4 года назад

Yes you can, just Install Oracle and use existing files

@tohfatulislammilton9707 4 года назад

Thank 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?

@jkvalley2332 3 года назад

can we restore db 11g to 12c RMAN backups from Solaris 10 to Solaris 11 OS, New machine with same Directory structure.?

@ocptechnology 3 года назад

Db version must be same

@jkvalley2332 3 года назад

@@ocptechnology . appreciated you have done a gr8 job. i hve done restore in different version and different OS version as well.

@luciasantana569 4 года назад

Hello when i ran catalog start with '....' it sentme an error with an important file backpu and when i tried to restore database it sentme an error channel ORA_DISK_1: reading from backup piece /oracle12/backup_10/full_qrue2pg9_45915_1 ORA-19870: error reading backup piece /oracle12/backup_10/full_qrue2pg9_45915_1 ORA-19505: failed to identify file "/oracle12/backup_10/full_qrue2pg9_45915_1" ORA-27037: unable to obtain file status IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3 failover to previous backup I think it is trying to read from the original location backup. do you know what could be my error?. thank you

@ocptechnology 4 года назад

Change your Backup location then try

@aniketbanerjee6377 4 года назад

the case here what you doing is manual restore with same DB name .In case want to use a different SID or DB name can do the same by RMAN active duplicate or RMAN duplicate option .

@ocptechnology 4 года назад

Restore the same, and rename your db after restoration completion. Watch my another video how to rename database

@ocptechnology 4 года назад

Watch for rename database ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VwmJXoN-Gkg.html

@amandeepgera4109 4 года назад

bhai ji 12c ki videos bhi bana lo...

@ocptechnology 4 года назад

Ok brother

@jkvalley2332 3 года назад

Dear Sir error Fatal NI connect error 12170. VERSION INFORMATION: TNS for Solaris: Version 11.2.0.3.0 - Production Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production Time: 23-JAN-2021 06:54:37 Tracing not turned on. Tns error struct ----------------------- alert logs is 90% full with this .plz help me . what should I do. ?

@ocptechnology 3 года назад

Both database version are same?

@jkvalley2332 3 года назад

@@ocptechnology ... DB is working there is no issue. how i can remove Fatal NI connect error...

@ocptechnology 3 года назад

Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP).

@adityadayal6805 2 года назад

Refresh database is same procedure ?

@ocptechnology 2 года назад

Yes dear, same

@krzysztofrz82 2 года назад

How can i restore database with lastest archive log? Greetings from Poland

@ocptechnology 2 года назад

I'll shar the video soon

@nishakicooking1236 4 года назад

When you copy spfile and password file to other server then you give sqlplus /as sysdba That database base should be start with his own spfile Why database take your copy spfile file

@ocptechnology 4 года назад

If you don't want to copy spfile from production server then you need to restore spfile from RMAN backup and in case of password file you can create it manually or copy it doesn't matter.

@amandeepgera4109 3 года назад

Please perform restore in RAC