Wednesday, September 28, 2011
Friday, April 8, 2011
how to recover lost datafile without backup of that datafile
article by Steve
http://www.databasejournal.com/features/oracle/article.php/3757371/Hands-on-Oracle-Backup-and-Recovery-Games---Creating-Datafiles.htm
sql>alter database create datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEMO\USERS02.DBF';
sql>recover datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEMO\USERS02.DBF';
http://arjudba.blogspot.com/2008/05/recover-lost-datafile-without-backup.html
http://www.orafaq.com/node/2402
http://boomslaang.wordpress.com/2008/10/14/recovery-of-non-system-datafile-without-backup/
http://gavinsoorma.com/oracle-goldengate-veridata-web/
http://www.databasejournal.com/features/oracle/article.php/3757371/Hands-on-Oracle-Backup-and-Recovery-Games---Creating-Datafiles.htm
sql>alter database create datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEMO\USERS02.DBF';
sql>recover datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEMO\USERS02.DBF';
http://arjudba.blogspot.com/2008/05/recover-lost-datafile-without-backup.html
http://www.orafaq.com/node/2402
http://boomslaang.wordpress.com/2008/10/14/recovery-of-non-system-datafile-without-backup/
http://gavinsoorma.com/oracle-goldengate-veridata-web/
Monday, April 4, 2011
oracle Table Fragmentation
http://oracle-online-help.blogspot.com/2007/02/identify-and-fix-table-fragmentation-in.html
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1295801859138
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1295801859138
Sunday, April 3, 2011
Thursday, March 31, 2011
About Bind Variable
http://umardba.blogspot.com/2009/11/bind-variables-key-to-application.html
Bind variable peeking:
http://www.dbspecialists.com/specialists/specialist2003-11.html
Statistics gathering..
http://download.oracle.com/docs/cd/B10500_01/server.920/a96533/stats.htm
Objects are considered stale when 10% of the total rows have been changed. When you issue GATHER_TABLE_STATS with GATHER STALE, the procedure checks the USER_TAB_MODIFICATIONS view. If a monitored table has been modified more than 10%, then statistics are gathered again. The information about changes of tables, as shown in the USER_TAB_MODIFICATIONS view, can be flushed from the SGA into the data dictionary with the DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO procedure.
Bind variable peeking:
http://www.dbspecialists.com/specialists/specialist2003-11.html
Statistics gathering..
http://download.oracle.com/docs/cd/B10500_01/server.920/a96533/stats.htm
Objects are considered stale when 10% of the total rows have been changed. When you issue GATHER_TABLE_STATS with GATHER STALE, the procedure checks the USER_TAB_MODIFICATIONS view. If a monitored table has been modified more than 10%, then statistics are gathered again. The information about changes of tables, as shown in the USER_TAB_MODIFICATIONS view, can be flushed from the SGA into the data dictionary with the DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO procedure.
Monday, March 28, 2011
OEM Grid Control..
nice presentation
http://oukc.oracle.com/static05/opn/oracle9i_database/40263/013107_40263/index.htm
http://www.oracle.com/technetwork/articles/havewala-gridcontrol-088685.html
Oracle Grid control componenets:
- Repository database
- OMS, oralce management service
- EM agent
OMS (This is a J2EE application deployed on Oracle Application Server 10g), components of OMS:
- Oracle HTTP Server
- Oracle Application Server Containers for Java (OC4J)
- OracleAS Web Cache.
Therefore, Grid Control is a reduced version of Oracle Application Server itself.
use Oracle Process Management Notification Control , OPMNCTL
or dcmctl (Distributed Configuration Management Control).
This is in addition to the Enterprise Manager Control (emctl) utility
/app/oracle/instancename/oms10g/opmn/bin > ./opmnctl status
Processes in Instance: EnterpriseManager0.hostname
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
HTTP_Server | HTTP_Server | 23058 | Alive
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | N/A | Down
OC4J | home | 23059 | Alive
OC4J | OC4J_EMPROV | 23060 | Alive
OC4J | OC4J_EM | 23061 | Alive
OC4J | OCMRepeater | 23064 | Alive
WebCache | WebCache | 23071 | Alive
WebCache | WebCacheAdmin | 23070 | Alive
DSA | DSA | N/A | Down
here OC4J_EM is only a single Unix process with its own PID
troubleshooting:
http://www.myoraclesupports.com/content/grid-control-target-maintenance-steps-diagnose-issues-related-agent-unreachable-status
http://www.myoraclesupports.com/content/how-troubleshoot-communication-between-oracle-management-service-oms-and-grid-agent-componen
Configuring the management agent:
•The emd.properties file in the sysman/ directory
This file contains the global variables for the Management Agent. For most installations, the following two parameters need to be modified:
◦REPOSITORY_URL=http://host:port/em/upload/
This is the location of the Oracle Management Service where you want the Management Agent to register.
◦EMD_URL=http://local_host:port/emd/main/
This is the location and port where you want the Management Agent to listen for communications from clients.
•The targets.xml file in the sysman/directory
This file contains the information about the local system and its database instances. It is in XML format and needs to be customized. Although the Management Agent attempts to configure this file, z/OS differences may not permit it to do so.
emctl start agent
emctl upload
emctl stop agent
Number of Files to Upload:
This metric shows the number of XML files that are in the $ORACLE_HOME/sysman/emd/upload directory waiting to be uploaded to the repository
http://oukc.oracle.com/static05/opn/oracle9i_database/40263/013107_40263/index.htm
http://www.oracle.com/technetwork/articles/havewala-gridcontrol-088685.html
Oracle Grid control componenets:
- Repository database
- OMS, oralce management service
- EM agent
OMS (This is a J2EE application deployed on Oracle Application Server 10g), components of OMS:
- Oracle HTTP Server
- Oracle Application Server Containers for Java (OC4J)
- OracleAS Web Cache.
Therefore, Grid Control is a reduced version of Oracle Application Server itself.
use Oracle Process Management Notification Control , OPMNCTL
or dcmctl (Distributed Configuration Management Control).
This is in addition to the Enterprise Manager Control (emctl) utility
/app/oracle/instancename/oms10g/opmn/bin > ./opmnctl status
Processes in Instance: EnterpriseManager0.hostname
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
HTTP_Server | HTTP_Server | 23058 | Alive
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | N/A | Down
OC4J | home | 23059 | Alive
OC4J | OC4J_EMPROV | 23060 | Alive
OC4J | OC4J_EM | 23061 | Alive
OC4J | OCMRepeater | 23064 | Alive
WebCache | WebCache | 23071 | Alive
WebCache | WebCacheAdmin | 23070 | Alive
DSA | DSA | N/A | Down
here OC4J_EM is only a single Unix process with its own PID
troubleshooting:
http://www.myoraclesupports.com/content/grid-control-target-maintenance-steps-diagnose-issues-related-agent-unreachable-status
http://www.myoraclesupports.com/content/how-troubleshoot-communication-between-oracle-management-service-oms-and-grid-agent-componen
Configuring the management agent:
•The emd.properties file in the sysman/ directory
This file contains the global variables for the Management Agent. For most installations, the following two parameters need to be modified:
◦REPOSITORY_URL=http://host:port/em/upload/
This is the location of the Oracle Management Service where you want the Management Agent to register.
◦EMD_URL=http://local_host:port/emd/main/
This is the location and port where you want the Management Agent to listen for communications from clients.
•The targets.xml file in the sysman/directory
This file contains the information about the local system and its database instances. It is in XML format and needs to be customized. Although the Management Agent attempts to configure this file, z/OS differences may not permit it to do so.
emctl start agent
emctl upload
emctl stop agent
Number of Files to Upload:
This metric shows the number of XML files that are in the $ORACLE_HOME/sysman/emd/upload directory waiting to be uploaded to the repository
Friday, March 25, 2011
CHECKPOINT TUNING AND ERROR HANDLING
https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=147468.1
Subscribe to:
Posts (Atom)