Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Oracle 11g | Oracle DBA – Tips and Techniques | Page 3
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

11g RMAN REPAIR ADVISOR

  • Posted by Arjun Raja
  • On June 25, 2009
  • 1 Comments
USING RMAN REPAIR ADVISOR: Export ORACLE_SID=test1 sqlplus “sys as sysdba” Shutdown immediate. Go to c:\app\bb16872\test1 and rename SYSTEM01.DBF to SYSTEM01.old Next try to startup database…will fail with error that SYSTEM01.DBF is missing. Y:\>rman target / Recovery Manager: Release 11.1.0.6.0 – Production on Wed Apr 30 10:51:03 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. […]
Read More
 

11g – using the PIVOT and UNPIVOT commands

  • Posted by Gavin Soorma
  • On June 24, 2009
  • 0 Comments
11g has a very good new feature for SQL*PLUS called PIVOT and UNPIVOT - it is very useful for creating cross tabular reports and aggregates. In earlier Oracle versions this would have needed a lot of coding using the DECODE function .... Objective - find the count of employees in each department broken down by […]
Read More
 

11g Standby Database creation without a backup

  • Posted by Gavin Soorma
  • On June 24, 2009
  • 0 Comments
11g New Feature – Standby Database creation from active database without having to take a backup …. Note the command output – APEXDG is created by copying the datafiles directly from an open database APEX without having to restore the backup from tape RMAN> run { allocate channel c1 type disk; allocate auxiliary channel c2 […]
Read More
 

11g Passwords can be case sensitive

  • Posted by Arjun Raja
  • On June 22, 2009
  • 0 Comments
In 11g – Passwords are case sensitive but this can be controlled by an init.ora parameter – SQL> show parameter SEC_CASE_SENSITIVE_LOGON ; NAME TYPE VALUE ———————————— ———– —————————— sec_case_sensitive_logon boolean TRUE SQL> create user arjun identified by ARJUN; – Password in Upper Case. User created. SQL> grant create session to arjun; Grant succeeded. SQL> conn […]
Read More
 

11g ACTIVE STANDBY

  • Posted by Arjun Raja
  • On June 22, 2009
  • 0 Comments
Active Standby : PRIMARY DB- APEX STANDBY DB- APEXDG Now you can bring up the standby database in read-only mode and continue to have the standby database updated from the primary. Here are the steps to achieve that: 1. Stop the managed recovery process on STANDBY database : In APEXDG ( Standby database ) SQL […]
Read More