o :F¶dìVã@sÈddlZddlZddlmZmZddlZddlmZmZddl Z ddl Z ddl Z ddl m Z ddlmZddlZddlZddlmZddlZzddlZWney^e d¡edƒYnwe j d d d ¡Zd Zejd deddddejdedddejdeeƒdddejddddejddddejddddejddd dejd!dd"dejd#dd$dejd%dd&dejd'dd(dejd)dd*d+d,ej d-d.„ƒƒƒƒƒƒƒƒƒƒƒƒƒZ!e"d/krâe!ƒdSdS)0éN)Úcli_utilÚcli_root)ÚPopenÚPIPE)Úrequests)Ú HTTPBasicAuth)ÚSentinelažcx_Oracle module could not be imported. This most likely means you have installed OCI CLI without optional feature 'db'. To use this script, please re-install CLI with 'db' optional feature. Below are the relevant commands to do it: In *NIX systems: curl -L -O https://raw.githubusercontent.com/oracle/oci-cli/master/scripts/install/install.sh ./install.sh --optional-features db In Windows systems using powershell: ((New-Object System.Net.WebClient).DownloadFile('https://raw.githubusercontent.com/oracle/oci-cli/master/scripts/install/install.ps1', $pwd\install.ps1)) .\install.ps1 -OptionalFeatures db If just using pip: pip install 'oci-cli[db]'éú~z.ociÚconfigÚDEFAULTzcreate-from-onpremz.Create a backup of on-premise database on OCI T)Zallow_interspersed_argsZignore_unknown_options)ÚnameÚhelpZcontext_settingsz --config-filezThe path to the config file.)ÚdefaultZ show_defaultrz --profileFzÇThe profile in the config file to load. This profile will also be used to locate any default parameter values which have been specified in the OCI CLI-specific configuration file. [default: DEFAULT]z--compartment-idzCompartment_id to store backup)Úrequiredrz--display-namezEThe user-friendly name for the backup. It does not have to be unique.z--availability-domainz7The Availability Domain where the DB System is located.z --editionz;Database edition on to which the backup will be restored toz--opc-installer-dirz+Directory containing opc_installer.jar filez--additional-opc-argsz/Optional additional arguments for opc installerz --tmp-dirz&Optional Directory for temporary filesz--rman-passwordz5RMAN password to use (required) if TDE is not enabledz--rman-channelsÚ5zRMAN Channels (default: 5))rrrcA Kshtjdkr tdƒ|ttƒkrt}|i|ddddddddiiddœ }||_t |||¡t  |dt j ¡|d}|d}t |d ƒ}d |vrJ|d }d |vrR|d } tj  t ¡d ¡} d |vrk|d rktj  |d ¡} tj  |d¡} tj  | ¡s†t | tj¡r†t d| ¡t | d¡tj  | ¡s™t | d¡t | ¡r¥t | d¡dtjvs¯dtjvr´t d¡tj  tjddd¡} tj  | ¡rÌt | tj¡sÑt d¡t  d¡tjdtjd} |  ¡}|  d¡|D]}|d}qéd|vr|  d¡|D]}|d}qüt  d |¡d}|  d!¡|D]}|d}q|dur%t d"¡t  d#¡|  d$¡|D]}|dd%kr?t d&¡q1t  d'¡|  d(¡|D]}|dd)kr[t d*¡qM|  d+¡|D]}|dd,krrt d-¡qdd}d}d}t  d.¡|  d/¡|D]}|d}|d,}|d0}t  d1|||f¡q†d}t  d2¡|  d3¡|D]}|d}t  d4|¡q®d}t  d5¡|  d6¡|D]}|d}t  d7|¡qËd8}t  d9¡|  d:¡|D]}|d}t  d;|¡qèd}d}d}d}|  d<¡|D] }|dd=krd>}q|s|st d?¡nß|r't d@¡|  dA¡|D]8}|ddBks>|d0d)krCt dC¡|d,durRtj  !|d,¡}|d,dus`tj  |¡set dD¡q.| "dE¡}t |dƒdFkrþ|  dG¡|D]}|ddHkr•|ddIkr•t dJ|d¡q||  dK¡|D]}|d}qž|dLkrþg}|  dM¡|D] }| #|d¡q´|D]<}|  dN|dO¡|  dP¡|D](}|ddBksñ|d,d)ksñ|d0dHkrú|d0dIkrút dQ|dR¡qÓqÁd}d} |  dS¡|D] }t$ %|d¡}q |  dT¡|D] }t$ %|d¡} q|dks0| dkr5t dU¡|  dV¡t&tj  | dW¡dXƒ'}!|D]}|! '|d,rZ|ddY|d,ndZ¡|! 'd[¡qGWdƒn 1sowY| (¡|  (¡t)| d\dgt*t*t*d]}"|" +d^¡\}#}$|$sš|#rš|"j,dkrŸt d_¡|# -¡}#|#d`dakr¯t db¡t .dcdc|¡}%i}&||&dd<|rÃ||&de<|rÊ||&df<dg|vrÚ|dgrÚ|dg|&dh<|rá||&di<dj|vrñ|djrñ|dj|&dk<|rø||&dl<|rÿ||&dm<|d8krdnndo|&dp<||&dq<||&dr<|ds|&dt<t  du¡d}'z÷i}|%j/dÈdv|&i|¤Ž}(|(j0j1}'t  dw|'¡ i}|%j2dÈdx|'i|¤Ž}(|'|(j0j1krQt dy¡|(j0j3rbt4 5dz¡t  du¡q8|(j0j6})|(j0j7}*|(j0j8}+|(j0j9},|(j0j:}-|)dus|*dus|+dus|,dus|-dur”t d{¡ t  d|¡t4 5d}¡|r tj  | d~¡}.|)d|*d}/t  d€¡t; &|.d¡}0|0j<|tj  =|¡d‚Wdƒn 1sÓwYt  dƒ¡t&|.d„ƒ }1t>j?|/t@|,|-ƒd…tAtj  B|.¡ƒi|1d†}2|2 C¡Wdƒn 1swYnd}/t  d‡¡t&tj  | dW¡d„ƒ-}!t>j?|)d|*ddWt@|,|-ƒd…tAtj  Btj  | dW¡¡ƒi|!d†}2|2 C¡Wdƒn 1sNwYdˆ| d‰|)dŠ|,d‹|-dŒ| d| dŽtj  | dtjdd¡d‘|*}3| rˆ|3d’| }3t  d“¡dˆ| d‰|)dŠ|,d”d•d–| d| dŽtj  | dtjdd¡d‘|*}4t  d—|4¡t)|3d>t*t*t*d˜}"|" +¡\}#}$|$sØ|"j,dkrçt d™|3¡tD|#ƒtD|$ƒtjdkrïdšnd›}5tj  Etj  | dtjdd¡¡rtj  Etj  | dœ¡¡rtj  Etj  | |5¡¡s!t d¡t&tj  | dž¡dXƒ}6|6 'dŸ¡|s=|6 'd |d¡¡n|6 'd¢¡|6 'd£¡tF|ƒD]+}7|6 'd¤tA|7ƒd¥d¦| tj jG|5d§d¨| tj jGdtjdd©¡qK|6 'dª|+d«d¬|+d­d®|+d¯d°¡|6 (¡t  d±¡t)| d\dd²tj  | d³¡d´tj  | dž¡gt*t*t*d]}"|" +¡\}#}$|$sÃ|#rÃ|"j,dkrÐt dµ¡tD|#ƒtD|$ƒt&tj  | d³¡d„ƒ-}8t>j?|)d|*dd³t@|,|-ƒd…tAtj  Btj  | d³¡¡ƒi|8d†}2|2 C¡Wdƒn 1s wYd}9d}:t&tj  | tjGd³¡ƒˆ};|; H¡}|>rf|>rDdnd}9|=d¹}=|=tI|<ƒkrftJ Kdº|<|=¡}?|?rf|>rd|? Ld,¡nd}9|<|=d»k}@|@r—|@rtdnd}:|=d¹}=|=tI|<ƒkr–tJ Kdº|<|=¡}?|?r–|@r”|? Ld,¡nd}:n|=d,}=|=tI|<ƒks6Wdƒn 1s­wY|9dus¼|:durÁt d¼¡t  d½¡i}&|:|&d¾<||&d¿<| |&dÀ<|9|&dÁ<g|&dÂ<|/|&dÃ<|%jMdÈ|'|&dÄœ|¤Ž}(t  dÅ|(jN¡t  dÆ¡d}'W|'durt  dÇ¡i}|%jOdÈdx|'i|¤ŽtP Q| ¡dS|'dur.t  dÇ¡i}|%jOdÈdx|'i|¤ŽtP Q| ¡w)ÉNÚntz:This script is not supported on Windows operating systems.FÚproxy) Ú config_fileZdefault_values_from_fileÚprofileZ cert_bundleZendpointZ request_idZno_retryÚdebugrÚsettingsZparameter_aliasesÚregionrÚavailability_domainZopc_installer_dirZ rman_channelsZ rman_passwordZadditional_opc_argsZ onprem_uploadZtmp_dirzopc_install.jarzCould not access iÀz is not a directoryz is not emptyZ ORACLE_HOMEZ ORACLE_SIDz(ORACLE_HOME and ORACLE_SID should be setÚbinÚrmanz0Could not find a usable rman in this environmentzConnecting to Oracle databaseú/)Úmodezselect version from v$instancerz18.z#select version_full from v$instancezOracle version is:%sz?select value from v$parameter where name ='db_create_file_dest'z'OMF is required for the script to work.z-Checking the archive log mode of the databasezselect log_mode from v$databaseZ ARCHIVELOGz%Database should be in archivelog modez Checking if the database is openzselect status from v$instanceZOPENzDatabase is not openzLselect count(*) from v$parameter where name = 'spfile' and value is not nullr z6script requires the instance to be started with spfilez.Getting database name and database unique namez1select dbid, name, db_unique_name from v$databaseéz$Database Id:%d Name:%s UniqueName:%szFetching character setz;select value$ from sys.props$ where name='NLS_CHARACTERSET'zCharacter Set:%szFetching national character setzAselect value$ from sys.props$ where name='NLS_NCHAR_CHARACTERSET'zNational Character Set:%sZFALSEzFetching rac modez;select value from v$parameter where name='cluster_database'z Rac mode:%sz%select BITAND(flags, 8) from x$kcbdbkéTz 'CDB$ROOT' and open_mode like 'READ%'zalter session set container = "ú"zaselect upper(wrl_type), upper(status), upper(wallet_type), wrl_parameter from v$encryption_walletzPDB:z cannot be backed upzyselect sum(bytes)/1024/1024 from ( select sum(bytes) bytes from v$datafile union select sum(bytes) bytes from v$tempfile)zÒselect sum(bytes)/1024/1024 from (select sum(bytes*members) bytes from v$log where group# in (select group# from v$logfile where type='ONLINE') union select (BLOCK_SIZE*FILE_SIZE_BLKS) bytes from v$controlfile)z.Failed to determine data size and/or redo sizez=select name, value from v$parameter where isdefault = 'FALSE'z parameter.logÚwz: zÚ Útarget)ÚstdinÚstdoutÚstderrs show all;zError while test running rmanéÿÿÿÿsRecovery Manager complete.z#Failed to successfully execute rmanZdatabaseZavailabilityDomainZ characterSetZ ncharacterSetZeditionZdatabaseEditionÚdbNameÚ display_nameZ displayNameÚ dbUniqueNameZexternalDatabaseIdentifierZSIZRACZ databaseModeZ dbVersionZpdbNameZcompartment_idZ compartmentIdz(Creating external backup job resource...Z"create_external_backup_job_detailsz.Created external backup job resource with id: Ú backup_idz@Internal error, backupId mismatch. Please contact Oracle supporté zBackup no longer existsz0Waiting for completion of external backup job...i,ztdeWallet.tar.gzz/tdeWallet.tar.gzzCompressing the walletzw:gz)ÚarcnamezUploading walletÚrbzContent-Length)ZauthÚheadersÚdatazUploading parameter logsz java -jar z -host z -opcId 'z ' -opcPass 'z ' -walletDir z -libDir z -configFile Zopcz.oraz -container ú zSetting up opc installerz ' -opcPass zz -walletDir zExecuting command: %s)Úshellr'r(r)zFailed to run opcInstaller cmd:z libopc.soz libopc.dllz cwallet.ssozBUnexpected status from opcInstaller. Please contact Oracle supportzrman.sqlz set echo on z!set encryption on identified by 'z' only; zset encryption on; zrun { zallocate channel odbmsz type sbt zPARMS='SBT_LIBRARY=ú,zSBT_PARMS=(OPC_PFILE=z.ora)'; z-backup as compressed backupset database tag 'z' zformat 'z__%d_%I_%U_%T_%t' z/keep until time 'sysdate+29000' restore point 'z'; z} z8Executing RMAN. It will take a few minutes to complete..Úlogzrman.logú@z!Error while running rman commandscSsg|]}| ¡‘qS©)Ústrip)Ú.0Úxr9r9úBusr/lib/python3.10/site-packages/oci_cli/scripts/database/dbaas.pyÚ »sz-create_backup_from_onprem..z&including current SPFILE in backup setéz^piece handle=(.+?) tag=z,including current control file in backup setz(Could not find spfile/controlfile Handlez$Completing the external backup job..ZcfBackupHandleÚdataSizeÚredoSizeZspfBackupHandleZ sqlPatchesÚ tdeWalletPath)r.Z$complete_external_backup_job_detailsz Response:%szExternal Backup created.zDeleting incomplete backupr9)RÚosr ÚexitrÚDEFAULT_PROFILEÚobjrZload_default_valuesrZ$populate_dict_key_with_default_valueÚclickÚSTRINGÚintÚpathÚjoinÚtempfileÚ gettempdirÚabspathÚisfileÚaccessÚR_OKÚsysÚmakedirsÚisdirÚlistdirÚenvironÚX_OKÚechoÚ cx_OracleÚconnectZSYSDBAÚcursorÚexecuteÚ expandvarsÚsplitÚappendÚmathÚceilÚopenÚwriteÚcloserrÚ communicateÚ returncodeÚ splitlinesZ build_clientZcreate_external_backup_jobr3r.Zget_external_backup_jobZ provisioningÚtimeÚsleepZ swift_pathZ bucket_nameÚtagZ user_nameZswift_passwordÚtarfileÚaddÚbasenamerÚputrÚstrÚgetsizeZraise_for_statusÚprintÚexistsÚrangeÚsepÚ readlinesÚlenÚreÚsearchÚgroupZcomplete_external_backup_jobÚstatusZ delete_backupÚshutilÚrmtree)AÚctxrrÚkwargsZ initial_dictrZopcinstallerdirZ rmanchannelsZ rmanpasswordZadditionalopcargsZtmpdirZ opcinstallerrÚdbr[ÚrowZ dbversionZomfZdbIdr+r-ZcharSetZnCharSetZracModeZpdbnameZcdbmodeZ tdeenabledZ walletLocZversionsZpdbsÚpdbr@rAÚpfÚpÚoutÚerrZclientÚdetailsZbackupIdÚresultZ swiftPathZ bucketNameZrmanTagZuserNameZpassWordZ tdeWalletFilerBÚtarÚpayloadÚresponseÚcmdZ cmd_redactedZlibfileÚscriptZchannelZrlZ spfHandleZcfHandleÚfÚlinesÚiZspfÚmÚcfr9r9r=Úcreate_backup_from_onprem)s~  ô                   €   €  €         € €    €  €    ÿ8€þ    (þÿ      ÿþÿþ             ÿ  ý û€ ý ûÿÿÿÿÿþþþ  ÿÿÿÿÿÿþþþ &ÿþ     ÿÿÿÿÿþþþþþ þÿÿÿþþþý *ÿ  ý û  €î€ü  þý   ÿþ ù ÿþ r’Ú__main__)#rRrGÚoci_clirrrLÚ subprocessrrrhrCrwZ oci._vendorrZoci._vendor.requests.authrr`r{Zoci.utilrrkrYÚ ImportErrorrXrDrJrKZDEFAULT_LOCATIONrEÚcommandÚdictÚoptionZ pass_contextr’Ú__name__r9r9r9r=Úsd       ô ÿþþ"9 ÿ