Tuesday 25 July 2017

Amazon Web Services - Storage - S3

S3 provides developers and IT teams with secure, durable, highly-scalable object storage. Amazon S3 is easy to use, with a simple web services interface to store and retrieve any amount of data from anywhere on the web.

  1. S3 is a safe place to store your files. 
  2. It is Object based storage.
  3. The data is spread across multiple devices and facilities.

S3 Basices:
  1. S3 is Object based i.e. allows you to upload files.
  2. Files can be from 0 Bytes to 5 TB.
  3. There is unlimited storage.
  4. Files are stored in Buckets.
  5. S3 is a universal namespace, that is, names must be unique globally.
  6. https://s3-eu-west-1.amazonws.com/<name of cloud>
  7. When you upload a file to S3 you will receive a HTTP 200 code if the upload was successful.
  8. Built for 99.99% availability for the S3 platform.
  9. Amazon Guarantee 99.9% availability
  10. Amazon guarantees 99.999999999% durability for S3 information. (Remember 11x 9's)
  11. Tiered Storage Available
  12. Lifecycle Management. 
  13. Versioning
  14. Encryption
  15. Secure your data using Access Control List and Bucket Policies.

Data Consistency Model For S3:
  1. Read after Write consistency for PUTS of new Objects.
  2. Eventual Consistency for overwrite PUTS and DELETES (can take some time to propagate)

S3 is a simple key, value store:
  •  S3 is Object based. Object consist of the following:
    • Key (This is simply the name of the object)
    • Value (This is simply the data and is made up of a sequence of bytes).
    • Version ID (important for versioning)
    • Metadata (Data about the data you are storing) 
    • Subresources
      • Access Control Lists
      • Torrent

S3- Storage Tiers/ Classes
  • S3 - 99.99% availability, 99.999999999% durability, stored redundantly across multiple devices in multiple facilities and is designed to sustain the loss of 2 facilities concurrently.
  • S3 - IA (Infrequently Accessed) for data that is accessed less frequently, but requires rapid access when needed. Lower fee than S3, but you are charged a retrieval fee.
  • Reduced Redundancy storage - Designed to provide 99.99% durability and 99.99% availability of objects over a given year.
  • Glacier- Very cheap, but used for archival only. It takes 3-5 hours to restore from Glacier.

                       Standard             Standard - Infrequent   Reduced Redundancy
                                                              Access                         Storage
============================================
Durability -----99.999999999%--------99.999999999%-----------------99.99%
Availability----------99.99%-----------------------99.99%------------------------99.99%
Concurrent facility fault tolerence
                  --------------2--------------------------------2----------------------------------1
SSL support-----------Yes------------------------------Yes-------------------------------Yes
First byte latency---Milliseconds-------Milliseconds---------------Milliseconds
Lifecyle Management Policies
                   ------------Yes-------------------------------Yes------------------------------Yes
============================================


What is Glacier?

Glacier is an extremely low-cost storate service for data archival. Amazon Glacier stores data for as little as $0.01 per gigabyte per month, and is optimized for data that is infrequently accessed and for which retrieval times of 3 to 5 hours are suitable.


S3 vs Glacier:

                       Standard             Standard - Infrequent   Amazon Glacier
                                                              Access                        
============================================
Designed for Durability-----99.999999999%----99.999999999%----99.999999999%
Designed for Availability---99.99%-----------------------99.99%--------------NA
Availability SLA-----------------99.9%-------------------------99%-------------------NA
Minumum Object Size--------NA-----------------------------128KB*--------------NA
Max. Storage Duration------NA-----------------------------30 days--------------90 days
Retrieval Fees-------------NA-----------------------------per GB retrieved--per GB retrieved**
First byte latency---Milliseconds-------Milliseconds-----------select minutes or hours**
Storage Class--------object level----------object level------------object level
Lifecycle Transitions---yes-----------------yes-------------------------yes
============================================



S3 - Charges:
  • Charged for-
    • Storage
    • Requests
    • Storage Management Pricing
    • Data Transfer Pricing
    • Transfer Acceleration 

Transfer Acceleration - Amazon S3 Transfer Acceleration enables fast, easy, and secure transfers of files over long distances between your end users and an S3 bucket. Transfer Acceleration takes advantage of amazon CloudFront's globally distributed edge locations. As the data arrives at an edge location, data is routed to Amazon S3 over and optimized network path.
JAPAN -> (bucket is Mumbai) <- London 
Singapore ->(bucket is Mumbai) <- Sydney


S3 - Exam Tips for S3
  • Remember that S3 is Object based i.e. allows you to upload files. 
  • Files can be from 0 bytes to 5 TB.
  • There is unlimited storage.
  • Files are stored in Buckets.
  • S3 is a universal namespace, that is, named must be unique globally
  • https://s3-eu-west-1.amazonaws.com/sgcloud
  • Read after write consistency for PUTS of new Objects.
  • Eventual Consistency for overwrite PUTS and DELETES (can take some time to propagate)
  • S3 - storage Classes/Tiers
    • S3 (durable, immediately available, frequently accessed)
    • S3 -IA (durable, immediately available, infrequently accessed)
    • S3 - Reduced Redundancy Storage (data that is easily reproducible, such as thumb nails etc).
    • Glacier - Archived data, where you can wait 3-5 hours before accessing. 
  • Remember the core fundamentals of an S3 object
    • key (name)
    • value (data)
    • Version ID
    • Metadata
    • Subresorces
      • ACL
      • Torrent
  • Object based storage only ( for files)
  • Not suitable to install an operating system on.
  • Successful uploads will generate a HTTP 200 status code.
  • Read the S3 FAQ before taking the exam. It comes up a lot!


S3 - Properties:
  1. Versioning
  2. Logging
  3. Static website hosting
  4. Tags
  5. Cross-region replication
  6. Transfer acceleration
  7. Events
  8. Requester pays      

Monday 24 July 2017

Amazon Web Services - IAM Policy List

AmazonAPIGatewayAdministrator
AmazonAPIGatewayInvokeFullAccess
AmazonAPIGatewayPushToCloudWatchLogs
AmazonAppStreamFullAccess
AmazonAppStreamReadOnlyAccess
AmazonAppStreamServiceAccess
AmazonAthenaFullAccess
AmazonCloudDirectoryFullAccess
AmazonCloudDirectoryReadOnlyAccess
AmazonCognitoDeveloperAuthenticatedIdentities
AmazonCognitoPowerUser
AmazonCognitoReadOnly
AmazonDMSCloudWatchLogsRole
AmazonDMSRedshiftS3Role
AmazonDMSVPCManagementRole
AmazonDRSVPCManagement
AmazonDynamoDBFullAccess
AmazonDynamoDBFullAccesswithDataPipeline
AmazonDynamoDBReadOnlyAccess
AmazonEC2ContainerRegistryFullAccess
AmazonEC2ContainerRegistryPowerUser
AmazonEC2ContainerRegistryReadOnly
AmazonEC2ContainerServiceAutoscaleRole
AmazonEC2ContainerServiceEventsRole
AmazonEC2ContainerServiceforEC2Role
AmazonEC2ContainerServiceFullAccess
AmazonEC2ContainerServiceRole
AmazonEC2FullAccess
AmazonEC2ReadOnlyAccess
AmazonEC2ReportsAccess
AmazonEC2RoleforAWSCodeDeploy
AmazonEC2RoleforDataPipelineRole
AmazonEC2RoleforSSM
AmazonEC2SpotFleetAutoscaleRole
AmazonEC2SpotFleetRole
AmazonEC2SpotFleetTaggingRole
AmazonElastiCacheFullAccess
AmazonElastiCacheReadOnlyAccess
AmazonElasticFileSystemFullAccess
AmazonElasticFileSystemReadOnlyAccess
AmazonElasticMapReduceforAutoScalingRole
AmazonElasticMapReduceforEC2Role
AmazonElasticMapReduceFullAccess
AmazonElasticMapReduceReadOnlyAccess
AmazonElasticMapReduceRole
AmazonElasticsearchServiceRolePolicy
AmazonElasticTranscoderFullAccess
AmazonElasticTranscoderJobsSubmitter
AmazonElasticTranscoderReadOnlyAccess
AmazonElasticTranscoderRole
AmazonESFullAccess
AmazonESReadOnlyAccess
AmazonGlacierFullAccess
AmazonGlacierReadOnlyAccess
AmazonInspectorFullAccess
AmazonInspectorReadOnlyAccess
AmazonKinesisAnalyticsFullAccess
AmazonKinesisAnalyticsReadOnly
AmazonKinesisFirehoseFullAccess
AmazonKinesisFirehoseReadOnlyAccess
AmazonKinesisFullAccess
AmazonKinesisReadOnlyAccess
AmazonLexFullAccess
AmazonLexReadOnly
AmazonLexRunBotsOnly
AmazonMachineLearningBatchPredictionsAccess
AmazonMachineLearningCreateOnlyAccess
AmazonMachineLearningFullAccess
AmazonMachineLearningManageRealTimeEndpointOnlyAccess
AmazonMachineLearningReadOnlyAccess
AmazonMachineLearningRealTimePredictionOnlyAccess
AmazonMachineLearningRoleforRedshiftDataSource
AmazonMechanicalTurkFullAccess
AmazonMechanicalTurkReadOnly
AmazonMobileAnalyticsFinancialReportAccess
AmazonMobileAnalyticsFullAccess
AmazonMobileAnalyticsNon-financialReportAccess
AmazonMobileAnalyticsWriteOnlyAccess
AmazonPollyFullAccess
AmazonPollyReadOnlyAccess
AmazonRDSDirectoryServiceAccess
AmazonRDSEnhancedMonitoringRole
AmazonRDSFullAccess
AmazonRDSReadOnlyAccess
AmazonRedshiftFullAccess
AmazonRedshiftReadOnlyAccess
AmazonRekognitionFullAccess
AmazonRekognitionReadOnlyAccess
AmazonRoute53DomainsFullAccess
AmazonRoute53DomainsReadOnlyAccess
AmazonRoute53FullAccess
AmazonRoute53ReadOnlyAccess
AmazonS3FullAccess
AmazonS3ReadOnlyAccess
AmazonSESFullAccess
AmazonSESReadOnlyAccess
AmazonSNSFullAccess
AmazonSNSReadOnlyAccess
AmazonSNSRole
AmazonSQSFullAccess
AmazonSQSReadOnlyAccess
AmazonSSMAutomationRole
AmazonSSMFullAccess
AmazonSSMMaintenanceWindowRole
AmazonSSMReadOnlyAccess
AmazonVPCCrossAccountNetworkInterfaceOperations
AmazonVPCFullAccess
AmazonVPCReadOnlyAccess
AmazonWorkMailFullAccess
AmazonWorkMailReadOnlyAccess
AmazonWorkSpacesAdmin
AmazonWorkSpacesApplicationManagerAdminAccess
AmazonZocaloFullAccess
AmazonZocaloReadOnlyAccess
ApplicationAutoScalingForAmazonAppStreamAccess
AutoScalingConsoleFullAccess
AutoScalingConsoleReadOnlyAccess
AutoScalingFullAccess
AutoScalingNotificationAccessRole
AutoScalingReadOnlyAccess
AWSAccountActivityAccess
AWSAccountUsageReportAccess
AWSAgentlessDiscoveryService
AWSApplicationDiscoveryAgentAccess
AWSApplicationDiscoveryServiceFullAccess
AWSBatchFullAccess
AWSBatchServiceRole
AWSCertificateManagerFullAccess
AWSCertificateManagerReadOnly
AWSCloudFormationReadOnlyAccess
AWSCloudHSMFullAccess
AWSCloudHSMReadOnlyAccess
AWSCloudHSMRole
AWSCloudTrailFullAccess
AWSCloudTrailReadOnlyAccess
AWSCodeBuildAdminAccess
AWSCodeBuildDeveloperAccess
AWSCodeBuildReadOnlyAccess
AWSCodeCommitFullAccess
AWSCodeCommitPowerUser
AWSCodeCommitReadOnly
AWSCodeDeployDeployerAccess
AWSCodeDeployFullAccess
AWSCodeDeployReadOnlyAccess
AWSCodeDeployRole
AWSCodePipelineApproverAccess
AWSCodePipelineCustomActionAccess
AWSCodePipelineFullAccess
AWSCodePipelineReadOnlyAccess
AWSCodeStarFullAccess
AWSCodeStarServiceRole
AWSConfigRole
AWSConfigRulesExecutionRole
AWSConfigUserAccess
AWSConnector
AWSDataPipeline_FullAccess
AWSDataPipeline_PowerUser
AWSDataPipelineRole
AWSDeviceFarmFullAccess
AWSDirectConnectFullAccess
AWSDirectConnectReadOnlyAccess
AWSDirectoryServiceFullAccess
AWSDirectoryServiceReadOnlyAccess
AWSElasticBeanstalkCustomPlatformforEC2Role
AWSElasticBeanstalkEnhancedHealth
AWSElasticBeanstalkFullAccess
AWSElasticBeanstalkMulticontainerDocker
AWSElasticBeanstalkReadOnlyAccess
AWSElasticBeanstalkService
AWSElasticBeanstalkWebTier
AWSElasticBeanstalkWorkerTier
AWSGreengrassFullAccess
AWSGreengrassResourceAccessRolePolicy
AWSHealthFullAccess
AWSImportExportFullAccess
AWSImportExportReadOnlyAccess
AWSIoTConfigAccess
AWSIoTConfigReadOnlyAccess
AWSIoTDataAccess
AWSIoTFullAccess
AWSIoTLogging
AWSIoTRuleActions
AWSKeyManagementServicePowerUser
AWSLambdaBasicExecutionRole
AWSLambdaDynamoDBExecutionRole
AWSLambdaENIManagementAccess
AWSLambdaExecute
AWSLambdaFullAccess
AWSLambdaInvocation-DynamoDB
AWSLambdaKinesisExecutionRole
AWSLambdaReadOnlyAccess
AWSLambdaRole
AWSLambdaVPCAccessExecutionRole
AWSMarketplaceFullAccess
AWSMarketplaceGetEntitlements
AWSMarketplaceManageSubscriptions
AWSMarketplaceMeteringFullAccess
AWSMarketplaceRead-only
AWSMobileHub_FullAccess
AWSMobileHub_ReadOnly
AWSMobileHub_ServiceUseOnly
AWSOpsWorksCloudWatchLogs
AWSOpsWorksCMInstanceProfileRole
AWSOpsWorksCMServiceRole
AWSOpsWorksFullAccess
AWSOpsWorksInstanceRegistration
AWSOpsWorksRegisterCLI
AWSOpsWorksRole
AWSQuicksightAthenaAccess
AWSQuickSightDescribeRDS
AWSQuickSightDescribeRedshift
AWSQuickSightListIAM
AWSStepFunctionsConsoleFullAccess
AWSStepFunctionsFullAccess
AWSStepFunctionsReadOnlyAccess
AWSStorageGatewayFullAccess
AWSStorageGatewayReadOnlyAccess
AWSSupportAccess
AWSWAFFullAccess
AWSWAFReadOnlyAccess
AWSXrayFullAccess
AWSXrayReadOnlyAccess
AWSXrayWriteOnlyAccess
Billing
CloudFrontFullAccess
CloudFrontReadOnlyAccess
CloudSearchFullAccess
CloudSearchReadOnlyAccess
CloudWatchActionsEC2Access
CloudWatchEventsBuiltInTargetExecutionAccess
CloudWatchEventsFullAccess
CloudWatchEventsInvocationAccess
CloudWatchEventsReadOnlyAccess
CloudWatchFullAccess
CloudWatchLogsFullAccess
CloudWatchLogsReadOnlyAccess
CloudWatchReadOnlyAccess
DatabaseAdministrator
DataScientist
IAMFullAccess
IAMReadOnlyAccess
IAMSelfManageServiceSpecificCredentials
IAMUserChangePassword
IAMUserSSHKeys
NetworkAdministrator
PowerUserAccess
QuickSightAccessForS3StorageManagementAnalyticsReadOnly
RDSCloudHsmAuthorizationRole
ReadOnlyAccess
ResourceGroupsandTagEditorFullAccess
ResourceGroupsandTagEditorReadOnlyAccess
SecurityAudit
ServerMigrationConnector
ServerMigrationServiceRole
ServiceCatalogAdminFullAccess
ServiceCatalogAdminReadOnlyAccess
ServiceCatalogEndUserAccess
ServiceCatalogEndUserFullAccess
SimpleWorkflowFullAccess
SupportUser
SystemAdministrator
ViewOnlyAccess
VMImportExportRoleForAWSConnector

Tuesday 18 July 2017

Amazon Web Services - Identity Access Management

What is IAM?

Essentially, IAM allows you to manage users and their level of access to the AWS Console. It is important to understand IAM and how it works, both for the exam and for administration a company's AWS account in real life.

What does IAM gives you?
  • Centralised control of your AWS account 
  • Shared Access to you AWS account
  • Granular Permissions
  • Identity Federation( including Active Directory, Facebook, Linkedin etc)
  • Multifactor Authentication
  • Provide temporary access of users/devices and services where necessary
  • Allows you to set up your own password rotation policy 
  • Integrates with many different AWS services
  • Supports PCI DSS Compliance

Critical Terms:
  • Users - End Users (think people)
  • Groups - A collection of users under one set of permissions.
  • Roes - You create roles and can then assign them to AWS resources.
  • Policies - A document that defines one (or more permissions)

LAB:

Create Groups: An IAM group is a collection of IAM users. Groups let you specify permissions for multiple users, which can make it easier to manage the permissions for those users. For example, you could have a group called Admins and give that group the types of permissions that administrators typically need. Any user in that group automatically has the permissions that are assigned to the group.
  1. SG_SYSTEM_ADMIN
  2. SG_S3_RW
  3. SG_S3_R

Create User:
  1. SANDEEP - SG_SYSTEM_ADMIN
  2. PAWAN - SG_S3_RW
  3. POONAM - SG_S3_RW
  4. ISHAN - SG_S3_RW
  5. HIMANSHU - SG_S3_R
  6. JITENDER - SG_S3_R
  
Create Roles: it a way to allow one AWS service to interact with another AWS service.
S3-ADMIN-ACCESS

Policy / Permissions:
Can add permissions to individually or to group.
  1. AmazonGlacierReadOnlyAccess - AWS Managed Policy
  2. IAMUserChangePassword - AWS Manage Policy
  3. AmazonS3ReadOnlyAccess - AWS Manage Policy from group HR

IAM Consists of the below:
  1. Users
  2. Groups (A way to group our users and apply polices to them collectively)
  3. Roles
  4. Policy Documents (json doc)
  5. IAM is universal. It does not apply to regions at this time.
  6. The root account is simply the account created when first setup AWS account. It has complete Admin access. 
  7. New users has NO permissions when first created.
  8. New users are assigned Access Key ID & Secret Access Keys when first created. You can use this to access AWS via the APIs and command line.
  9. You only get to view these once. If you loose them, you have to regenerate them. So save them in a secure location. 
  10. Always setup Multifactor Authentication on your root account.
  11. You can create and customise your own password rotation policies.




Amazon Web Services

- Why  AWS ?

  • Fastest growing cloud computing platform on the planet
  • Largest public cloud computing platform on the planet
  • More and more organisations are outsourcing their IT to AWS
  • The AWS certifications are the most popular IT certifications right now.
  • Top Paid IT Certification for 2016 according to Forbes  

    - ASW Partner Program

    Technology Partner
    • Alert Logic
    • CloudBerry Lab
    • Sumo Logic
    • Datadog
    • New Relic etc
    Consulting Partner
    • Logicworks
    • Rackspace
    • Accenture
    • Datapipe

     

    AWS Partner Program:

    Partner------------------------Associate Certs------------------Professional Certs
    Standard----------------------------2   ---------------------------------------------0
    Advanced---------------------------4   ---------------------------------------------2
    Permier------------------------------20 ---------------------------------------------8

    Certification Levels:

    Speciality              Security------Advanced Networking---Big Data
    Professional Tier  Certified Solution Architect Professional ----- Devops Professional             
    Associate Tier       Certified Solutions Architect Associate     ---- Certified Developer Associate ---- Certified Sysops Administrator Associate  

    Certification Level Easy to Hard

    Deevloper Associate
    Solution Architect Associate
    Sysops Administrator Associate
    Security Specialty
    Big Data Specialty
    Devops Pro
    Advance Network Specialty
    Solutions Architect Professional

    Create an AWS Free Tier Account

    https://aws.amazon.com/free
    SSH Terminal
    Domain name (optional)

    Exam Blue Print

    Objective  ------------------------------------------------------------Weight
    Designing highly available, cost efficient, fault tolerant, scaleable systems -- 60
    Implementing/ Deploying---------------------------------------10%
    Data Security---------------------------------------------------------20%
    Troubleshooting-----------------------------------------------------10%
    80 Minutes in Length
    60 Questions (can change)
    Multiple Choice
    Pass mark is based on a bell curve (it moves around).
    Aim for 70%
    Qualification is valid for 2 years
    Scenario based questions

    AWS History

    Invention requires two things.
    1. The ability to try a log to experiments, and
    2. not having to live with the collateral damage of failed experiments.

    AWS Main Services

    1. Compute
    2. Storage
    3. Database
    4. Migration
    5. Networking & Content Delivery
    6. Developer Tools
    7. Management Tools
    8. Artificial Intelligence
    9. Analytics
    10. Security, Identity & Compliance
    11. Mobile Services
    12. AWS Cost Management
    13. Application Services
    14. Messaging
    15. Business Productivity
    16. Desktop & App Streaming
    17. Software
    18. Internet of Things
    19. Contact Center
    20. Game Development

     

    To pass the "Certified Solutions Architect" Associate Exam, below services required.

    1. Messaging
    2. Desktop & App Streaming
    3. Security & Indentity
    4. Management Tools
    5. Storage
    6. Database
    7. Networking & Content Delivery
    8. Compute
    9. AWS Global Infrastructure

    AWS Global Infrastructure

    14 Regions & 38 Availability Zones - December 2016, 4 More Regions & 11 More Availability Zones-2017

    What is Region ?

    A Region is a geographical area. Each region consists of 2 (or more) Availability Zones. An Availability Zone (AZ) is simply a Data Center.

    AZ-A-------------AZ-B-------------AZ-C--------------AZ-A

    What is An Edge Logation?

    Edge Location are CDN End Points for Cloud Front. There are many Edge Locations than Regions. Currently there are over 66 Edge Locations.


    - VPC ?Virtual data center where you going to deploy your data.

    - Route53?
    Its a Amazon DNS service.

    - Route66?
    Old amazon dns service.

    - Cloud Front?
    is part of content delivery network

    -Direct Connect?
    connecting your physical datacenters/ offices to AWS servers directly through telephone lines. It  can come in exams.

    -EC2?
    Elastic compute cloud. It's a virtual machine that runs on aws.

    -EC2 Container Services?


    -Elastic Beanstalk?
    Deploy your code into AWS web services.

    -Lambda?
    it is very important topic in AWS.

    -Lightsail?
    its a brand new service invented in 2016.

    STORAGE? (Consists of 4 different Components)

    1. S3 - Place to put objects into the cloud. It is Virtual disks on the cloud for objects storage. like pictures, movies etc. Its a object based storage. 
    2. Glacier - place where you archive you files for future use. Its can't access frequently, it takes 3-4 hours to access. 
    3. EFS - stands for elastic files service. Its a place where you can store your databases and can share on different virtual machines. can store games, databases.
    4. Storage Gateway - connecting your

    DATABASES? ()

    1. RDS - Relational database service. it consists of number of database technology. Mysql, SqlServer etc. Its a relational database.
    2. DynamoDB - Its a non relational database. Its essential for developers exam.
    3. Redshift - 
    4. Elasticache - Caching your data into the cloud. 

    MIGRATION SERVICES

    1. Snowball-
    2. DMS - Database Migration Service. Migrate database from location machine to AWS cloud. No downtime, Migrated to different databases. 
    3. Server Migration Services (SMS) - this target VMware virtual machines. it can replicate vmware virtual machine on to the cloud. 

    ANALYTICS

    1. Athena -
    2. EMR- Need for big data. 
    3. Cloud Search -
    4. Elastic Search -
    5. Kinesis -
    6. Data Pipeline -
    7. Quick Sight - Business analytics tool.
     

    SECURITY & IDENTITY

    1. IAM - this it the fundamental service.
    2. Inspector - 
    3. Certificate Manager -
    4. Directory Service - 
    5. WAF - 
    6. Artifact - 

    MANAGEMENT TOOLS

    1. Cloud Watch - 
    2. Cloud Formation -  
    3. Cloud Trail - 
    4. Opsworks - 
    5. Config - 
    6. Service Catalog - 
    7. Trusted Advisor -

    APPLICATION SERVICES

    1. Step Functions -
    2. SWF - 
    3. API Gateway
    4. AppStream - streaming desktop applications. 
    5. Elastic Transcoder - 

    DEVELOPER TOOLS

    1. CodeCommit
    2. CodeBuild
    3. CodeDeploy
    4. CodePipeline

    MOBILE SERVICES

    1. Mobile hub
    2. Cognito
    3. Device Farm
    4. Mobile Analytics
    5. Pinpoint

    BUSINESS PRODUCTIVITY

    1. WorkDocs
    2. WorkMails

    INTERNET OF THINGS

    1. iOT

    DESKTOP & APP STREAMING

    1. WorkSpaces
    2. AppStream 2.0

    ARTIFICIAL INTELLIGENCE

    1. Alexa
    2. Polly
    3. Machine Learning
    4. Rekognition

    MESSAGING

    1. SNS
    2. SQS

    Monday 17 July 2017

    Claim empty space of tablespace to reuse

    PSIMAGE has 83% free space and need to reclaim it.

    SQL> select df.tablespace_name "Tablespace",
     totalusedspace "Used MB",
     (df.totalspace - tu.totalusedspace) "Free MB",
     df.totalspace "Total MB",
     round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
     "Pct. Free"
     from
     (select tablespace_name,
     round(sum(bytes) / 1048576) TotalSpace
     from dba_data_files
     group by tablespace_name) df,
     (select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
     from dba_segments
     group by tablespace_name) tu
     where df.tablespace_name = tu.tablespace_name AND
    df.tablespace_name='PSIMAGE';


    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ----------------------             -----------         -----------       -----------      ----------
    PSIMAGE                   4,978           23,530       28,508      83


    SQL>
    SQL> SELECT * from dba_directories;

    OWNER DIRECTORY_NAME
    ------------------------------ ------------------------------
    DIRECTORY_PATH
    --------------------------------------------------------------------------------
    SYS PRD_DIR
    /backup1/expimp/hrprd

    create directory DUATBK_DIR as '/backup/dbbackup';
    grant read, write on directory DUATBK_DIR to system;

    TAKE FULL BACKUP:-
    expdp system/manager full=y directory=DUATBK_DIR dumpfile='DUAT27MAY2017.dmp' logfile='DUAT27MAY2017.log';

    TAKE PSIMAGE TABLESPACE BACKUP:-
    expdp system/manager DIRECTORY=DUATBK_DIR DUMPFILE=DUAT27MAY2017TBLPSIMAGE.dmp LOGFILE=DUAT27MAY2017TBLPSIMAGE_LOG.log TABLESPACES= PSIMAGE;


    SQL> select file_name from dba_data_files where tablespace_name='PSIMAGE';

    FILE_NAME
    --------------------------------------------------------------------------------
    /backup1/oradata/duat/psimage.dbf


    DROP TABLESPACE PSIMAGE INCLUDING CONTENTS and datafile;

    SQL> DROP TABLESPACE PSIMAGE INCLUDING CONTENTS;

    Tablespace dropped.


    Now, PSIMAGE tablespace must not available in database.

    SELECT tablespace_name FROM dba_tablespaces where tablespace_name='PSIMAGE';
    SELECT file_name FROM dba_data_files where tablespace_name='PSIMAGE';


    Create tablespace again:
    ----------------------------------------
    CREATE TABLESPACE PSIMAGE DATAFILE '/backup1/oradata/duat/psimage.dbf' SIZE 1813M EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;


    Alter tablespace datafile:
    ----------------------------------------
    ALTER DATABASE DATAFILE '/backup1/oradata/duat/psimage.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;


    Import data from backup using impdp:
    --------------------------------------------------------------
    impdp system/manager DIRECTORY=DUATBK_DIR DUMPFILE=DUAT27MAY2017TBLPSIMAGE.dmp LOGFILE=DUAT27MAY2017TBLPSIMAGE_LOG-IMP.log TABLESPACES= PSIMAGE;

    Check now, database tablespace PSIMAGE size should be according to the original data only.

    Temporary tablespace and files management in oracle

    CREATE TEMP TABLESPACE:
    -----------------------
    CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE '/u01/oradata/tst/temp01.dbf' size 1024M extent management local uniform size 1M;
    CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE '+ORA_DB' SIZE 1G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;


    ADD TEMP FILES IN TEMPORARY TABLESPACE:
    ---------------------------------------
    ALTER TABLESPACE TEMP01 ADD tempfile '/u01/oradata/tst/temp02.dbf' SIZE 1G AUTOEXTEND ON NEXT 1G MAXSIZE 20G;
    ALTER TABLESPACE TEMP01 ADD tempfile '+ORA_DB' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;


    DROP TEMP TABLESPACE:
    ---------------------
    DROP TABLESPACE TEMP01 including contents and datafiles;


    LIST ALL TEMPFILES OF TEMP TABLESPACE:
    -------------------------------------

    SQL> col file_name for a45
    select tablespace_name,file_name,bytes/1024/1024,maxbytes/1024/1024,autoextensible from dba_temp_files order by file_name;

    TABLESPACE_NAME FILE_NAME BYTES/1024/1024 MAXBYTES/1024/1024 AUTOEXTENSIBLE
    ---------------- ---------------------------------- --------------- ------------------ ------------------
    TEMP01 /u01/oradata/tst/temp01.dbf 300 0 NO
    TEMP01 /u01/oradata/tst/temp02.dbf 20 32767 YES



    SET DEFAULT TEMP TABLESPACE:
    ---------------------------
    alter database default temporary tablespace TEMP;

    SET DEFAULT TEMP TABLESPACE FOR USER:
    -------------------------------------
    ALTER USER SYSADM TEMPORARY TABLESPACE PSTEMP1;
    ALTER USER PEOPLE TEMPORARY TABLESPACE PSTEMP1;

    SQL queries which are using CPU resources

    select
    ss.username,
    ss.serial#,
    se.SID,
    VALUE/100 cpu_usage_seconds
    from
    v$session ss,
    v$sesstat se,
    v$statname sn
    where
    se.STATISTIC# = sn.STATISTIC#
    and
    NAME like '%CPU used by this session%'
    and
    se.SID = ss.SID
    and
    ss.status='ACTIVE'
    and
    ss.username is not null
    order by VALUE desc;

    Query to count hourly log switch in oracle

    SQL> set lines 120;
    set pages 999;
    SQL> SQL>
    SQL> SELECT
    2 to_char(first_time,'YYYY-MON-DD') day,
    3 to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'99') "00",
    4 to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'99') "01",
    5 to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)),'99') "02",
    6 to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)),'99') "03",
    7 to_char(sum(decode(to_char(first_time,'HH24'),'04',1,0)),'99') "04",
    8 to_char(sum(decode(to_char(first_time,'HH24'),'05',1,0)),'99') "05",
    9 to_char(sum(decode(to_char(first_time,'HH24'),'06',1,0)),'99') "06",
    10 to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)),'99') "07",
    11 to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)),'99') "0",
    12 to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)),'99') "09",
    13 to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)),'99') "10",
    14 to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)),'99') "11",
    15 to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)),'99') "12",
    16 to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)),'99') "13",
    17 to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)),'99') "14",
    18 to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)),'99') "15",
    19 to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)),'99') "16",
    20 to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)),'99') "17",
    21 to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)),'99') "18",
    22 to_char(sum(decode(to_char(first_time,'HH24'),'19',1,0)),'99') "19",
    23 to_char(sum(decode(to_char(first_time,'HH24'),'20',1,0)),'99') "20",
    24 to_char(sum(decode(to_char(first_time,'HH24'),'21',1,0)),'99') "21",
    25 to_char(sum(decode(to_char(first_time,'HH24'),'22',1,0)),'99') "22",
    26 to_char(sum(decode(to_char(first_time,'HH24'),'23',1,0)),'99') "23"
    27 from
    28 v$log_history
    29 GROUP by
    30 to_char(first_time,'YYYY-MON-DD') ;

    DAY 00 01 02 03 04 05 06 07 0 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23
    --------------- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
    2017-JUL-06 1 0 0 0 2 0 1 2 0 7 36 45 37 43 37 44 50 37 22 9 2 1 1 0
    2017-JUL-07 1 0 0 0 0 0 1 1 1 4 22 29 24 42 33 40 49 67 28 14 4 2 0 0
    2017-JUL-08 0 0 0 1 0 0 1 0 0 0 1 6 7 5 3 4 3 1 3 0 0 1 1 0
    2017-JUL-05 0 0 0 0 0 1 1 0 0 0 0 60 57 56 37 48 71 69 40 19 4 0 0 0
    2017-JUL-13 1 1 0 0 0 0 0 1 0 5 18 23 28 29 20 27 47 32 20 8 0 1 1 0
    2017-JUL-09 1 0 0 0 0 0 1 1 0 0 0 0 1 2 0 2 0 0 2 1 0 0 0 0
    2017-JUL-11 2 0 0 0 0 0 1 0 2 4 22 33 27 27 22 34 40 44 26 11 3 0 0 0
    2017-JUL-10 1 0 0 0 0 0 1 0 0 2 18 20 32 24 25 29 41 45 26 12 3 1 1 0
    2017-JUL-12 2 0 0 0 0 0 1 0 1 3 17 30 24 26 21 34 44 34 25 16 3 1 0 0
    2017-JUL-14 0 0 0 0 0 0 2 0 0 3 16 15 20 16 16 22 28 28 16 5 1 0 2 0
    2017-JUL-16 1 0 0 0 0 1 0 0 1 1 0 0 1 0 1 0 1 0 0 1 0 0 0 0
    2017-JUL-15 0 0 0 0 0 0 1 0 0 3 14 26 23 24 13 20 28 22 16 3 3 0 0 0
    2017-JUL-17 2 0 0 0 0 0 1 0 0 2 8 28 17 26 35 0 0 0 0 0 0 0 0 0
    2017-JUL-04 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 21 6 2 2 0

    14 rows selected.


    col day format a15;
    col hour format a4;
    col total format 999;

    select
    to_char(first_time,'yyyy-mm-dd') day,
    to_char(first_time,'hh24') hour,
    count(*) total
    from v$log_history
    group by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24')
    order by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24') asc;

    DAY HOUR TOTAL
    --------------- ---- -----
    2017-07-14 15 22
    2017-07-14 16 28
    2017-07-14 17 28
    2017-07-14 18 16
    2017-07-14 19 5
    2017-07-14 20 1
    2017-07-14 22 2
    2017-07-15 06 1
    2017-07-15 09 3
    2017-07-15 10 14
    2017-07-15 11 26

    DAY HOUR TOTAL
    --------------- ---- -----
    2017-07-15 12 23
    2017-07-15 13 24
    2017-07-15 14 13
    2017-07-15 15 20
    2017-07-15 16 28
    2017-07-15 17 22
    2017-07-15 18 16
    2017-07-15 19 3
    2017-07-15 20 3
    2017-07-16 00 1
    2017-07-16 05 1

    DAY HOUR TOTAL
    --------------- ---- -----
    2017-07-16 08 1
    2017-07-16 09 1
    2017-07-16 12 1
    2017-07-16 14 1
    2017-07-16 16 1
    2017-07-16 19 1
    2017-07-17 00 2
    2017-07-17 06 1
    2017-07-17 09 2
    2017-07-17 10 8
    2017-07-17 11 28

    DAY HOUR TOTAL
    --------------- ---- -----
    2017-07-17 12 17
    2017-07-17 13 26
    2017-07-17 14 35

    179 rows selected.

    How to check oracle users, alter user password, unlock user

    HOW TO CHECK ORACLE USERS AND THEIR STATUS:
    -------------------------------------------

    SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE from dba_users;

    USERNAME ACCOUNT_STATUS EXPIRY_DA
    ------------------------------ -------------------------------- ---------
    OUTLN OPEN 15-MAR-14
    PEOPLE OPEN 11-JUL-17
    PS OPEN 05-JUN-17
    SYS OPEN 15-MAR-14
    SYSTEM OPEN 05-JUN-17
    SYSADM EXPIRED 12-JUN-17
    APPQOSSYS EXPIRED & LOCKED 16-SEP-13
    DIP EXPIRED & LOCKED 16-SEP-13
    DBSNMP EXPIRED & LOCKED 16-SEP-13
    ORACLE_OCM EXPIRED & LOCKED 16-SEP-13

    10 rows selected.

    CHANGE USER PASSWORD:
    ---------------------
    ALTER USER myuser IDENTIFIED BY new_password;

    ALTER USER myuser ACCOUNT LOCK;
    ALTER USER myuser ACCOUNT UNLOCK;
    ALTER USER myuser PASSWORD EXPIRE;

    how to view datafiles available in tablespace

    FETCH ALL DATAFILES WITH TABLESPACE NAME:
    -----------------------------------------
    col tablespace_name format a16;
    col file_name format a36;
    SELECT TABLESPACE_NAME, FILE_NAME, BYTES FROM DBA_DATA_FILES;


    FETCH DATAFILES AVAILABLE IN TABLESPACE:
    ----------------------------------------
    select file_name from dba_data_files where tablespace_name='PSIMAGE';

    FILE_NAME
    --------------------------------------------------------------------------------
    +ORA_DB/hrprd/datafile/psimage.221.81503
    +ORA_DB/hrprd/datafile/psimage.450.97645
    +ORA_DB/hrprd/datafile/psimage.589.94091


    FETCH DATAFILE SPACE, MAXIMUM SPACE, AUTOEXTEND OF DATAFILE:
    -----------------------------------------------------------
    set linesize 124
    col file_name format a60
    col AUTOEXTENSIBLE format a18
    SELECT FILE_NAME, BYTES/(1024*1024), MAXBYTES/(1024*1024), AUTOEXTENSIBLE from DBA_DATA_FILES
    WHERE TABLESPACE_NAME='PSIMAGE';

    FILE_NAME BYTES/(1024*1024) MAXBYTES/(1024*1024) AUTOEXTENSIBLE
    --------------------------------- ----------------- -------------------- ------------------
    /u01/oradata/hrdemo/psimage.dbf 1813 32767.9844 YES

    how to export database using expdp export

    To export oracle database using expdp follow the below steps:

    1. Create Directory Path.

    SQL> create directory BACKUP_DIR as '/backup/dailybackup';
    Directory created.

    SQL> grant read, write on directory BACKUP_DIR to system;
    Grant succeeded.


    2. Ensure the directory by following query.

    SQL>
    SELECT directory_path from dba_directories;
    SELECT * from dba_directories;

    3. exit from sql prompt.

    SQL> exit;

    4. To backup database in full export mode issue to following data pump command:

    EXPORT FULL BACKUP
    ==================
    [oracle@oracle ~]$ expdp system/manager full=y directory=BACKUP_DIR dumpfile='DB09MAR2017.dmp' logfile='DB09MAR2017.log';


    EXPORT BACKUP of TABLESPACE
    ===========================
    expdp hr/hr@ORCL DIRECTORY=exp_tblsp DUMPFILE=tablespace.dmp LOGFILE=tblsp_log.log TABLESPACES=USERS,EXAMPLE;
    expdp system/manager DIRECTORY=BACKUP_DIR DUMPFILE=tablespace.dmp LOGFILE=tblsp_log.log TABLESPACES= PSIMAGE;

    how to add datafile to tablespace

    ADDING DATAFILE TO TABLESPACE IN Filesystem DB:
    ==========================================
    ALTER TABLESPACE users ADD DATAFILE '/u01/oracle/oradata/users_02.dbf' size 100m;


    ADDING DATAFILE TO TABLESPACE IN ASM RAC:
    ========================================
    alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G;

    alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;

    alter tablespace AAAPP add datafile '+ORA_DB' size 1G AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;

    alter tablespace GPAPP add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;


    RESIZE DATAFILE IN TABLESPACE (ASM RAC):
    =====================================
    alter database datafile '+ORA_DB/hrprd/datafile/gpapp.552.9454654566' resize 5G;

    query to check tablespace size and freespace

    [oracle@oeldev ~]$ export ORACLE_SID=HRDEMO
    [oracle@oeldev ~]$ sqlplus / as sysdba;

    SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 17 13:02:33 2017

    Copyright (c) 1982, 2011, Oracle.  All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL>
    col "Tablespace" for a22
    col "Used MB" for 99,999,999col "Free MB" for 99,999,999
    col "Total MB" for 99,999,999
    SQL>
    SQL> select df.tablespace_name "Tablespace",
        totalusedspace "Used MB",
        (df.totalspace - tu.totalusedspace) "Free MB",
        df.totalspace "Total MB",
        round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
        "Pct. Free"
        from
        (select tablespace_name,
        round(sum(bytes) / 1048576) TotalSpace
       from dba_data_files
       group by tablespace_name) df,
       (select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
       from dba_segments
       group by tablespace_name) tu
       where df.tablespace_name = tu.tablespace_name ;

    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ---------------------- ----------- ----------- ----------- ----------
    BNAPP                           14          38          52         73
    HRLARGE                      39          52          91         57
    HRAPP2                          6          12          18          67
    EOAPP                            1          24          25          96
    PTTLRG                          336     186         522        36
    COAPP                            1           6           7            86
    HTAPP                            0           3           3            100
    PSIMAGE2                     1,106    64        1,170        5
    PSUNDOTS                    33       2,187     2,220       99
    SYSAUX                          615       45         660         7
    PTTBL                            132       132         264       50

    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ---------------------- ----------- ----------- ----------- ----------
    PSIMAGE                        911         902       1,813         50
    PTAMSG                           4          39          43         91
    PTWORK                           1          11          12         92
    PTPRJWK                          0           8           8        100
    PSIMGR                            2           2           4         50
    CULARGE                          0           6           6        100
    PAAPP                              12          47          59         80
    EPAPP                               2          13          15         87
    STWORK                           0          17          17        100
    PIAPP                               2           7           9         78
    PILARGE                          1           3           4         75

    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ---------------------- ----------- ----------- ----------- ----------
    PTPRC                            3           9          12         75
    STLARGE                       4           9          13         69
    HRAPP3                          2           5           7         71
    SAAPP                          100         200         300         67
    HRAPP6                          2          33          35         94
    TLAPP                           19          81         100         81
    BNLARGE                     15          12          27         44
    HRSWORK                      0          15          15        100
    SYSTEM                       706       1,294       2,000         65
    AAAPP                            7          15          22         68
    SRAPP                           65          86         151         57

    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ---------------------- ----------- ----------- ----------- ----------
    HPAPP                           37          38          75         51
    GIAPP                            2           6           8         75
    FALARGE                      9           8          17         47
    HRSAPP                       16          48          64         75
    PVAPP                            0           4           4        100
    PTLOCK                         0           3           3        100
    PSDEFAULT                  0         100         100        100
    HRAPP                          97         253         350         72
    PSINDEX                   2,966       3,034       6,000         51
    ADAPP                           11          49          60         82
    CCAPP                           12         238         250         95

    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ---------------------- ----------- ----------- ----------- ----------
    SALARGE                        1           8           9         89
    PTAPPE                           2           3           5         60
    PTAPP                           16          34          50         68
    TLLARGE                        5          35          40         88
    GPAPP                          349         811       1,160         70
    EOEWAPP                       0           9           9        100
    ERAPP                            1          12          13         92
    HRSLARGE                    1           7           8         88
    HRWORK                        0          20          20        100
    PYAPP                           37          73         110         66
    FAAPP                          173         127         300         42

    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ---------------------- ----------- ----------- ----------- ----------
    HRAPP1                           6          16          22         73
    HRAPP7                           1           7           8         88
    AVAPP                            6          13          19         68
    HRAPP5                           0          13          13        100
    PTRPTS                           1           2           3         67
    EOECAPP                          4          21          25         84
    EPLARGE                          2           8          10         80
    FGAPP                           11          24          35         69
    PALARGE                          2           5           7         71
    PCLARGE                          0           5           5        100
    AALARGE                          1           6           7         86

    Tablespace                 Used MB     Free MB    Total MB  Pct. Free
    ---------------------- ----------- ----------- ----------- ----------
    STAPP                            9          23          32         72
    HRAPP4                           4          12          16         75
    PY0LRG                          76          53         129         41
    FSAPP                            2           3           5         60
    PCAPP                            1           4           5         80
    EOCFAPP                          3          17          20         85
    EOIUAPP                          0           3           3        100
    PTTREE                           3           3           6         50

    74 rows selected.

    SQL>

    Check Space Available On Disk Group

    Check Space Available On Disk Group:
    ========================

    SQL> select name , free_mb/1024 from v$asm_diskgroup;

    NAME                           FREE_MB/1024
    ------------------------------        --------------------------
    OCR_DATA                    9.21679688
    ORA_ARCH                   190.402344
    ORA_DB                        34.3730469
    ORA_FRA                      656.569336
    ORA_DB1                      499.897461

    DELETE Archive Logs using RMAN

    In DC and DR environment where RAC and Data Guard implemented. Delete old / applied archive logs files to create space on archive log mount point.

    Steps to delete archive files. 
    1. Check archive log sequence on Primary Database.

    On DC Machine:-
    ===========

    SQL> archive log list;
    Database log mode              Archive Mode
    Automatic archival             Enabled
    Archive destination            +ORA_ARCH
    Oldest online log sequence     28006
    Next log sequence to archive   28008
    Current log sequence           28008




    2. Check applied archive log sequence on DR database. 

    ON DR Machine:
    ===========

    SQL> select thread#,max(sequence#) from gv$archived_log where applied='YES' group by thread#;
       THREAD# MAX(SEQUENCE#)
    ---------- --------------
             1          28006
             2          23353


    3. Connect RMAN on DC Database Machine.

    rman target /


    4. Here, We are deleting archive log till 1 days back from current date time. This command will release space on DC database.

    delete noprompt archivelog until time 'SYSDATE - 1';

    5. Repeat the above step on DR database as well to release space.

    rman target /

    delete noprompt archivelog until time 'SYSDATE - 1';




    Jenkins Startup and Configuration

    Steps to setup jenkins on ubuntu:- -After installation. check the jenkins services running on not on the server. sudo service jenk...