Oracle masala at work - 3:

Oracle masala at work - 3:

1. Restore and recovery made easy with RMAN Data Recovery Advisor in Oracle 11g:
2. Restart Data Pump job after an error:
3. NFS mount options on Linux(RHEL) for expdp and impdp:
4. Useful Underutilized some Oracle Utilities:


1. Restore and recovery made easy with RMAN Data Recovery Advisor in Oracle 11g:

rman target /

-- If there is an error, this command will come back with the files to recover.
list failure;

-- This command will show you the exact cause of the error. 169 is failure ID from the "list failure;" command.
list failure 169 detail;

-- It responds with a detailed explanation of the error and how to correct it.
advise failure;

-- It responds with a detailed fix preview.
repair failure preview;

-- This command will fix the failure.
repair failure;

-- The following RMAN command recovers all corrupted blocks.
recover corruption list;


2. Restart Data Pump job after an error:

-- In order to find the System assigned name for the EXPDP/IMPDP job you can run the following query.
SELECT * FROM DBA_DATAPUMP_JOBS;

-- Attach the job from the above SQL.
$ impdp system/manager attach=job_name

-- Restart the job.
Import> start_job

-- Check the status of the job.
Import> status


3. NFS mount options on Linux(RHEL) for expdp and impdp:

mount options:
atlt200:/oracle_scratch on /oracle_scratchnfs type nfs (rw,rsize=32768,wsize=32768,hard,nointr,bg,nfsvers=3,tcp,actimeo=0,timeo=600,addr=xx.xx.xxx.xx)

uname -a: Linux atlt200 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:46:26 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
Server: Dell 2950


4. Useful Underutilized some Oracle Utilities:

bbed (Block Browser and Editor, Password is "blockedit")
oradebug
nid (Rename DBID and Database Name)
adrci (11g)
trcsess (trcsess utility allows trace information from multiple trace files to be identified and consolidated into a single trace file from 10g)
trace Analyzer (trcanlzr.sql - Trace Analyzer utility is available via download on the Oracle Metalink web site)
trcasst (Analyxing Listener Trace file)
deinstall (11gR2 - Deinstall Failed GRID or Oracle home’s - File is under $ORACLE_HOME/deinstall directory)
csscan (Character Set Migration Utility - $ csscan \"sys/keepsaf3 as sysdba\" FULL=Y, to create character set migration utility schema, run @?/rdbms/admincsminst.sql)
wrap (hide the PL/SQL code)
cemutlo (cemutlo -n gives the cluster name)

renamedg (11gR2 ASM - Rename the ASM diskgroup)
kfed (ASM - display the diskgroup information)


Tools:
CHM (formerly know as IPD/OS) - Oracle Cluster Health Monitor.
ORION - Oracle I/O Calibration Tool - Load test tool.