还剩2页未读,继续阅读
文本内容:
热备Oracle
一、数据库要处于归档模式su-oracle.oraenvorcisqlplus/as sysdbaselectlog_mode fromv$database;SQLselectlog_modefromvldatabase;LOG_MODEARCHIVELOG这里已经处于归档模式,如果是需要修改为归档模式NOARCHIVELOG,正常关闭数据库,启动数据库到状态,修改归档模式,修改完成后,使数据库处于mount open状态shutdown immediate;startup mount;alter databasearchivelog;alter databaseopen;通过查看,这时已经处于归档模式sqldeveloper
一、修改库为归档模式rcl、查看数据库实例是否处于归档模式1通过、均可sqlplus plsqksqldeveloperselect log_mode fromv$database;如果显示则为非归档模式,非归档模式恢复的数据有线,一般生产环境均为归NOARCHIVELOG,档模式Hectloa-nodefromv$database;select*fronv5logj机陈输出X»查...X旦硝*-QL提取的所有行上用时
0.007秒用L0GJKIDEK0APCHIVEL0G、修改数据库实例为归档模式,2正常关闭数据库,启动数据库到状态,修改归档模式,修改完成后,使数据库mount处于状态openshutdown immediate;startup mount;alter databasearchivelog;alter databaseopen;通过查看,这时已经处于归档模式sqldeveloper国翔小鼠场@/抬〃g[旦orcl▼工作袤查询构建罟selectloq_nodefronv$database;l>直询结果x』曰姗』SQL提取的所有行1,用时
0.013秒IL0GJKIDE1ARCHIVELOG
二、在下修改默认存放路径rman su-oracle.oraenvorcirman target/show all;RMANshowall;using targetdatabase controlRMAN fileinsteadofrecoverycatalogconfigurationparameters CONFIGUREfordatabasewithdb_umque_nameORCLare:REDUNDANCY1]#defaultOFF;#defaultRETENTION POLICYTO CONFIGUREBCA OCNK FUIGP UORP ETIMIZATIONCONTROLFILEAUTOBACKUPON;萨defaultCONFIGURE CONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO%F;#defaultCONFIGURE DEVICETYPEDISKPARALLELISM1BACKUPTYPETOBACKUPSET;#defaultCONFIGURE;CONFIGURE DATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1#defaultCONFIGURE ARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;*defaultCONFIGURE MAXSETSIZETOUNLIMITED;#defaultCONFIGURE;CONFIGURE ENCRYPTIONFORDATABASEOFF*defaultCONFIGURE ENCRYPTIONALGORITHMAES128;#defaultCONFIGURE;COMPRESSIONALGORITHMBASICASOFRELEASEDEFAULTOPTIMIZEFORLOADTRUE#defaultCONFIGURE;RMANOUTPUTTOKEEPFOR7DAYS#default;ARCHIVELOGDELETIONPOLICYTONONE#defaultSNAPSHOTCONTROLFILENAMETO/uOl/app/oracle/product/
19.
3.0/dbhome_2/dbs/snapcf_orcl.f;#default这时看到默认的存储路径是修改为DISK,SBT;CONFIGURE DEFAULTDEVICE TYPETO SBT;RMANCONFIGUREDEFAULTDEVICETYPETOSbtnewRMANconfigurationparameters:;CONFIGUREDEFAULTDEVICETYPETOSBT.TAPE newRMANconfigurationparametersaresuccessfullystoredRMANssh2:AES-256-CTR40,740行,1277Linux大可数字
三、通过进行热备份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-23FinishedControlFileandSPFILEAutobackupat0/-JUN-2SRMAN
三、在下配置电子标记obtoolsu-obtool Ismfmkfsdbmkfs sexample
四、在下配置通道rmansu-oracle.oraenvorcirman target/CONFIGURE channel1device typesbt parmsENV=OB_MEDIA_FAMILY=db;这里需CONFIGURE channel|device typesbt parmsENV=OB_MEDIA_FAMILY=sexample,;要注意大小写RMANCONFIGUREchannel1devicetypesbtparmsENV=OB_MEDiA_FAMiLY=db;newRMANconfigurationparameters:;CONFIGURECHANNEL1DEVICETYPESBT_TAPEPARMSENV=OB_MEDIA_FAMILY=db newRMANconfigurationparametersaresuccessfullystoredRMANCONFIGUREchannel2devicetypesbtparms£NV=OB_MEDi^FAMiLY=sexample,;newRMANconfigurationparameters:CONFIGURECHANNEL2DEVICETYPESBT.TAPEPARMS1ENV-OB_MEDI^FAMILY-sexample;newRMANconfigurationparametersaresuccessfullystoredRMANshow all;这里看到两个通道建立完成RMANconfigurationparametersfordatabasewithdb_unique_nameORCLare:;CONFIGURERETENTIONPOLICYTOREDUNDANCY1*default;C COON NFFI IGGU URRE EBDA ECFAK UULP TODP ETVIM ICIZEA TTYIO PNETO OFF*Sde BfTa_u TltAP£;CONFIGURECONTROLFILE AUTOBACKUPON;#defaultCONFIGURECONTROLFILE AUTOBACKUP;FORMATFORDEVICETYPES8T_TAPETO%F#defaultCONFIGURECONTROLFILE AUTOBACKUP;CONFIGURE DEVICETYPESBT_TAPE FORMATFORDEVICETYPEDISKTO%F*defaultCONFIGURE DEVICETYPEDISKPARALLELPIASRMA1LLBEALCISKMUP2TBYAPCEKTUOPBTYAPCEKUTPOSBEATC;KU#PdSeEfaTu;lt;CONFIGURE DATAFILEBACKUPCOPIESFORDEVICETYPESBT_TAPETO1*defaultDATAFILECONFIGUREBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultARCHIVELOGBACKUPCOPIES;CONFIGURE FORDEVICETYPESBT_TAPETO1*defaultARCHIVELOGBACKUPCOPIESFORDEVICECONFIGURETYPEDISKTO1;#defaultCONFIGURECHANNEL1DEVICETYPESBT_TAPEPARMS ENV=COB_MEDIA_FAMILY=db;|CONFIGURECHANNEL2DEVICETYPE*SBT_TAPE1PARMS ENV=OBAEDIA_FAMILY=Sexam|;CONFIGUREMAXSETSIZETOUNLIMITED#default;CONFIGUREENCRYPTIONFORDATABASEOFF#default;CONFIGUREENCRYPTIONALGORITHMAES128#defaultCCOONNFFIIGGUURREECROMMAPNROESUSTIPOUNTATLOGKOEREITPHFMORBA7SDICAYASS;O#FdReEfaLuElAt SEDEFAULTOPTIMIZEFORLOADTRUE;#defaultCONFIGURE ARCHIVELOGDELETIONPOLICYTONONE;#defaultCONFIGURESNAPSHOTCONTROLFILENAMETO/uOl/app/oracle/product/
19.
3.0/dbhome_2/dbs/snapcf_orcl.f;#-defaultRMANshowall;RMANssh2:AES-256-CTR40,740行,127万Linux大可数字
五、增量备份,生产环境里很少做备份fullbackup tag1T-WHOLE-INCRO incrementallevel0database plusarchivelog deleteall input;RMAN backuptag1T-WHOLE-INCRO incrementallevel0database plusarchivelog deleteallinput;Starting backupat24-MAY-23current logarchived allocatedchannel:OR^SBT_TAPE_L channel OR^SBT_TAPEJL:SID=511device type=SBT_TAPEchannel ORA_SBT_TAPE_1:Oracle secureBackup allocatedchannel:ORA_SBT_TAPE_2channel ORA_SBT_TAPE_2:SID=759devicetype=SBT_TAPE channel ORVSBT_TAPE_2:oracle secureBackup channel OR^SBT_TAPEJL:starting archivedlog backup set channelORA_SBT_TAPE_1:specifying archivedIogs in backup set input archivedlog thread=l sequence=32RECID=3STAMP=1137705971channelORA_SBT_TAPEJL:starting piece1at24-MAY-23channel ORA_SBT_TAPE_1:finishea piece1at24-MAY-23piece handle=061t00vkJLJLtag=lT-WHOLE-lNCR0comment=API version
2.0,MMS version
12.
1.
0.2channelOR^SBT_TAPEJ,:backup setcomplete,elapsed time:00:00:15channel ORA_SBT_TAPE_1:deleting archivedlogs archivedlog filename=+FRA/ORCL/ARCHIVELOG/2023_O5_24/thread_l_seq_
32.
266.1137662771RECID=3STAMP=1137705971Finished backupat24-MAY-23Starting backupat24-MAY-23using channeloRA_sBT_TAPEJ.using channel ORA_SBT_TAPE_2channel ORA_SBT_TAPE_1:starting incrementallevel0datafile backup set channel ORA_SBT_TAPE_1:specifying datafilesin backupset input datafile file number=00001name=+DATA/ORCL/DATAFlLE/system.
274.1136915065input datafile file number=00002name=+DATA/ORCL/DATAFlLE/sysaux.
276.1136915077channelOR/CSBT_TAPEJ.:starting piece1at24-MAY-23channel ORA_SBT_TAPE_2:starting incrementallevel0datafile backupset channelORA_SBT_TAPE_2:specifying datafilesinbackupsetinputdatafilefilenumber=00003name=+DATA/oRCL/DATAFILE/Undotbsl.
275.1136915071inputdatafilefilenumber=00004name=+DATA/ORCL/DATAFlLE/users.
277.1136915085channel ORVSBT_TAPE_2:starting piece1at24-MAY-23channelOR/CSBT_TAPE_2:finished piece1at24-MAY-23piece handle=081t0103_l_l tag=lT-WHOLE-lNCR0comment=API version
2.0,MMS version
12.
1.
0.2channelORA_SBT_TAPE_2:backupsetcomplete,elapsed time:00:00:25channelORA_SBT_TAPEJL:finished piece1at24-MAY-23piecehandle=071t0103_LjL tag=lT-WHOLE-lNCR0comment=API version
2.0,MMS version
12.
1.
0.2channelORA_SBT_TAPE_1:backupsetcomplete,elapsed time:00:00:45Finished backupat24-MAY-23Starting backupat24-MAY-23备份表空间rman usersbackuptag2T-USERS-FULL tablespaceusers;库热备完成orci通过查看obtoolsu-obtoolcopy createdHOS Piecename021u2quf_l_l06/
07.02:17Tdb C-1666048788-20230607-01006/
07.02:18dbdb041u2sbn_l_l051u2sbn_l_l006/
07.02:42dbdb061U2SC6_LJL071U2SC6JLJ.006/
07.02:42dbdb081u2sdOJ.jL「・006/
07.02:42dbdb c-1666048788-20230607-02「・006/
07.02:42db0alu2sro_l_l006/
07.02:42c-1666048788-20230607-03006/
07.02:42006/
07.02:50006/
07.02:50obIspiecessh2:AES-256-CTR40,540行,127Linux大写数字llrdlllllllllllrHllCDOOOOOOOOOOeearrrrrrrrrr31111111111tccccccccccesDacffa3ff3fffuur uuuennccncmtnhhllhmt•f―n1eeegggo oo11。