How to upgrade Oracle 11 2 0 4 to 19 3 using RMAN backup

How to upgrade Oracle 11 2 0 4 to 19 3 using RMAN backup
#upgrade #oracledatabasetutorial #oracledatabasetutorial
#upgradeoracle11gto19cusingrman
00:00 Introduction
00:18 Create a User for testing
00:40 Check Database Registry
00:51 Create RMAN Backup
00:14 Create pfile from spfile
01:28 Action on 19c Machine
01:41 Edit the Pfile
02:06 Start Database with 19c environment till nomount using pfile
02:25 Restore the controlfile
03:00 Restore and Recover the database
03:08 Restoration Completed
03:15 Startup database in degradation option
04:08 run catupgrd script
04:41 Monitor degradation logs
05:35 Compile invalid objects
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 Gadgets:
👉Mic amzn.to/3lYLBW8
👉Laptop amzn.to/3ndktCa
👉Mouse amzn.to/3jn58Ok
Chat with me on:
👉Oracle Interview application play.google.com/store/apps/de...
👉Facebook page / ocptechnology
👉Instagram / ocptechnology
👉Website ocptechnology.com/
👉Twitter / ocptechnology

Пікірлер: 8

  • @AltafHussain-hy6fo
    @AltafHussain-hy6fo Жыл бұрын

    Hello, What to do with a query, if a query is generating more redo/archive log?

  • @Akkipatil-iy3uc
    @Akkipatil-iy3uc11 ай бұрын

    And what about time zone

  • @vinukondakalyan9798
    @vinukondakalyan9798 Жыл бұрын

    Bro make a video on HOW TO SETUP 2 NODE RAC DR

  • @ocptechnology

    @ocptechnology

    Жыл бұрын

    Ok bro

  • @varunyadav85

    @varunyadav85

    11 ай бұрын

    What about upgrading the time zone to 35 aand compatible parameter 19 c will it required? Thanks for video

  • @viniciusrw
    @viniciusrwАй бұрын

    Hello, I tried just following your steps, but when I run $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql, received : ERROR at line 13: ORA-00942: table or view does not exist SQL> SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE 2 ; SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE * ERROR at line 1: ORA-01722: invalid number In my original database I did not run any pre-upgrade script, should I run it before performing the backup to correct these errors?

  • @ocptechnology

    @ocptechnology

    Ай бұрын

    Yes, you should create backup

  • @viniciusrw

    @viniciusrw

    Ай бұрын

    @@ocptechnology Hello, I'm a bit of a detail oriented person, so I should run the scripts on the source base and then proceed with the backup to restore on the destination base, right?