Sunday 22 May 2022

Business Economics - Covid 19 Sheet

Business Economics - Covid 19 Sheet 

Question 1A: Name and describe the phenomenon which involves such joint decision-making.

What are its advantages and disadvantages?

when Oligopolies firms comes together and makes joint decision that is called collusion.

Advantages of such decision-making could be the following:

 High Profits: Due to little competition in market they have potential to bring large number of

benefits.

 Simple Choices : Having only a few companies that offer the goods or service that you are

looking for makes it easy to compare between them and choose the best option for you.

 Competitive Prices: No single firms can increase prices Being able to easily compare prices

forces these companies to keep their prices in competition with the other companies involved in

the market. Example OPEC they make prices steady as economy are dependent on oil export

and imports.

More investment in research and development on profit margins to make operating cost less or to make

product better.

Disadvantages of such decision-making could be the following:

 Less choice for consumer: consumers has very limited choices and options for the services

that they want. This is one of the biggest pitfalls of an oligopoly. example coca cola, Pepsi and

Telecommunications company.

 Fixed Prices Are Bad for Consumers: No discounts on products

 No Fear of Competition: Due to very settled and stable business vey less competition.

 Difficult to Forge A Spot: For small firms it is very difficult to find spot in oligopoly firms.

Question 1B: What made OPEC decide to cut the supply of oil? What was the desired outcome

of the decision? What was the change in the supply and demand curves of oil and the

subsequent market equilibria? Analyze the changes both before and after the decision to reduce

supply.

What made OPEC decide to cut the supply of oil?

Due to lockdown imposed by governments so manufacturing firms shut down and demand of oil got

reduced OPEC decided to cut oil supply, But OPEC resume their production in same manner. Supply

was same but demand was less due to this crude oil price goes down and country like china and India

make benefits and reserves the oil.

What was the change in the supply and demand curves of oil and the subsequent market

equilibria?

Majorly Logistics, manufacturing units were playing part for demand in crude oil. Due to reduce in

demand, there is also reduction oil refineries like reliance got impacted as their production also went

down. Demand curve moves left.

Manpower also got reduced. Demand for other items also got impacted. And other items supply also

impacted both domestic as well as globally. Subsequently global economies to also looking for a

substitute.

Analyze the changes both before and after the decision to reduce supply.

Changes in oil Before supply

OPEC getting surplus benefits before covid 19 form oil dependency organization due to all demands.

Trade deficit as lots of import of crude oil.

Changes After supply

Consumers got benefited. Oil and gas Refineries firms got impacted due to low production and salary

wages also impacted. Trade deficit got reduced those who are depended on oil import like china and

India.

Question 1C: What market structure does the OPEC operate in? What are the key features of such

a market structure?

Oligopoly market structure OPEC operates. Here they are limited numbers of suppliers | producers and

distributers of certain oil and gas products.

Total 13 countries part of the Organization of the Petroleum Exporting Countries (OPEC) which makes

joint decision and controls over 50% of global oil supplies and about 90% of proven oil reserves.

Key Features:

Firms make decisions to beat competition: The firms cooperate with each other in determining price

or output or both

Interdependence: Firms under oligopoly are interdependent

Few firms: Less advertisements and more research to reduce operational costs.

Question 2

Question 2A: Assume that the business was operating at the profit maximizing level of output

before Covid-19. Each article brought in an ad revenue of €375.

Maximum profit no. of journalist is 8.

How many articles was the business producing?

92

What was the total profit?

Maximum earning per month will be = ad revenue per article * No. of articles per month =

375*92 = 34500 €

Total profit = maximum earning -( wages of 8 journalists + office building and utilities cost)

= 34500 -(3000*8+8000) = 2500 €

Explain conceptually how you arrived at the profit maximizing level of output. You don't need

to show exact calculations

Profit maximum level output - Marginal profit is marginal revenue minus marginal cost and total profit

is the sum of marginal profits. In this case the total revenue per month and reduced the total revenue.

Question 2B: On 9th March 2020, Italy went into lockdown. As a result, you had to shut down your

office and adopt a ‘work from home’ policy. This eliminated your fixed costs of €8000. At the same

time, your ad revenue per article reduced to €250. This was because all companies suddenly

reduced their advertising spending.

How many journalists would you have to fire? Assume that you only care about maximizing

profits.

6 journalists

What is your new total profit?

Total profit=1500

Why did you fire the journalists? Explain your answer conceptually. You don’t need to show exact

calculations

Ad revenue are less during covid19 period, Profit margin was zero or negative as if number of journalists

remains same. In order to balance profit journalists were fired.

Question 3

3A: What type of unemployment would a country like India experience from such a pandemic?

Please provide an explanation.

Cyclical unemployment takes place when the demand in an economy begins to decrease. In such cases,

the producers reduce their supply and, in the process, let go of employees.

First supply affected from china. After WHO declare pandemics lockdown implemented and there is

suddenly demand of goods and services got affected and drops. That leads to reduction in supply and

production. Also leads to reduction in manpower which causes layoffs in order to maintain the balance

in benefits. After mass layoff consumer are in saving modes and leakage in macroeconomics.

It drives to John Maynard Keynes' theory: That aggregate demand drives production in an economy.

Stock market got crashed supplier retailer and consumers all got affected.

3B: What type of recession would be caused by such a pandemic? Provide an explanation.

Supply-led recession earlier in china as sudden decrease in the supply of an essential commodity,

which affects production in an economy.

After WHO declares pandemics and lockdown in across the world.

Demand-led recession occurs when there is a lack of demand in an economy owing to various factors

like an increase in leakage from the economy by way of high imports or high savings, higher taxes, etc.

3C: What would happen to the aggregate demand and aggregate supply in India because of the

above two phenomena? Elaborate your answer.

Both aggregate demand and supply got affected, Automotive demand got reduced | tourism hospitality

air supply logistics rail transport, loan failure. Increase in Insurance cover, medical health packages, term

plan, hospital, telecommunication and IT sectors.

As per Keynes' Law states that demand creates its own supply. Overall, aggregate demand continues to

lag aggregate supply, especially due to weak services activity and subdued urban consumption.

India saw the sharpest decline in economic output among major. The vein hunt for a painless way out of

our current covid bubble ... In other words, the aggregate supply shock was bigger than the aggregate

demand shock.

3D: How will the AD/AS curves behave in this situation? Please elaborate your answer.

AD/AS curve shall move to the left due to lower demand and supply in short term.

The level of aggregate demand and aggregate supply in the economy and real GDP has decreased in

the economy.

Question 4

Question 4A: What type of macroeconomic policy should the Indian government adopt after such

a crisis? Please mention the policy measures to be undertaken clearly with explanations.

Monetary policy: The RBI should keep a low interest rate to increase cash in the market, the idea is to

create demand in market like automotive, real estate sectors etc. Due to this increase in the supply

chains in terms of manufacturing. increase circular flow of money to boost economic activity.

Expansionary Fiscal policy: Tax cut by the government, people will purchase more and increase in the

firms demands.

Spend on building infrastructure, gives money to businesses, more money flow in the economy and more

jobs more demand and more supply.

Question 4B: What type of macroeconomic policy should the Reserve Bank of India adopt after

such a crisis? Please mention the policy measures to be undertaken clearly with explanations.

RBI should cut in repo rate on loan and increase production of money print so money will flow in market

and demand of product will increase also supply will increase.

 Reducing interest rate. Consumer will further go for home loan, personal loan etc so increasing

the demands in terms of real state, automobile sectors.

 EMI moratorium- Three-month moratorium on loan repayment is likely to help borrowers tide

over any current financial hardship.

 selling government securities in the open market.

 Increase in investment expenditure will increase the level of aggregate demand in the economy

shifting the AD curve rightwards

Saturday 19 March 2022

Dataguard - 12c Physical standby database failover steps example

Oracle Database server Details:

 

Server Details

DB Details

Host Name

IP Address

DB Version

Instance Name

Mode

 

 

Oracle 12c


Stand By

 

Oracle 12c


Primary

  

Introduction

Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases. Oracle Data Guard maintains one or many secondary databases as alternatives to the primary production database.

Data Guard Architecture









Oracle Data Guard supports both physical standby and logical standby sites.

Physical Standby: When the primary database transactions generate redo entries, a redo apply process keeps up the secondary databases with the exact block copies of the primary database.

Logical Standby: SQL apply processes read the redo and convert it to SQL transactions. These are then applied to the secondary database.

Data Guard Modes

Oracle Data Guard can operate in 3 different modes:

Maximum Protection: Transactions are not allowed to commit until all redo data are written to the online redo logs and propagated to at least one synchronized secondary database. If for any reason, the primary database cannot propagate its redo stream to one secondary database, the primary will shutdown to ensure maximum protection mode.

Maximum Performance: Transactions are not allowed to commit as soon as the redo are written to the online redo logs. The redo stream is asynchronously propagated to the secondary databases to ensure maximum performance mode.

Maximum Availability: Transactions are not allowed to commit until all redo data are written to the online redo logs and propagated to at least one synchronized secondary database. If for any reason, the primary database cannot propagate its redo stream to one secondary database, the primary will NOT shutdown and operates as it it were in maximum performance mode until issues are fixed.

Glossary

Role transition: Changing the role of each database component from primary database to the secondary database or from secondary database to the primary database.

Switchover: Planned role transition for testing. Manual intervention.

Fail Over: Unplanned failure. Manual or Automatic intervention. Automatic role transition is the recommended.

Primary database: Where the users are connected to access to the database.

Standby database: Exists in the the disaster recovery (DR) site. Where the users are connected in the case of planned role transition (Switchover) or in the case of unplanned failure (Fail Over).

Failover Operation Steps

A failover operation is a true disaster recovery operation. A failover operation should only be considered when all of the alternative options for primary database recovery are not feasible. A failover is a unplanned event when something has happened to hardware, networking, etc.

Below are the steps for opening standby database when the primary database is lost:

Considering Primary and standby database is in sync with each other.

In order to initiate the failover operation, the target physical Oracle instance should be placed in MAXIMUM PERFORMANCE data protection mode using the following statement:

ALTER DATABASE SET Oracle instance TO MAXIMIZE PERFORMANCE.

As in SMRPRODB database already in maximum performance mode by default so ALTER command not required.

 

1 .  Check the status of archived logs in existing standby database server. Verify a Standby Redo Log is in use for Primary current Online Redo Log.

SQL > SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD#;

 





 

2. Using query Check database status as database name, INSTANCE NAME, OPEN MODE, DATABASE ROLE, DB UNIQUE NAME

select name, instance_name, open_mode, database_role, flashback_on , current_scn,to_char(standby_became_primary_scn) failover_scn from v$database,v$instance;





 

3. Verify a Standby Redo Log is in use for Primary current Online Redo Log.  Stoping the MRP Process on standby database server.

Alter database recover managed standby database cancel;

 



4. To get the Standby Redo Log Information is still required.


5 converting standby role to the primary role




6.
 Open database for read write mode


 

 

 



#########################################################################

NOTE : Since the standby database is now the primary database it should be backed up immediately.

 

 Bring  back old primary database in standby mode.

 

The Old Primary

The data center has now been fixed and the old primary is back online and you need to do this quick to make sure that you are protected again. If you are not using failback database then you have to delete the original database and re-create it using the RMAN Backup procedure

.If you have enabled flashback database then we can easily bring back the primary

 

## Since redo is applied by SCN we need he failover SCN from the new primary

select to_char(standby_became_primary_scn) failover_scn from v$database;

FAILOVER_SCN
-----------------------------------------------
7658841

## Now flashback the old primary to this SCN and start in mount mode


startup mount;


flashback database to scn 7658841;


alter database convert to physical standby;


shutdown immediate;


startup mount;

## hopefully the old primary will start to resolve any gap issues at the next log switch, which means we can start the MRP
## process to get this standby going to catchup as fast as possible

alter database recover managed standby database using current logfile disconnect;

## eventually the missing redos will be sent to the standby and applied, bring us back to synchronization again.

 

 

 

 

#####################################################################

Recreate Old Primary Database Using existing Rman backup.

RMAN Backup script

run

{

allocate channel c1 device type disk format '/u04/MasterDB/rmanbkp_SMRPRODB/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c2 device type disk format '/u04/MasterDB/rmanbkp_SMRPRODB/Backup_%d_DB_%u_%s_%p_%T';

backup full database format '/u04/MasterDB/rmanbkp_SMRPRODB/%d_%U.bckp' plus archivelog;

copy current controlfile to '/u04/MasterDB/rmanbkp_SMRPRODB/control01.bak';

backup current controlfile for standby format '/u04/MasterDB/rmanbkp_SMRPRODB/standbycontrol_%d_%T_%U.ctl';

release channel c1;

release channel c2;

}

 

 


Monday 14 February 2022

RAC - Cluster Synchronisation service CSS misscount and disktimeout

 


Cluster Synchronisation service  CSS misscount  and disktimeout  (get and set  details )

  • Default CSS misscount set 

 RAC - crsctl get css misscount

srv1:~ # crsctl get css misscount

CRS-4678: Successful get misscount 30 for Cluster Synchronization Services.

srv1:~ # crsctl set css misscount 90

CRS-4684: Successful set of parameter misscount to 90 for Cluster Synchronization Services.

Alert log : 

2022-01-21 13:15:03.560 [OCSSD(3265)]CRS-1626: A Configuration change request completed successfully

2022-01-21 13:15:03.565 [OCSSD(3265)]CRS-1601: CSSD Reconfiguration complete. Active nodes are srv1 srv2 .

srv1:~ # crsctl get css misscount

CRS-4678: Successful get misscount 90 for Cluster Synchronization Services.

  • Default CSS disktimeout set 

srv1:~ # crsctl get css disktimeout

CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services.


  • Unset to default value

crsctl unset css misscount — — sets CSS parameter to its default

srv1:~ # crsctl status resource -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

               ONLINE  ONLINE       srv1                     STABLE

               ONLINE  ONLINE       srv2                     STABLE

ora.DATA.dg

               ONLINE  ONLINE       srv1                     STABLE

               ONLINE  ONLINE       srv2                     STABLE

ora.FRA.dg

               ONLINE  ONLINE       srv1                     STABLE

               ONLINE  ONLINE       srv2                     STABLE

ora.LISTENER.lsnr

               ONLINE  ONLINE       srv1                     STABLE

               ONLINE  ONLINE       srv2                     STABLE

ora.asm

               ONLINE  ONLINE       srv1                     Started,STABLE

               ONLINE  ONLINE       srv2                     Started,STABLE

ora.net1.network

               ONLINE  ONLINE       srv1                     STABLE

               ONLINE  ONLINE       srv2                     STABLE

ora.ons

               ONLINE  ONLINE       srv1                     STABLE

               ONLINE  ONLINE       srv2                     STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       srv1                     STABLE

ora.LISTENER_SCAN2.lsnr

      1        ONLINE  ONLINE       srv2                     STABLE

ora.LISTENER_SCAN3.lsnr

      1        ONLINE  ONLINE       srv2                     STABLE

ora.MGMTLSNR

      1        ONLINE  ONLINE       srv1                     169.254.105.33 192.1

                                                             68.10.1,STABLE

ora.cvu

      1        ONLINE  ONLINE       srv2                     STABLE

ora.mgmtdb

      1        ONLINE  ONLINE       srv1                     Open,STABLE

ora.oc4j

      1        ONLINE  ONLINE       srv2                     STABLE

ora.rac.db

      1        ONLINE  ONLINE       srv1                     Open,STABLE

      2        ONLINE  ONLINE       srv2                     Open,STABLE

ora.rac.pretaf.svc

      1        ONLINE  ONLINE       srv1                     STABLE

ora.rac.pretaf_preconnect.svc

      1        ONLINE  ONLINE       srv2                     STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       srv1                     STABLE

ora.scan2.vip

      1        ONLINE  ONLINE       srv2                     STABLE

ora.scan3.vip

      1        ONLINE  ONLINE       srv2                     STABLE

ora.srv1.vip

      1        ONLINE  ONLINE       srv1                     STABLE

ora.srv2.vip

      1        ONLINE  ONLINE       srv2                     STABLE

--------------------------------------------------------------------------------