Entradas

Creating Database Incrementally Updated Backup

  Ejemplo de "Database Incrementally Updated Backup" :   rman target "'/ as sysbackup'"     Run { RECOVER COPY OF DATABASE WITH TAG 'incr_update';  BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' DATABASE;  }     LIST COPY OF DATABASE;  SELECT FILE#, STATUS, CREATION_TIME, COMPLETION_TIME, TAG, BLOCKS*BLOCK_SIZE/1024/1024 SIZE_MB, INCREMENTAL_LEVEL  FROM V$DATAFILE_COPY   WHERE DELETED ='NO' ORDER BY FILE#, RECID;

Liberar espacio en carpetas WinSxS y C:\windows\installer en Windows 10

Para WinSxS: Dism.exe /online /Cleanup-Image /StartComponentCleanup Para c:\windows\installer: Net Stop msiserver /Y  Reg Add HKLM\Software\Policies\Microsoft\Windows\Installer /v MaxPatchCacheSize /t REG_DWORD /d 0 /f  RmDir /q /s %WINDIR%\Installer\$PatchCache$ Net Start msiserver /Y Net Stop msiserver /Y Reg Add HKLM\Software\Policies\Microsoft\Windows\Installer /v MaxPatchCacheSize /t REG_DWORD /d 10 /f Net Start msiserver /Y

Tabla para decidir el método de Migración

Imagen

Desinstalación Oracle Database 18.3.0

Desinstalación Oracle 18.3.0 Generamos un response file: [oracle@suez 18.3.0]$ id uid=501(oracle) gid=502(oinstall) groups=502(oinstall),501(dba),503(asmdba),504(asmadmin) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 [oracle@suez 18.3.0]$ cd deinstall/ [oracle@suez deinstall]$ ./deinstall -checkonly Checking for required files and bootstrapping ... Please wait ... Location of logs /tmp/deinstall2018-07-26_03-39-35PM/logs/ ############ ORACLE DECONFIG TOOL START ############ ######################### DECONFIG CHECK OPERATION START ######################### ## [START] Install check configuration ## Checking for existence of the Oracle home location /u01/app/oracle/product/18.3.0 Oracle Home type selected for deinstall is: Oracle Single Instance Database Oracle Base selected for deinstall is: /u01/app/oracle Checking for existence of central inventory location /u01/app/oraInventory ## [END] Install check configuration ##

Instalación Oracle Database 18.3.0 StandAlone - Silent

Instalación Oracle Database 18.3.0 StandAlone - Silent Ref: https://oracle-base.com/articles/misc/oui-silent-installations https://oracle-base.com/articles/18c/oracle-db-18c-installation-on-oracle-linux-6-and-7 Como usuario Oracle: mkdir –p /u01/app/oracle/product/18.3.0 cd /u01/app/oracle/product/18.3.0 unzip -q /home/oscar/Desktop/STAGE/BBDD/LINUX.X64_180000_db_home.zip # Silent mode. Utilizo el fichero de respuesta generado anteriormente: [oracle@suez 18.3.0]$ ./runInstaller -ignorePrereq -waitforcompletion -silent -responseFile /home/oracle/db_soft_standalone.rsp Launching Oracle Database Setup Wizard... [WARNING] [INS-13014] Target environment does not meet some optional requirements.    CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2018-07-26_05-39-06PM.log    ACTION: Identify the list of failed prerequisite checks from the log: installActions2018-07-26_05-39-06PM.log. Then either from the

asm_diskgroups_free

select  name,decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1) Redundancy,REQUIRED_MIRROR_FREE_MB,   (total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Total_MB,   ((free_mb - REQUIRED_MIRROR_FREE_MB)/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Free_MB,   ((free_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1))/(total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)))*100 "%Free" from v$asm_diskgroup;

Falcon BMS 4.33 download

Falcon BMS 4.33 download