Database Upgrade Methods? 

Database Upgrade Methods?
Most commonly asked interview question is What the different methods for database upgrade?
We have manual method for database upgrade
We have command lines for database upgrade
We have silent methods for database upgrade
We have GUI method for database upgrade
We have to choose our preferred method based on the various factors like environment, downtime, security use case, vulnerability many more.
Silent / Manual / Command line
==========================
a. SQL command prompt method:
sqlplus / as sysdba
SQL] catupgrd.sql
b. Perl script method
cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql
c. Shell script method
$ORACLE_HOME/bin/dbupgrade
GUI / UI
========
d. dbua GUI method
$ORACLE_HOME/bin/
./dbua --- Fully Automated
e. 19c New Feature
$autoupgrade - Fully Automated
create config file
analyse
deploy
$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -create_sample_file config
$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config cdbdev_db_config.cfg -mode ANALYZE
$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config cdbdev_db_config.cfg -mode DEPLOY
All about Database Upgrades!!!
More questions on the database upgrade.
1. What is database upgrade?
2. What is autoupgrade?
3. Is autoupgrade resumeble?
4. What is dbau?
5. Ie dbua resumeble?
6. What is GRP (guarantee restore point)?
7. Does GRP needs flashback to be enabled?
8. Does GRP need database to be archivelog mode?
9. What is timezone upgrade and how is this different from Database upgrade?
10. How to estimate database upgrade time? 10TB Vs 20TB database upgrade time.
11. Is GRP generates flashback logs? If yes then where they are located?
12. What happens to upgrade if FRA or archive destination is full?
13. Can we perform database upgrade in noarchivelog mode?
14. More objects on DBA_RECYCLEBIN will impact database upgrade?
15. Will stats of data_dictionary_views and fixed_objects impact my database upgrade?
16. Can I perform database upgrade in online mode?
17. What is out of place upgrade
18. Can we perform inplace database upgrade?
19. What are PROS and CONS of manual Vs dbua Vs autoupgrade?
20. How much time it will take for flashback database to GRP?
21. Can I flashback database to GRP in case it flashback logs are deleted at OS level?
#rac #database #asm #mallik034 #vismotechnologies #oracledba #oraclecarrers #oracleworld #training #onlinetraining #liveclasses #Upgrade
Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: mallikarjun.ramadurg@gmail.com / vismotechnologies@gmail.com / info@vismotechnologies.com