还剩3页未读,继续阅读
文本内容:
模拟磁带库Oracle
一、磁带机配置、带库的存放路径1/opt/mhvtl/、安装带库驱动2一SUcd/stage/TYPEunzipV137394-
01.zipcd/usr/local/mkdir-p oracle/backupl_linux.x64_release/setup secureBackup.Thisto afilesystem directoryThis■installat4on containsOracle secure Backup version
12.
1.
0.
2.
1.Please waita momentwhile Ilearn aboutthis host...done.
1.Iinux86_64administrative server,media server,clientoracle secure Backup installationtools...done.Iinux86_64administrative server,media server,client...done.Loading oforacle secureBackup softwareis complete.choose fromone ofthe following options.The thesoftware optionyou choosedefinescomponents tobe installed.Configuration ofthis hostisrequired afterYou caninstall thesoftware onthis hostin installationis complete,one ofthefollowing ways:a administrativeserver andclientb clientif you arenot surewhich optionsecure pleaserefer to[al:the OracIeBackupinstallation Guideacd oracle/backupshould now enter an email addressuser,for theOracle secureBackupadrrnn emailYOUoraclesecureBackupuses thisreports andtoaddress to send job summarynotify theuser whena blank,you canset itlater jobrequires input,if youleave thisobtoolsusing thechuser command.Please enterthe adminemai1address:选择a输入管理员邮件地址输入n输入密码遍4poooe.=.wrof oO1rr33gydd ggcbbohI3c3codaoosakkr-1sppcuu/erTpepoBAcEgao3k/r0ta2rocholot•fa•co21•ea administrativeserver andclientb clientifyou arenot surewhich optionSecure pleaserefer tothe oracleYOU shouldnowenteranemail address fortheBackup installationGuide[a]:a OraclesecureBackupadrrnn user,oracle secureBackupuses thisemail addresstosendjobsummaryreportsand tonotify theuser whena jobrequires input,ifyouleave thisblank,you canset itlater usingthe obtoolschuser command.Please enterthe adminemailaddress:you want to changeany advancedsettings yor n[n]:nDOPlease enterkeystore password:Re-type passwordfor verification:Please enteradmin password:Re-type passwordfor verification:Note:This outputshows services only and does not include nativeconfiguration data might be overridden bynativesystemd services,systemdconfiguratif youwant tolist systemdservices usesystemctl11st-unit-files,.see services enabled on particularTOtarget usesystemct1list-dependencies[target].Note:This outputshows Sysvservicesonlyanddoesnotincludenative systemdservices,sysv configurationdatamightbeoverriddenbynative systemdconfiguration.If youwanttolist systemdservices usesystemct!In st-unit-files.To seeservicesenabledonparticulartarget use,systemct!list-dependencies[target],.oracle SecureBackup wasinstalled[rootedb backup]#启动带库并加入开机自启动systemctl startobservicedsystemctl enableobserviced带库启动后,会占用端口,443可以通过进行查看,netstat-ntpl|grep443可以通过查看进程启动是否正常systemctl statusobserviced可以通过浏览器访问:〃https:
192.
168.
0.71:
443、通过脚本配置带库3#obtoolmkdev-ttape-o-a$S_HOSTNAME:$TAPE08-1Hb02-d8tape08#-obtoolIsdev-gtape08#sleep2obtoolIsdevsleep2obtoolinventory-LlibOl#■obtoolinventory-L11b022/dev/nullobtoolmkuseroracle-classoracle-passwordoraclel23—preauth$S_HOSTNAME:oracle+rmanobtoolIsusersleep2obtoolmkmf$S_HOSTNAMEobtoolmkmfsexampleobtoolIsmfsleep2[root@d6TAPE]*./osb.shsdev_scandir_sort:leftparsefailed:nvmeOnlsdev_scandir_sort:leftparsefailed:nvmeOnlOsdev_scandir_sorr:leftparsefailed:nvme0n6sdev_scandir_sort:leftparsefailed:nvmeOnlsdev_scandir_sort:leftparsefailed:nvmeOnSsdev_scandir_sort:leftparsefailed:nvme0n9sdev_scandir_sort:leftparsefailed:nvme0n2sdev_scandir_sort:leftparsefailed:nvme0n5sdev_scandir_sort:leftparsefailed:nvmeOnllsdev_scandir_sort:leftparsefailed:nvme0n2sdev_scandir_sorr:leftparsefailed:nvme0n9sdev_scandir_sort:leftparsefailed:nvme0n7sdev_scandir_sort:leftparsefailed:nvmeOnlsdev_scandir_sort:leftparsefailed:nvme0n8sdev_scandir_sort:leftparsefailed:nvme0n6sdev_scandir_sort:leftparsefailed:nvmeOnlOsdev_scandir_sorr:leftparsefailed:nvme0n4sdev_scandir_sort:leftparsefailed:nvmeOnlsdev_scandir_sort:leftparsefailed:nvmeOnlOsdev_scandir_sort:leftparsefailed:nvme0n6sdev_scandir_sort:leftparsefailed:nvmeOnlsdev_scandir_sorr:leftparsefanled:nvme0n8sdev_scandir_sort:leftparsefailed:nvme0n9sdev_scandir_sort:leftparsefailed:nvme0n2sdev_scandir_sorr:leftparsefailed:nvmeOnSsdev_scandir_sort:leftparsefailed:nvmeOnllsdev_scandir_sort:leftparsefailed:nvme0n2sdev_scandir_sort:leftparsefailed:nvme0n9sdev_scandir_sort:leftparsefailed:nvme0n7sdev_scandir_sort:leftparsefailed:nvmeOnlsdev_scandir_sort:leftparsefailed:nvmeOnSsdev_scandir_sort:leftparsefailed:nvme0n6sdev_scandir_sort:leftparsefailed:nvmeOnlOsdev_sccindir_sort:leftparsefailed:nvme0n4sdev_scandir_sort:leftparsefailed:nvmeOnlssiyyossnVV•ohc tcoa用户名admin密码Oraclel23由于是模拟的带库,重启之后会边,所以需要重新绑定磁盘,真是环境中不ISCSI会出现这个情况,需要执行这个脚本,重新配置带库osb-second.sh、在下修改默认存放路径4rmansu-oracle.oraenvorcirman target/show all;RMANshowall;using target database controlRMAN fileinsteadofrecoverycatalogconfiguration parameters CONFIGUREfordatabasewithdb_umque_nameORCLare:RETENTION POLICY TO CONFIGUREREDUNDANCY1]#defaultOFF;#defaultBACKUPOPTIMIZATIONCONFIGURE;CONTROLFILEAUTOBACKUPON萨defaultCONFIGURE;CONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO%F#defaultCONFIGURE;CONFIGURE DEVICETYPEDISKPARALLELISM1BACKUPTYPETOBACKUPSET#defaultCONFIGURE;DATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1#defaultCONFIGURE;CONFIGURE ARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1*defaultCONFIGURE MAXSETSIZETOUNLIMITED;#defaultCONFIGURE;ENCRYPTIONFORDATABASEOFF*defaultCONFIGURE;CONFIGURE ENCRYPTIONALGORITHMAES128#defaultCONFIGURE COMPRESSIONALGORITHMBASICASOFRELEASEDEFAULTOPTIMIZEFORLOADTRUE;#default;RMANOUTPUTTOKEEPFOR7DAYS#default这时看到AR默CHIV认ELO的GD存ELE储TION路PO径LICY是TODNOINSE;K,#修def改ault为SBTSNAPSHOTCONTROLFILENAMETO/u01/app/oracle/product/
19.
3.0/dbhome_2/dbs/snapcf_orcl.f;#default;CONFIGURE DEFAULTDEVICE TYPE TO SBT;RMANCONFIGUREDEFAULTDEVICETYPETOsbtnewRMANconfigurationparameters:;CONFIGUREDEFAULTDEVICETYPETOSBT_TAPE newRMANconfigurationparametersaresuccessfullystoredRMANssh2:AES-256-CTR40,740ft1275Linux大可数字通过备份rmanbackup database;如果是文件系统或者真实环境的磁带机,这时候备份已经成功了RMANbackupdatabase;startingbackupar07-JUN-23allocatedchannel:ORA_SBT_TAPE_1channelORVSBT_TAPE_1:SID=268devicetype=SBT_TAPEchannelORA_SBT_TAPE_1:oraclesecureBackupchannelORA^SBT_TAPE_1:startingfulldatafilebackupsetchannelORA_SBT_TAPE_1:specifyingdatafilesinbackupsetinputdatafilefilenumber=00003rchannelOR^SBT_TAPEJL:startingpiece1at07-JUN-23channelORA^SBT_TAPEJL:finishedpiece1at07-3UN-23channelORA^SBT_TAPEJL:backupsetcomplete,elapsedtime:00:00:35Finishedbackupat07-JUN-23startingcontrolFileandSPFILEAutobackupat07-JUN-23FinishedcontrolFileandSPFILEAutobackupat07-JUN-23RMANCONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM2BACKUP TYPETO BACKUPSET;;RMANCONFIGUREDEVICETYPESBT_TAPEPARALLELISM2BACKUPTYPETOBACKUPSETnewRMANconfigurationparameters:;CONFIGUREDEVICETYPESBT_TAPE PARALLELISM2BACKUPTYPETOBACKUPSET newRMANconfigurationparametersaresuccessfullystoredreleasedchannel:ORA_SBT_TAPE_1RMAN ssh2:AES-256-CTR40,740行,1277Linux大写数字Recovery Managercomplete.;oracle©db;oracle©db;oracle©db;oracle@db~j$rman target/Copyright c1982,2019,Oracle and/or itsaffiliates.All rightsreserved.connected totargetdatabase:ORCL DBID=16631O6675RMANRMANusing targetdatabase controlRMAN fileInstead ofrecovery catalogfor databasewithconfiguration parametersCONFIGURE;db_umque_name ORCLREDUNDANCY1#defaultRETENTION POLICYTOCONFIGURE BACKUPOPTIMIZATION OFF;#default;CONFIGURE DEFAULTDEVICE TYPETO SBT_TAPECONFIGURE CONTROLFILEAUTOBACKUP ON;#defaultCONFIGURE CONTROLFILEAUTOBACKUP%F;#defaultFORMAT FOR DEVICE TYPE SBT_TAPE TO;CONFIGURE CONTROLFILEAUTOBACKUP FORMATFOR DEVICE TYPE DISK TO%F*default SBT_TAPE;CONFIGURE DEVICE TYPE PARALLELISM1BACKUP TYPETO BACKUPSET#default DISKPARALLELISM1;CONFIGURE DEVICETYPE BACKUP TYPETO BACKUPSET#defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE SBT_TAPE TO1;#defaultCONFIGURE;DATAFILEBACKUP COPIES FORDEVICETYPE DISKTO1#defaultCONFIGURE;ARCHIVELOG BACKUPCOPIESFORDEVICETYPESBT_TAPE TO1*defaultCONFIGURE;CONFIGURE ARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1#defaultCONFIGURE;MAXSETSIZE TOUNLIMITED#defaultCONFIGURE;ENCRYPTION FORDATABASE OFF#defaultCONFIGURE;RMAN showaEll;NCRYPTION ALGORITHMAES128#default;CONFIGURE RMANOUTPUT TOKEEP FOR7DAYS#default;CONFIGURE ARCHIVELOGDELETION POLICYTO NONE#defaultCONFIGURE SNAPSHOTCONTROLFILE NAMETO;RMAN CONFIGURE DEVICETYPESBT_TAPE PARALLELISM2BACKUP TYPETO BACKUPSETnew RMANconfiguration parameters:;CONFIGUREDEVICETYPESBT_TAPE PARALLELISM2BACKUPTYPETOBACKUPSETnew RMANconfigurationparametersaresuccessfully storedRMAN、在下配置电子标记5obtoolSU-obtoolIsmfmkfs dbmkfssexample、在下配置通道6rmansu-oracle.oraenvorcirman target/CONFIGURE channel|device typesbt parmsENV=OB_MEDIA_FAMILY=db;,这里需要CONFIGURE channel|device typesbt parmsENV=OB_MEDIA_FAMILY=sexample,;注意大小写RMANCONFIGUREchannel1devicetypesbtparmsENV=OB_MEDlA^FAMiLY=db;newRMANconfigurationparameters:CONFIGURECHANNEL1DEVICETYPESBT_TAPEPARMS1ENV=OB_MEDIA^FAMILY=db;newRMANconfigurationparametersaresuccessfullystoredRMANCONFIGUREchannel2devicetypesbtparmsENV=OB_MEDIA^FAMILY=Sexample,;newRMANconfigurationparameters:CONFIGURECHANNEL2DEVICETYPESBT_TAPEPARMS1ENV=OB_MEDI/CFAMILY=sexample;newRMANconfigurationparametersaresuccessfullystoredRMANshow all;这里看到两个通道建立完成RMANshowall;RMANconfigurationparametersfordatabasewithdb_unique_nameORCLare:REDUNDANCY1;#RMANCONFIGUR RETENTIONPOLICYTOdefaultE BACKUPOPTIMIZATION OFF;*default ssh2:AES-256-CTR40,740行,大可数字;CONFIGUR DEFAULTDEVICETYPETO SBT_TAP£127万LinuxE CONTROLFILEAUTOBACKU;ON#defaultCONFIGUR CONTROLFILEP;E CONTROLFILEAUTOBACKU FORMATFORDEVICETYPES8T_TAPETO%F#defaultCONFIGUR DEVICETYPE PFORMATFORDEVICETYPEDISKTO%F;*default;E DEVICETYPEADUISTKOPBAARCAKLULELISM1BACKUPTYPETOBACKUPSET#defa;ultCONFIGURDATAFILEBACKPUPSBCTO_PTIAEPSEFOP RARDA ELVL ICEELIS TMYP2EB SABC TK_U TPAPT EYPTE OT1O;B*A dCeK faUuP ltSETE;DATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1#defaultCONFIGUREAARRCCHHIIVVEELLOOGGBBAACCKKUUPPCCOOPPIIEESSFFOORRDDEEVVIICCEETTYYPPEESDBISTK_TTAOP1E;TO*d1e;fau*ltdefaultCONFIGUR CHANNEL1DEVICETYPESBT_TAPEPARMSENV=COB_MEDIA^FAM ILY=db;ECONFIGUR CHANNEL2DEVICETYPESBTJAPEPARMNEND=CCEOONNFFIIGGUURR MAXSETSIZETOUNLIMITED;#defSUlTEE;ENCRYPTIONFORDATABASEOFF#defaultCCOONNFFIIGGUURR;EE ENCRYPTIONALGORITHMAES128#defaultCCOONNFFIIGGUURR COMPRESSIONALGORITHMBASICASOFRELEASEDEFAULTOPTIMIZEFORLOADTRUE;#defaultEE;RMANOUTPUTTOKEEPFOR7DAYS#defaultCCOONNFFIIGGUURR;EE ARCHIVELOGDELETIONPOLICYTONONE#defaultCCOONNFFIIGGUURR SNAPSHOTCONTROLFILENAMETO/uOl/app/oracle/product/
19.
3.0/dbhome_2/dbs/snapcf_orcl.f;#-defaultEECONFIGURECONFIGURE。