Category Archives for Database
Steps / How to Migrate Non ASM Instance Database to ASM Instance
NOTE: Always Do Exercise on Test Environment, First. Assumptions : 1. ASM Instance is already Created and Ready to Use. 2. DB Instance was Started using ‘spfile’ 3. Disk Group Name : ‘+DGDATA’ – Set the Parameter ‘db_create_file_dest’ to ‘+DGDATA’ alter system set db_create_file_dest=’+DGDATA’ scope=spfile; – Set the Parameter ‘control_file’ to the destination in ASM […]
Read MoreError: ORA-00354 – (Oracle Hidden Parameter : _allow_resetlogs_corruption)
NOTE: This is One of the Hidden Oracle Parameters. DO NOT use it until and unless instructed by Oracle Support. You are trying to start your DATABASE, you found the aforementioned error i.e. ORA-00354. . Required Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but […]
Read MoreAWR (Advance workload Repository)Report in Oracle 10G
AWR is an enhancement/upgradation of statspack, which help us to tune the database. Oracle Database 10g uses a scheduled job, GATHER_STATS_JOB, to collect AWR statistics. This job is created, and enabled automatically when you create a new Oracle database under Oracle Database 10g. GATHER_STATS_JOB, to collect AWR statistics every 1 hour . We can disable […]
Read MoreRecover an accidentally deleted file when the database is still open.
On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use its file handle, and the file can also be accessible under /proc/<pid>/fd . In the following example, we use […]
Read MoreRAC Storage
Storage Options for RAC CFS (Cluster File System) – Easy to manage but only available on some platforms. Does not address striping and mirroring. RAW – Available on all platforms but difficult to manage. Does not address striping and mirroring. NFS – Easy to manage but only available on some platforms. Does not address striping […]
Read MoreOracle Database Recovery Scenario and Solution
The purpose of this article is to get acquianted with some of the recovery scenarios , this topic is useful for the folks who is having less experience and looking for good DBA exposure and preparing for interview . I am trying to jotting down both RMAN and normal database technique :- 1.Complete Closed […]
Read MoreHow can i see, Critical Patch Update is installed on the database,
Note that the methods in this note will allow you to check upon an Oracle installation, it is still recommended for a DBA to properly document all applied patches to the software installation. The output of ‘opatch lsinventory’ will give you a list of bug numbers, but it can be awkward to cross reference them […]
Read MoreEmbedding SQL in Shell
Embedding a SQL inside Shell Script:- Here is a tip on how to run sqlplus scripts within a shell script. This is an example of how to pass database values into shell variables, and to make shell scripts more dynamic. This will help DBA to automate certain DBA tasks, also to setup some automation using […]
Read MoreValidating and rebuilding large and fragmented indexes in 11i
You can have various methods to identify the large or fragmented indexes in 11i or you can just configure the Oracle Alert to receive a mail. This alert is scheduled to check the situation periodically say daily at mid night. The alert ‘Indexes too large or fragmented‘ is pre-defined alert. There are three possible ways […]
Read MoreUpgrade overview for Oracle Database to 11g Release 1 (11.1)
Steps mentioned in this post is overview of Oracle database upgrade from 8i, 9i or 10g to 11g Rel 1 i.e. 11.1.X.X.X (Step by step Oracle 10g upgrade to 11g including pointer to documentation coming soon…) Things good to know for 11g Database Upgrade 1. Oracle 11g Database software must be installed in new ORACLE_HOME 2. If you […]
Read More