Posted by Mir Sayeed Hassan on May 6th, 2020
How to add a new LVM disk into existing Oracle Linux Server
LVM (Logical Volume Management) – It provides a flexible and high-level approach to managing disk space into the Linux Server.
Volume Group (VG) – It consists of the raw disk which holds one or more logical volumes & ...
Read more..
Posted in UNIX for DBA | Comments Off on How to Add a New LVM disk into existing Oracle Linux Server
Posted by Mir Sayeed Hassan on April 25th, 2020
How to add the ASM DISK into Existing disks in RAC DB Server
In the below scenario, we are going to add the new asm disk into the existing disk in RAC DB Server
First Scan the newly added disk into the server
[root@rac1-testdb~]# echo "- - -"> /sys/class/scsi_host/host0/scan
[root@rac1-testdb...
Read more..
Posted in RAC | Comments Off on How to add the ASM DISK into Existing disks in RAC Database on Oracle 11gR2
Posted by Mir Sayeed Hassan on April 17th, 2020
One of test database is set with flashback enabled as on, But there are some flashback files are deleted so we are not able to open the database in open mode & got the below ORA-38760 error.
ORA-38760: This database instance failed to turn on flashback database
Check the status of the database
SQL> select status from V$instance;
STATUS
-------
MOUNTED
Posted in ORA-Error | Comments Off on ORA-38760: This database instance failed to turn on flashback database
Posted by Mir Sayeed Hassan on February 25th, 2020
How to Multiplex Control file on RAC DB or ASM in Oracle 11gR2 (11.2.0.4.0)
In RAC Env, If you have newly configure & created the database as 2 node RAC by default there will be single controlfile will be created, But as per the Oracle recommend there should be atleast 2 controlfile to be created.
Please find the step by step procedure to add the...
Read more..
Posted in DBA Administration | Comments Off on How to Multiplex Control file on RAC DB or ASM in Oracle 11gR2 (11.2.0.4.0)
Posted by Mir Sayeed Hassan on January 26th, 2020
ORA-00054: resource busy and acquire with NOWAIT specified
Error occur while creating a table.
SQL> create table MIR.T_TRANSACTION(C_ID VARCHAR2(255 CHAR) not null primary key);
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-00054: resource busy and acquire with NOWAIT specified
9260 views Less than...
Read more..
Posted in ORA-Error | Comments Off on ORA-00054: resource busy and acquire with NOWAIT specified
Posted by Mir Sayeed Hassan on January 4th, 2020
How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0)
Flashback in Oracle Database
It’s a technology in Oracle database to perform restore the database to a particular point in past.
In case if you have lost the data like DML & want to retrieve, you can retrieve the rollback operation through flashback without using...
Read more..
Posted in Flashback | Comments Off on How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0)
