1.PURPOSE AND SCOPE
With 11gR2 rman duplication its really easy to create standby database.
2.PRACTICE
Information Primary Database SID: PRIM Primary Database Domain/IP: ABSO Standby Database SID: PRIM_SBY Standby Database Domain/IP: CROO
Data Guard Broker installation, configuration, monitoring and deactiving
1.PURPOSE AND SCOPE
Oracle Data Guard broker software install with oracle database software and program bin file could find at $ORACLE_HOME/bin/dgmgrl location. Benefit of dgmgrl is most of the actions on primary/standby database can be done easyly through this tool, especilly switchover and managing primary/standby database.
2. IMPORTANT
When you are using the Broker to maintain your Data Guard configuration you must use either the Broker command line interface ‘DGMGRL’ or Grid Control to make any changes to your Data Guard configuration. If you desire to use SQL*Plus then you should remove the the Data Guard Broker configuration using the ‘REMOVE CONFIGURATION PRESERVE DESTINATIONS’ command in DGMGRL. Then you must set the DG_BROKER_START parameter to ‘FALSE’ on all database in the configuration.
Checking the status of disk usage on OS with the help of external table
1.PURPOSE AND SCOPE
At this artichle i am going to explain how to check disk capacity and usage while using external table option.
Ps: I just test it on HP-UX and Linux servers.
2.PRACTICE
2.1. First of all we need to play output of df command. Our purpose is to eliminate space and tab on out and we will change them to comma.And also at script we are not going to take first line of output and we need to eliminate % character.After we eliminate % character we can save this coloum as a number at table and create some alert metrics for ourself. On the below i am going to provide normal df -Pk output and new version of it to save our table as like i talked about it.And i am going to save this output to df.log for other steps. [Read more…]
Oracle 12c Database download
At last oracle 12c database and grid infrastructure(linux versions) ready to download.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
[oracle@12c ~]$ sql SQL*Plus: Release 12.1.0.1.0 Production on Wed Jun 26 23:05:30 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> |
11.2.0.3 Auto archivelog deletion bug
1.PURPOSE AND SCOPE
Solving the Oracle 11.2.0.3 version auto archivelog deletion problem
2.PRACTICE
2.1. At Oracle 11.2.0.3 version there is a bug related with deleting archivelogs. Normally when FRA is need a space ,it need to check archivelogs which can be deleted but because of the bug it doesn’t control which archivelogs can it be deleted ,you need to execute a dbms package to refresh the view. [Read more…]
User managed backup and restore
1.PURPOSE AND SCOPE
In this article, we are going to take user managed backup and try to restore it until spesific time.
2.PRACTICE
2.1. Lets start with backup side of user managed backup/restore.Before starting to copy tablespaces we need to changing the status of tablespaces.By the way you dont need to change the status of tablespaces like me by one by one, you can use “ALTER DATABASE BEGIN BACKUP;” command to take all of them backup mode.
|
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 |
[oracle@sb]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 18 10:21:38 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> select 'alter tablespace '||TABLESPACE_NAME||' begin backup;' from SYS.DBA_DATA_FILES; 'ALTERTABLESPACE'||TABLESPACE_NAME||'BEGINBACKUP;' ------------------------------------------------------------- alter tablespace USERS begin backup; alter tablespace UNDOTBS1 begin backup; alter tablespace SYSAUX begin backup; alter tablespace SYSTEM begin backup; alter tablespace EXAMPLE begin backup; alter tablespace MGMT_ECM_DEPOT_TS begin backup; alter tablespace MGMT_TABLESPACE begin backup; alter tablespace MGMT_AD4J_TS begin backup; 8 rows selected. SQL> alter tablespace USERS begin backup; Database altered. SQL> alter tablespace UNDOTBS1 begin backup; Database altered. SQL> alter tablespace SYSAUX begin backup; Database altered. SQL> alter tablespace SYSTEM begin backup; Database altered. SQL> alter tablespace EXAMPLE begin backup; Database altered. SQL> alter tablespace MGMT_ECM_DEPOT_TS begin backup; Database altered. SQL> alter tablespace MGMT_TABLESPACE begin backup; Database altered. SQL> alter tablespace MGMT_AD4J_TS begin backup; Database altered. |
Flashback database
1.PURPOSE AND SCOPE
It is posible to fix the logical errors, with using flashback database technology but for sure time period of this kind of operations depends of flashback time of database.While using flashback technology we can use time,log sequence or SCN.
P.S: Disk failure and deletion of datafile/redo/control file cant be restored with technology.
2.PRACTICE
2.1. We are going to connect to closed db and open flashback option.
UTL MAIL: Installation of package which helps to send email through database
1.PURPOSE AND SCOPE
We need to install utlmail and prvtmail scripts to send email through databases,with help of these script we are going to create some synonyms and packages. After installation of script we need to set smtp server parameter and grants.
2.PRACTICE
2.1. Going to connect database through sqlplus and starting utlmail.sql script.
2.1.1. Content of utlmail.sql
Installation of Logical Standby
1.PURPOSE AND SCOPE
At another article of mine ,I explained installation of Physical standby and this article we are going to convert physical standby database to logical standby.
2.PRACTICE
2.1. At primary database we need to execute a query to see which tables are not supported by logical standby
Add a new disk to asm diskgroup
1.PURPOSE AND SCOPE
In this article i am going to explation how to add new disk to the diskgroup which used by database.Before starting i wanted to give some informations about our steps. In this practice we had got a disk named DISK4 and this isnt belong to single diskgroup.First of all i am going to check the stability of DISK4, if disk success i am going to create a different diskgroup and try to add it there.If this step also succeed we are going to add this disk to diskgroup which used by production diskgroup.
2.PRACTICE
2.1. Time to control stability of DISK4 . (If you have got RAC env, you need to do this every single node)