این سایت تابع قوانین جمهوری اسلامی ایران است

Upgrade Oracle database from 11.2.0.4 to 18.3 Using DBUA

سلام 

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

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

  • Database Upgrade Assistant (DBUA)
  • Manual Upgrade
  • Transportable Tablespaces
  • Datapump export/import
  • Oracle Streams
  • Oracle GoldenGate 
اشاره کنیم.

من میخوام در اینجا از روش DBUA برای ارتقا بانکم استفاده کنم

Oracle Database Version:             Oracle Database 11gR2 (11.2.0.4) (64-bit)

Operating System:                         Oracle Enterprise Linux 6.4 (64-bit)


از دیتابیس 11 خودمون ابتدا بگاپ میگیریم
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 

ادامه مطلب


مشخصات

آخرین مطالب این وبلاگ

آخرین ارسال ها

آخرین وبلاگ ها

آخرین جستجو ها

شیرینگ پک، میکسر پودر، پرکن مایعات amoozesh navad خرید و فروش فلزیاب ، گنج یاب و طلایاب ، آسان فلزیاب فسانه تحقیق فتل فتلیان در حوالی اریحا... اتوکلاو نوشته های بی مخاطب!

درباره این سایت

  • این وبسایت تابع قوانین جمهوری مقدس اسلامی ایران بوده و در ستاد ساماندهی پایگاه های اینترنتی ثبت شده است.
  • تمامی محتوای موجود تماما خودکار از وبلاگ های فارسی دریافت میشود ؛ در صورت مشاهده هرگونه محتوای خلاف قوانین جمهوری اسلامی ایران ؛ گزارش دهید تا به قید فوریت حذف گردد.
©   تمامی حقوق مادی و معنوی این سایت متعلق به بیگ بلاگ بوده و محفوظ میباشد ، با هرگونه کپی بردای از طرح یا پوسته برخورد خواهد شد.