When to Use MongoDB Is MongoDB right for your application? That depends on the kind of data you have, and what you want to do with that data. NoSQL databases have risen to the occasion when it comes to unstructured data and the kind… Read More
1. Backup the current Stats For Database stats: SQL> Exec dbms_stats.export_database_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_database_03282018’); For System stats: SQL> Exec dbms_stats.export_SYSTEM_stats(statown => ‘SYSTEM’, stattab => ‘prod_stat_system_03282018’); For Dictionary stats: SQL> Exec dbms_stats.export_Dictionary_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_dictionary_03282018’); For Fixed Tables stats: SQL> Exec dbms_stats.export_FIXED_OBJECTS_stats(statown… Read More
Rename Disk Label for reallocating disks from one diskgroup to other diskgroup Before : login as sysasm :
|
1 2 3 4 5 6 7 8 9 |
NAME ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB PCT_FREE ------------------------------ -------------------- ----------- ------ ---------- ---------- ---------- FRA01 1048576 CONNECTED EXTERN 1024000 517938 50.5798828 DATA01 1048576 CONNECTED EXTERN 17408000 11416800 65.5836397 SQL> alter diskgroup DATA01 drop disk PROD_TEST_DATA01_79,PROD_TEST_DATA01_80,PROD_TEST_DATA01_81,PROD_TEST_DATA01_82,PROD_TEST_DATA01_83,PROD_TEST_DATA01_84,PROD_TEST_DATA01_85 REBALANCE POWER 11; Diskgroup altered. |
Wait till rebalnce completes.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_79 PROD_TEST_FRA01_06 Renaming disk "PROD_TEST_DATA01_79" to "PROD_TEST_FRA01_06": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_80 PROD_TEST_FRA01_07 Renaming disk "PROD_TEST_DATA01_80" to "PROD_TEST_FRA01_07": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_81 PROD_TEST_FRA01_08 Renaming disk "PROD_TEST_DATA01_81" to "PROD_TEST_FRA01_08": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_82 PROD_TEST_FRA01_09 Renaming disk "PROD_TEST_DATA01_82" to "PROD_TEST_FRA01_09": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_83 PROD_TEST_FRA01_10 Renaming disk "PROD_TEST_DATA01_83" to "PROD_TEST_FRA01_10": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_84 PROD_TEST_FRA01_11 Renaming disk "PROD_TEST_DATA01_84" to "PROD_TEST_FRA01_11": [ OK ] [root@SERVER11 ~]# /etc/init.d/oracleasm force-renamedisk PROD_TEST_DATA01_85 PROD_TEST_FRA01_12 Renaming disk "PROD_TEST_DATA01_85" to "PROD_TEST_FRA01_12": [ OK ] |
Please perform “ asm scan” command on other nodes which exists in the cluster : … Read More
Dear Readers, In this article we will see Rise of NoSQL databases. Over the last few years we have seen the rise of a new type of databases, known as NoSQL databases that are challenging the dominance of relational databases. Relational databases have dominated the software industry for a… Read More
Oracle : Generate Clear output for crs_stat -t
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
cat crsstat.sh #!/bin/bash RSC_KEY=$1 QSTAT=-u AWK=/bin/awk # if not available use /usr/bin/awk # Table header:echo "" $AWK \ 'BEGIN {printf "%-55s %-10s %-18s\n", "HA Resource", "Target", "State"; printf "%-55s %-10s %-18s\n", "-----------", "------", "-----";}' # Table body: ORA_CRS_HOME=/u01/app/grid/product/12102 $ORA_CRS_HOME/bin/crs_stat $QSTAT | $AWK \ 'BEGIN { FS="="; state = 0; } $1~/NAME/ && $2~/'$RSC_KEY'/ {appname = $2; state=1}; state == 0 {next;} $1~/TARGET/ && state == 1 {apptarget = $2; state=2;} $1~/STATE/ && state == 2 {appstate = $2; state=3;} state == 3 {printf "%-55s %-10s %-18s\n", appname, apptarget, appstate; state=0;}' |
chmod 755 crsstat.sh Output :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
./crsstat.sh HA Resource Target State ----------- ------ ----- ora.CRS01.dg ONLINE ONLINE on server11 ora.DATA01.dg ONLINE ONLINE on server11 ora.FRA01.dg ONLINE ONLINE on server11 ora.LISTENER.lsnr ONLINE ONLINE on server11 ora.LISTENER_SCAN1.lsnr ONLINE ONLINE on server12 ora.LISTENER_SCAN2.lsnr ONLINE ONLINE on server11 ora.LISTENER_SCAN3.lsnr ONLINE ONLINE on server11 ora.MGMTLSNR ONLINE ONLINE on server11 ora.REDO01.dg ONLINE ONLINE on server11 ora.REDO02.dg ONLINE ONLINE on server11 ora.asm ONLINE ONLINE on server11 ora.cvu ONLINE ONLINE on server11 ora.mgmtdb ONLINE ONLINE on server11 ora.net1.network ONLINE ONLINE on server11 ora.oc4j ONLINE ONLINE on server11 ora.ons ONLINE ONLINE on server11 ora.orcl2.vin_svc_node1.svc ONLINE ONLINE on server11 ora.orcl2.vin_svc_node2.svc ONLINE ONLINE on server11 ora.scan1.vip ONLINE ONLINE on server12 ora.scan2.vip ONLINE ONLINE on server11 ora.scan3.vip ONLINE ONLINE on server11 ora.server11.ASM1.asm ONLINE ONLINE on server11 ora.server11.LISTENER_server11.lsnr ONLINE ONLINE on server11 ora.server11.ons ONLINE ONLINE on server11 ora.server11.vip ONLINE ONLINE on server11 ora.server12.ASM2.asm ONLINE ONLINE on server12 ora.server12.LISTENER_server12.lsnr ONLINE ONLINE on server12 ora.server12.ons ONLINE ONLINE on server12 ora.server12.vip ONLINE ONLINE on server12 |
Which one to choose RDS v/s MySQL on EC2 A lot of clients for whom we manage AWS come up with a simple question of which out of “RDS vs EC2” is better for their MySQL database requirements. The answer to this simple question is… Read More
Continuation to the Part 3 ORACLE – Physical Standby Database creation – Part 3 Configure the listener and tnsnames to support the database on both nodes Configure listener.ora on both servers to hold entries for both databases ON TEST1 (Primary Database… Read More
Continuation of Part 2 ORACLE – Creating a Data Guard Physical Standby environment – Part2 Standby Database Steps Create a Control File from Primary database for the Standby Database. The standby database will use a control file that is generated on… Read More
STORAGE MANAGEMENT In oracle, database space demanding objects are called segments. There are 5 different segments i.e. tables, indexes, temporary, undo, rollback segments. Within a single server, we can create multiple database. Database contains one or more tablespace. One tablespace can… Read More
Continuation to the Data Guard Physical standby creation ORACLE – Creating a Data Guard Physical Standby environment – PART1 Enable Archiving On 10g you can enable archive log mode by mounting the database and executing the archivelog command:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SQL> startup mount; ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 75499088 bytes Database Buffers 205520896 bytes Redo Buffers 2973696 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Archive Mode Database log mode Automatic archival Enabled Archive destination /test/PRIMARYDB/archdest/arch Oldest online log sequence 92 Next log sequence to archive 94 Current log sequence 94 |
Set… Read More
