navaneethdba.blogspot.com
Navaneeth's Blog: January 2012
http://navaneethdba.blogspot.com/2012_01_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Monday, January 30, 2012. Restore archivelogs to a different location. In some scenarios we may need to restore the archivelogs to a different location from its primary location using RMAN from its backups. Below are the methods to do it. 1 The below scripts restores the archive logs to a temporary location which is given in the run script. 3 set archivelog destination to 'D: backup';. 4 restore archivelog from logseq=250 until logseq=264;. Channel ORA...
navaneethdba.blogspot.com
Navaneeth's Blog: May 2011
http://navaneethdba.blogspot.com/2011_05_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Monday, May 23, 2011. Rolling forward the standby database by using primary database incremental backups. The archive gap is noted in the standby database alertlog as below. The required archivelog for recovery is not found in the primary and is been deleted in both the primary and standby unfortunately. In this case the below is the recovery needed to synchronize the standby with primary. This incremental recovery only works from 10g onwards. Input da...
navaneethdba.blogspot.com
Navaneeth's Blog: March 2011
http://navaneethdba.blogspot.com/2011_03_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Monday, March 14, 2011. Procedure with AUTHID "Current user and Definer ". Check the below example and the comment. By default normally the procedure executes with AUTHID DEFINER privileges. CREATE OR REPLACE PROCEDURE NV.test insrt. AUTHID definer - executes the procedure with the privilges which the owner of the procedure has. AUTHID CURRENT USER - executes the procedure with currently logged in schema user privileges. WHEN NO DATA FOUND THEN. Check ...
navaneethdba.blogspot.com
Navaneeth's Blog: September 2011
http://navaneethdba.blogspot.com/2011_09_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Thursday, September 29, 2011. Information on Statistics collection on 11gR2. In 11gR2 statistics collection is automatic by default.The statistics will be collected by using an auto job, if the statistics found to be stale for an object or if any DDL command used against the object. Please see the below for the job details. Select client name,status,consumer group,attributes from DBA AUTOTASK CLIENT. CLIENT NAME STATUS CONSUMER GROUP. To check the perc...
navolnenoze.cz
Doporučení prezentace Michal Müller
http://navolnenoze.cz/prezentace/michal-muller/doporuceni
Na volné noze - portál nezávislých profesionálů. Doporučení z první ruky. Michal Müller tvůrce videovizitek, videí a krátkých filmů. Zobrazuji všech 8 doporučení. RNDr Helena Kurzweilová, CSc. Kouč osobního a profesního rozvoje. Bylo mi radostí s Michalem spolupracovat. Neměli jsme detailní představu o formě a obsahu videa. Proto oceňuji jeho flexibilní, rychlý a kreativní přístup při samotném natáčení a konečném střihu. Textař se zaměřením na psaní osobních příběhů a textů s duší. Věděl jsem přesně co c...
navaneethdba.blogspot.com
Navaneeth's Blog: June 2011
http://navaneethdba.blogspot.com/2011_06_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Thursday, June 2, 2011. Transport tablespace between platforms with same endian format using EXP/IMP. Transportable Tablespaces This can be used by only export/import. Please try to check the endian format before doing this TTablespace using exp/imp. The endian format should be same between the platforms , otherwise use RMAN convert as shown in the other post. 3 Target database must not have tablespace of the same name. 1 Make the tablespace readonly.
navaneethdba.blogspot.com
Navaneeth's Blog: June 2012
http://navaneethdba.blogspot.com/2012_06_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Wednesday, June 13, 2012. Oracle 9.2.0.6 to 11.2.0.2 upgrade steps. The below steps followed for upgrading a production database which is of size 400GB. 9206 oracle home = /usr/oracle/ora 9 2 0 5. Do the count on the PG022 server on 9.2.0.6 database before going for upgrade. Step 1: Shut down the existing database STRASPRD in old 9.2.0.6 home. Step 2: copy the datafile from old filesystem to new filesystem. Script copy DF strasprd.sh. Step 9: check the...
navaneethdba.blogspot.com
Navaneeth's Blog: February 2011
http://navaneethdba.blogspot.com/2011_02_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Wednesday, February 23, 2011. Please check the link for all kind of information on STATSPACK, its really helpfull. New Features in 11g on Backup and Recovery. Block change tracking in standby. Now incremental backups can be faster now in standby database by enabling the block change tracking in it. Archived Redo Log Failover. Archived Log Deletion Policy Enhancements. ARCHIVELOG DELETION POLICY {CLEAR TO {APPLIED ON [ALL] STANDBY. The following example...
navaneethdba.blogspot.com
Navaneeth's Blog: October 2011
http://navaneethdba.blogspot.com/2011_10_01_archive.html
Oracle DBA related workouts for 9i,10g,11g Versions. Monday, October 31, 2011. Transaction Slot on a Block. Transaction Slot on a Oracle Block :. Http:/ www.proligence.com/itl waits demystified.html. Tuesday, October 18, 2011. Using 10g Logminer on 9.2.0.7 archive files. In 9i production server. SQL execute DBMS LOGMNR D.build ('dictionary.ora','C: BCH VER2.0 EXPORT MONTHLY',OPTIONs = DBMS LOGMNR D.store in flat file);. PL/SQL procedure successfully completed. Select * from v$logmnr logs. Sblim-cmpi-samb...
SOCIAL ENGAGEMENT