Step 1 – export
Step 2 – import data
Step 3 – import everything else
1.Assuming a full export, use direct=y if you’re not using any predicates in the export.
Set your buffer to be big (10MB at least)
2.Alter all your constraints novalidate prior to export if you can bring the app down, and if you can take a consistent export. This helps in reinstating the constraints instantly without forcing Oracle to validate constraints on massive tables
3. set workarea_size_policy=manual
4. Set sort_area_size=6GB (yes, 6 GB). Combined with 4, it let Oracle build indexes with more space in memory for all the sorts without the need to spill to disk.
5. Set massive online redo logs at 2GB each, 2 members each, 6 groups. After the import, reset everything back down to “normal”.
Read more…
Loss of Voting Disk
Check where voting disks are located using “crsctl check crs”
Read more…
From the OS command prompt, type asmcmd, which brings up the ASM command-line prompt:
Read more…
Configure the service on RAC servers for a failover
Read more…
Check out current configuration information
In Oracle 10.2, Oracle Clusterware log files are created in the $ORA_CRS_HOME/log directory.
Read more…
I could get ASM commandline to discover ASM disks at both RAC nodes. It can map VOL1, VOL2 at both nodes but Oracle RAC database installer won’t see ASM disks.
Read more…
Oracle Clusterware installed OK. ASM1 instance works OK while ASM2 would return ORA-15186/ORA-15063
Read more…
This support guide is a supplement to the OCFS2 User’s Guide and the OCFS2 FAQ. The information provided is directed towards support. End users should consult theUsers’ Guide and/or FAQ for information on setting up and using OCFS2.
Read more…
Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.
Read more…
Retrieve Stats for a Day from Statspack tables
select to_char ( trunc ( b.snap_time )
, 'DD-MM-YYYY' )
, statistic#
, name
, sum ( value )
from STATS$SYSSTAT A
, stats$snapshot B
where a.snap_id = b.snap_id
and trunc ( b.snap_time ) > trunc ( sysdate - 30 )
and a.statistic# = 54 < Replace
with Stats
Number Below > group
by trunc ( b.snap_time )
, statistic#
, name
order by trunc ( b.snap_time );
Read more…
1. Look at table PERFSTST.STATS$SNAPSHOT
2. Run spreport.sql and you will notice it along with the snapids listed
Read more…
This process will reverse database roles in a Data Guard setup, i.e. standby database becomes primary.
Read more…
Solution: I tried looking into statspack report but it wouldn’t flag the insert/update/delete activity. Also statspack won’t record some of system activity which may contribute to redo logs.Only option to use was “LOGMINER”.
Read more…
I have a SAP system with optimizer_index_cost_adj set to 10. Let’s look at Oracle execution plans and the resulting execution costs.
Read more…