The dataguard status subcommand of the dbaascli utility is used to check the status of the Oracle Data Guard configuration. Execute this command as the oracle user. dbaascli dataguard status [–details yes|no]
All posts by Skant Gupta
Long Identifiers In Oracle 12.2
SQL*Plus now supports object lengths of 128 bytes. In previous releases, the object length limit was 30 bytes and if you try to create object with length more than 30, it will throw error as ORA-00972: identifier is too long. Oracle 12.2 increases the maximum size of most identifiers from 30 to 128 bytes, which […]
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 […]
Size of Oracle Database
select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) + ( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) + ( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) “Size in GB” from dual;
Display the columns related to redaction in Oracle 12c
SELECT object_owner, object_name, column_name, function_type, function_parameters, regexp_pattern, regexp_replace_string, regexp_position, regexp_occurrence, regexp_match_parameter, column_description FROM redaction_columns WHERE object_owner = DECODE(UPPER(‘&1’), ‘ALL’, object_owner, UPPER(‘&1’)) AND object_name = DECODE(UPPER(‘&2’), ‘ALL’, object_name, UPPER(‘&2’)) ORDER BY 1, 2, 3;
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);
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. dbaascli database stop
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. dbaascli database status
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. dbaascli database start
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: ssh-keygen -t rsa -N “” -b “2048” -C “key comment” -f path/root_name Alternatively, […]