Posted by Mir Sayeed Hassan on February 8th, 2021
How to backup of the ASM HEADER in Oracle ASM Database.
Posted in ASM | Comments Off on How to backup of the ASM HEADER in Oracle ASM Database.
Posted by Mir Sayeed Hassan on February 3rd, 2021
SQL> select version,instance_name,open_mode from V$database,v$instance; VERSION INSTANCE_NAME OPEN_MODE ------- ---------------- -------------------- 11.2.0.4.0 teststd MOUNTED
Posted in DBA Administration | Comments Off on Move the datafile in standby database from one disk to another in Oracle 11gR2(11.2.0.4)
Posted by Mir Sayeed Hassan on February 3rd, 2021
[root@testdb ~]# echo "- - -" > /sys/class/scsi_host/host0/scan
[root@testdb ~]# fdisk -l Disk /dev/sdf: 322.1 GB, 322122547200 bytes 255 heads, 63 sectors/track, 39162 cylinders Units...Read more..
Posted in UNIX for DBA | Comments Off on How to extend/increase the size of a existing Linux LVM disk by adding a new disk
Posted by Mir Sayeed Hassan on December 23rd, 2020
ASMCMD> cd +FRA/RACDBN1/BACKUPSET/2020_12_16/
ASMCMD> ls nnndn0_FRIDAY_LEVEL_0_0.333.1059285491
ASMCMD>...Read more..
Posted in ORA-Error | Comments Off on ORA-15046: ASM file name is not in single-file creation form
Posted by Mir Sayeed Hassan on October 24th, 2020
SQL> select instance_name,version,status,open_mode from V$instance, v$database;
INSTANCE_NAME VERSION STATUS OPEN_MODE
—————- —————–...
Posted in ORA-Error | Comments Off on ORA-16826: apply service state is inconsistent with the DelayMins property on Oracle Database 11gr2(11.2.0.4)
Posted by Mir Sayeed Hassan on October 20th, 2020
A Profile is a database object & it’s named set of resource limits to such as restrict database usage by a system user.
Examples of resources that need to be managed are Disk storage space, I/O bandwidth to run queries, CPU power, CPU time...
Posted in Oracle SQL | Comments Off on Overview of Profile Management with real-time scenario in Oracle Database 11gR2 (11.2.0.4)