Format Shell Scripts

Cool and simple code to format any kind of script in Unix environment

awk.info » Format Shell Scripts

Recommended

Comments

Post a Comment

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Central Inventory location is determined by oraInst.loc located in:
HP/Solaris /var/opt/oracle/oraInst.locLinux/etc/oraInst.locWindows\\HKEY_LOCAL_MACHINE\Software\Oracle\inst_locTo check if all oracle homes are registered within the Central Inventory run the following command:
${ORACLE_HOME}/oui/bin/opatch lsinventory -all
Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /software/oracle/OEM10gR2/agent10g
Central Inventory : /software/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /software/oracle/OEM10gR2/agent10g/oui
Log file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/opatch/opatch....log

Lsinventory Output file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/....lsinventory.....txt
----------------------------------...
List of Oracle Homes:
Name Location
…
Read more

List RMAN backups size

Image
SQL script for calculating the total size of RMAN backups

col TYPE for a20 Heading "Backup Type"
col completion_time Heading "Completion Time"
col MB for 99999999999  Heading "Size (MB)"
col BCPTIME for 99999999999 Heading "Backup Time (minutes)"

SELECT TO_CHAR (completion_time, 'YYYY-MON-DD') completion_time
       , TYPE
       , ROUND (SUM (bytes) / 1048576)          MB
       , ROUND (SUM (elapsed_seconds) / 60)     BCPTIME
    FROM (SELECT CASE
                    WHEN s.backup_type = 'L' THEN 'Archive Log'
--                    WHEN s.controlfile_included = 'YES' THEN 'Control File'
                 WHEN s.backup_type = 'D' THEN 'Full (Level ' || NVL (s.incremental_level, 0) || ')'
                    WHEN s.backup_type = 'I' THEN 'Incemental (Level ' || s.incremental_level || ')'
                    ELSE s.backup_type
                 END
            …
Read more

Oracle 18c - New Features for Active Data Guard

Image
Hi,

At Oracle Open World 2017 I collected the main improvements and changes
 are going to be implemented in Oracle Database 18c:

RMAN
-Refresh a standby from primary/backup using single RECOVER command
Data Guard
-In Memory Column store works with multi-instance redo apply
-Multi-instance redo apply support with Block Change Tracking (BCT)
-Global Temporary Table support from Standby.
-DML operations on Standby – Redirection to Primary without ACID compromise.
-Preserve buffer cache during role-change.
-No logging enhancement - Performance mode and Availability mode.



Yossi Nixon
Read more