Mir Sayeed Hassan – Oracle Blog

Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c

Login to Database.

[oracle@testdb ~]$ sqlplus sys/testdb as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 8 04:03:38 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition... 
Read more..			

How to drop all object from Schema in Oracle Database.

In this scenario., we are going to drop all the objects under the schema

Check the status of database.

[oracle@ora21cdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Wed Apr 26 16:43:19 2023
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected... 
Read more..			

The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4):  ORA-30032:

Issue: This issue was occur while doing a transaction in real-time database & it’s was hung for few seconds & get the error

SQL> select instance_name, version, status, open_mode from V$database, v$instance;

INSTANCE_NAME     VERSION... 
Read more..			

How to Suspend and Resume a Database stage in Oracle 19c DB

– To perform the suspend database you have to use the alter system suspend command at database level., In this stage the datbase is completely suspended and does not any operation on database and database in the state of suspend as shown below.,
– To perform the resume database you...
Read more..

Useful tips to find the Sysdate Commands from Oracle Database by issuing SQL Queries

Find the First Day of the Month

SQL> SELECT TRUNC (SYSDATE, 'MONTH') FROM DUAL;

TRUNC(SYS
---------
01-JAN-23

Find the Last Day of the Month

SQL> SELECT TRUNC (LAST_DAY (SYSDATE)) FROM DUAL;

TRUNC(LAS
---------
31-JAN-23

Find...
Read more..

How to create the trigger for failed & success login attempt in Oracle Database

Note: The below given trigger is created to attempt the success and failed login attempt of the all the user in Oracle database., Data will be recorded in the table as well as at the OS Level (directory loc).

Verify the audit config in DB

SQL> show parameter... 
Read more..