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 kzread.info/dash/bejne/epqmw66dYsi4gZs.html Happy Friendship Day to you

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

@ocptechnology

4 жыл бұрын

Thank you brother

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

@ocptechnology

4 жыл бұрын

Thanks for watching and your valuable feedback 😊

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

@ocptechnology

Жыл бұрын

thank you dear

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

@ocptechnology

4 жыл бұрын

Thanks for watching brother

Extremely superb .much thanks brother .. please keep doing

@ocptechnology

5 жыл бұрын

Thank you brother

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

@ocptechnology

4 жыл бұрын

Thanks for watching

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

@ocptechnology

4 жыл бұрын

Thanks for watching, from India

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

@ocptechnology

3 жыл бұрын

Thank you

Very nice and indeed useful, Thank you

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

@ocptechnology

10 ай бұрын

Thank you dear

Very well explained superb

Very simple and super 👌 explained.

@ocptechnology

4 жыл бұрын

Thank you brother

Best Tutorial ever I seen

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

@ocptechnology

2 жыл бұрын

Thank you dear

You save my job man! keep it up!

@ocptechnology

3 жыл бұрын

Thanks for watching bro

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?

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?

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

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.

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

Awesome

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

Thanks alot for this video

@ocptechnology

2 жыл бұрын

Your welcome dear

U r the man

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

thanks it was helpful

@ocptechnology

Ай бұрын

Thanks dear

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

Great master

@ocptechnology

5 жыл бұрын

Thank you brother

Nice vedio

@ocptechnology

3 жыл бұрын

Thank you dear

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 kzread.info/dash/bejne/iKuhrLqofpCtm8o.html

Thanks!

@ocptechnology

2 жыл бұрын

😀

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

Thank you

@ocptechnology

2 жыл бұрын

Welcome dear

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?

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

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

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.

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).

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

@ocptechnology

4 жыл бұрын

Ok brother

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.

Please perform restore in RAC

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

@ocptechnology

2 жыл бұрын

I'll shar the video soon

Refresh database is same procedure ?

@ocptechnology

2 жыл бұрын

Yes dear, same

How to restore with archive log in different server too?

@ocptechnology

4 жыл бұрын

Same brother, in end once you finished recovery, catalog with archives location and star recovery again simple.

@trionotriono8277

4 жыл бұрын

@@ocptechnology what happen with your website sir?ocptechnology.com