Dear Readers, In this article, we will see the following Difference b/w Common user and Local user in Oracle 12c. Oracle has Introduced Multitenant architecture in the version 12c and also new terminologies for users in container database called LOCAL USER and COMMON USER. Common… Read More
How to perform DATAPUMP operations on standby database by converting SNAPSHOT standby. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of 12cR1 Converting physical standby into snapshot standby and… Read More
Hello Readers I Standardized and customized the SecureCRT to group and link the frequently used commands. It will make the Oracle DBA job easy and fast. Download SecureCRT Software binaries using below link. https://www.vandyke.com/cgi-bin/account_login.php?pid=scrt_x64_870 Or Download SecureCRT binaries from Google Drive https://drive.google.com/file/d/1jfGtmKKwPwmOcjO1t5BJoN_b77V09a_q/view?usp=sharing Let me know… Read More
What are the Oracle 12c Pluggable databases? How does a pluggable database work? These are the databases that are stored within the CDB. A PDB is a portable collection of schemas, schema objects, and non schema objects that appears to an Oracle Net client… Read More
How to build ACTIVE STANDBY DATABASE using RMAN DUPLICATE command in ORACLE DATABASE 12c. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of the 12cR1 active standby setup… Read More
Dear Readers, In this article, we will see the following Multi-tenant Architecture & Creating database manually in Oracle 12c. Containers in Multitenancy Oracle Database 12c introduced a new feature called “multitenant.” The multitenant feature provides the ability for a single instance to manage multiple databases.… 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
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 |
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
