Thursday, April 4, 2019

How to activate a standby database so that we end up with 2 primary databases

When planning a migration an important step is to test that all applications can access the new hosts and ideally do some performance tests on the new hardware.

We can clone the DB with RMAN and replicate the redo logs with dataguard.

Then using the following commands we can break the replication and activate the standby without turning the existing primary DB into a standby: If it's a RAC, shutdown all the nodes except one.

SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>  ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;
SQL>  SHUTDOWN IMMEDIATE;
SQL>  STARTUP;

Wednesday, April 3, 2019

How to find an exadata rack serial# from command line

Connect to one of your compute node and type the following as root:
[root@mycomputernode1 ~]# ipmitool sunoem cli "show /SP system_identifier"
Connected. Use ^D to exit.
-> show /SP system_identifier

 /SP
    Properties:
        system_identifier = Exadata Database Machine X6-2 AK19191919

To find the rack size go to /opt/oracle.SupportTools/onecommand/databasemachine.xml | grep MACHINETYPES
-> Session closed