spool CSV in Oracle 12.2

Now we can spool spool CSV or JSON from Oracle Database. Prior to 12.2 , we can spool as text or html, but from 12.2 onward, the SET MARKUP command now has a CSV option to output data in CSV format. Syntax CSV {ON|OFF} [DELIMI[TER] character] [QUOTE {ON|OFF}] Traditionally you wiill get formatted output (without […]

Read More

Size of Oracle Database

Read More

Display the columns related to redaction in Oracle 12c

Read More

Number of archived redo by day

SELECT TRUNC(first_time) AS day, ROUND(SUM(blocks * block_size)/1024/1024/1024,2) size_gb FROM v$archived_log WHERE TRUNC(first_time) >= TRUNC(SYSDATE) – &1 GROUP BY TRUNC(first_time) ORDER BY TRUNC(first_time);

Read More

dbaascli database stop

The database stop subcommand of the dbaascli utility can be used to shut down the database. Execute this command as the oracle user.

Read More

dbaascli database status

The database status subcommand of the dbaascli utility can be used to check the status of the database in your database deployment. Execute this command as the oracle user.

Read More

dbaascli database start

The database start subcommand of the dbaascli utility can be used to start the database instance and open the database. Execute this command as the oracle user.

Read More

Creating an SSH Key Pair on the Command Line

UNIX and UNIX-like platforms (including Solaris and Linux) include the ssh-keygen utility to generate SSH key pairs. To create an SSH key pair on the command line using ssh-keygen: Open a shell for entering the commands. At the prompt, enter the following:

Alternatively, you can simply enter ssh-keygen and then enter responses when prompted […]

Read More

Oracle Database 12cR2 (12.2) On-Prem

Finally Oracle Database 12cR2 (12.2) On-Prem is available. Previously it was available only on cloud services. You can download it from eDelivery or OTN. Good Thing is that , now only zip file for Database Home as well as Grid Home. Prior to 12.2, There are 2 zip files for each of them. We can […]

Read More

Restore and Backup the current OLR

Backup current OLR and all available OLR backups

Verify available backups

Verify available backups from OS

Restore  OLR from Current Backup. Shutdown CRS and check that ohasd.bin process is not running and restore OLR

Read More