Monthly Archives: September 2012

Creating Physical Standby Using RMAN DUPLICATE FROM ACTIVE DATABASE

 Creating Physical Standby Using RMAN DUPLICATE FROM ACTIVE DATABASE Steps are below how to create a physical standby database using RMAN DUPLICATE  FROM ACTIVE DATABASE command without shutting down the primary and using primary active database files (No need to … Continue reading

Posted in Oracle DataGaurd | Leave a comment

How to format and mount ocfs2 file system for Oracle RAC

How to format and mount ocfs2 file system for Oracle RAC Database   We have one RAC server runing out of space for database and now I have got one new LUN /dev/sdk from storage, I have created partition of … Continue reading

Posted in Linux commands for DBA | Leave a comment

How to Backup and Restore Statistics

Backup Optimizer Statistics Step Checklist: 1. Create a statistics table in the  User schema 2. Transfer the statistics to this table Step detail: ———— 1. Create a statistics table in the user schema : User is the owner of the … Continue reading

Posted in statistics | Leave a comment

How to check automatic statistics collection is scheduled on 10g

With Oracle 10g, the gathering of statistics has become automated. The GATHER_STATS_JOB that is built in the database creation process schedules automatic statistics collection. The job initiates a ‘program’ of statistics gathering appropriate for the database in question. The job … Continue reading

Posted in statistics, Uncategorized | Leave a comment

Restoring Table Statistics

How long does Oracle retain the statistics for ? The default period for which statistics are retained is 31 days but this can be altered with:- execute DBMS_STATS.ALTER_STATS_HISTORY_RETENTION (xx) – where xx is the number of days to retain them … Continue reading

Posted in Performance and Tuning | Leave a comment

How to Apply Opatch on Oracle RAC

How to Apply Opatch on Oracle RAC server 1: Check Oracle service status [oracle@rac-node1 ~]$crs_stat -t Name Type Target State Host ———————————————————— ora….SM1.asm application ONLINE ONLINE dbsr…ode1 ora….E1.lsnr application ONLINE ONLINE dbsr…ode1 ora….de1.gsd application ONLINE ONLINE dbsr…ode1 ora….de1.ons application ONLINE … Continue reading

Posted in Oracle RAC | Leave a comment

How to stop and start Oracle RAC services on two nodes RAC

How to stop and start Oracle RAC services on two nodes RAC To see status [oracle@rac-node1 ~]$crs_stat -t Name Type Target State Host ———————————————————— ora….SM1.asm application ONLINE ONLINE dbsr…ode1 ora….E1.lsnr application ONLINE ONLINE dbsr…ode1 ora….de1.gsd application ONLINE ONLINE dbsr…ode1 ora….de1.ons … Continue reading

Posted in Oracle RAC | Leave a comment