Upgrade Oracle database from 11.2.0.4 to 18.3 Using DBUA

سلام 

قصد داریم در مقالاتی انواع و روش های Upgrade به نسخه های مختلف Oracle را توضیح بدم .در این مقاله هدف ارتقا دیتابیس از 11.2.0.4 به 18.3 هست

 روش های مختلف ارتقا  میتونیم به 

• Database Upgrade Assistant (DBUA)
• Manual Upgrade
• Transportable Tablespaces
• Datapump export/import
• Oracle Streams
• Oracle GoldenGate 
  

RMAN> run{
2> backup database plus archivelog;
3> backup current controlfile;
4> backup spfile;
5> }


Starting backup at 17-MAR-19
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=1 STAMP=1003107329
channel ORA_DISK_1: starting piece 1 at 17-MAR-19
channel ORA_DISK_1: finished piece 1 at 17-MAR-19
piece handle=/oracle/fast_recovery_area/ORCLTEST/backupset/2019_03_17/o1_mf_annnn_TAG20190317T005530_g8ttgb5z_.bkp tag=TAG20190317T005530 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-MAR-19

Starting backup at 17-MAR-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/oradata/orcltest/system01.dbf
input datafile file number=00002 name=/oracle/oradata/orcltest/sysaux01.dbf
input datafile file number=00005 name=/oracle/oradata/orcltest/example01.dbf
input datafile file number=00003 name=/oracle/oradata/orcltest/undotbs01.dbf
input datafile file number=00004 name=/oracle/oradata/orcltest/users01.dbf
channel ORA_DISK_1: starting piece 1 at 17-MAR-19
channel ORA_DISK_1: finished piece 1 at 17-MAR-19
piece handle=/oracle/fast_recovery_area/ORCLTEST/backupset/2019_03_17/o1_mf_nnndf_TAG20190317T005531_g8ttgcf9_.bkp tag=TAG20190317T005531 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 17-MAR-19
channel ORA_DISK_1: finished piece 1 at 17-MAR-19
piece handle=/oracle/fast_recovery_area/ORCLTEST/backupset/2019_03_17/o1_mf_ncsnf_TAG20190317T005531_g8ttgvhj_.bkp tag=TAG20190317T005531 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-MAR-19

Starting backup at 17-MAR-19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=2 STAMP=1003107348
channel ORA_DISK_1: starting piece 1 at 17-MAR-19
channel ORA_DISK_1: finished piece 1 at 17-MAR-19
piece handle=/oracle/fast_recovery_area/ORCLTEST/backupset/2019_03_17/o1_mf_annnn_TAG20190317T005548_g8ttgwng_.bkp tag=TAG20190317T005548 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-MAR-19

Starting backup at 17-MAR-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 17-MAR-19
channel ORA_DISK_1: finished piece 1 at 17-MAR-19
piece handle=/oracle/fast_recovery_area/ORCLTEST/backupset/2019_03_17/o1_mf_ncnnf_TAG20190317T005549_g8ttgysg_.bkp tag=TAG20190317T005549 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-MAR-19

Starting backup at 17-MAR-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 17-MAR-19
channel ORA_DISK_1: finished piece 1 at 17-MAR-19
piece handle=/oracle/fast_recovery_area/ORCLTEST/backupset/2019_03_17/o1_mf_nnsnf_TAG20190317T005551_g8ttgzy2_.bkp tag=TAG20190317T005551 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-MAR-19