New to Oracle Financials?? Get trained from the best instructor known  to have trained novices as experts in this field.  Training comes with exhaustive  Lab practice material, study material and the never taught tips of handling issues in the application.

Batches : weekends / weekdays

Duration : / 40-45 hrs

For course content visit – www.fusionsol.co
All you need is an internet, skype(optional) and team viewer/GoTo meeting downloaded for sessions.

Benefits:-

1. Concept Oriented Trainings

2. Easy to follow Labs

3. Exhaustive study material

4. Real-time business processes and issues
Regards,
Rudrani Rathore
9908127726

info@fusionsol.co
www.fusionsol.co

Posted in BrainSurface, Database Family, E-Business Suite, Training | Leave a comment

collab12logo

Virtualization Events at COLLABORATE 12 – IOUG Forum

Sunday

  • 4-5pm IOUG Virtualization SIG Meet and Greet (Surf F)
  • 5-7pm IOUG Welcome Reception (Mandalay Bay L)

Monday

  • 12:15-1:15pm IOUG Virtualization SIG Meeting Palm A
  • 6-8pm IOUG Virtualization SIG Lounge Exhibit Hall; meet at IOUG Booth #1439

Virtualization Sessions at COLLABORATE 12*

*please visit My Show Planner for the latest information on virtualization sessions at http://events.ioug.org/p/cm/ld/fid=56 .

Monday

  • 9:45-10:45am 826 – Virtualization Boot Camp: Virtualizing Oracle on VMware – Quick Tips (Palm D)
  • 11am-12pm 543 – Virtualization Boot Camp: Oracle VM Consolidation and Path to the Cloud on the Cisco Unified Computing System (Palm D)
  • 11am-12pm 608 – Jailbreak the DBA: Doing More with Less in a Virtual World (Surf A)
  • 1:15 – 2:15pm 399 – Virtualization Boot Camp: Oracle VM Implementation and Administration (Palm D)
  • 2:30-3:30pm 165 – Virtualization Boot Camp: Using VirtualBox as Your Company’s Virtualization Technology (Palm D)
  • 3:45-4:45pm 328 – Virtualization Boot Camp: Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 3.0 Methods/Tips (Palm D)
  • 3:45-4:45pm 396 – Paravirtualization in an Oracle Database Environment (Mandalay Bay C)
  • 5-6pm 659 – Virtualization Boot Camp: Plan/Configure/Deploy – Clusters/High Availability with Oracle VM (Palm D)

Tuesday

  • 8-9am 469 – Virtualization Boot Camp: Demystifying Oracle Database Virtualization Part 1 of 3 (Mandalay Bay C)
  • 10:45-11:45am 470 – Virtualization Boot Camp: Demystifying Oracle Database Virtualization Part 2 of 3 (Mandalay Bay C)
  • 12-12:30pm 895 – Virtualization Boot Camp: Virtualizing Oracle 11gR2 RAC on VWware vSphere: Best Practices (Mandalay Bay C)
  • 2-3pm 468 – Virtualization Boot Camp: Demystifying Oracle Database Virtualization Part 3 of 3 (Mandalay Bay C)
  • 4:30-5:30pm 154 – Database Performance in a Virtualized World (Lagoon D)
  • 4:30-5:30pm 832 – Virtualization Boot Camp: What’s New with Oracle VM Serve for x86 (Mandalay Bay C)

Wednesday

  • 8:15-9:15am 570 – Cloud Computing Boot Camp: Cloud Computing Industry Directions: Part I (Palm D)
  • 9:30-10:30am 661 – Oracle on Oracle VM Expert Panel (Mandalay Bay L)
  • 11am-12pm 783 – Virtualization Oracle Critical Applications (Mandalay Bay K)
  • 12:15-12:45pm 287 – How I Use Oracle VirtualBox: Virtualization Can Benefit You Too (Surf A)
  • 3-4pm 831 – Oracle Virtualization Strategy and Roadmap (Palm D)
  • 3-4pm 811 – Oracle on VMware Expert Panel (Mandalay Bay L)
  • 4:15-5:15pm 374 – Learning Oracle with Oracle VM VirtualBox (Mandalay Bay K)

Thursday

  • 8:30-9:30am 196 – Combining Oracle Database Features with Storage Technologies to Solve DBA Challenges (Reef A)
  • 11am-12pm 875 – Monitoring Oracle Databases in a VMware Environment (Palm D)

Posted in BrainSurface, Career Management / Upward Mobility, Cloud Computing, Interview Questions, My Blogs, Oracle Open World, The BrainSurface Project, Virtualization, Whats Hot? | Leave a comment

collab12logo

Special Registration Code : AP03

(Expires 04/06/2012)

Registration URL:

http://ioug.org/c12

Sign Up, learn from and interact with the world’s top Oracle experts at COLLABORATE12

April 22-26, in Las Vegas, Nevada.


Unique offer for Oracle Virtualization SIG members and partners: Enter Priority Code AP03 by April 6 to be entered into a drawing for a $200 Mandalay Bay gift card, which will only be drawn from the pool of Virtualization SIG attendees who use this code.


COLLABORATE 12 is the independent Oracle training and networking event, with more than a thousand technical workshops, including a Virtualization Boot Camp – an entire track of courses focused on virtualization. You choose how intensely you want to focus on Virtualization.


The Virtualization Boot Camp, managed by Oracle ACE Director Tariq Farooq, offers the following courses:


Days Times Title Speaker Session ID
Monday 9:45am – 10:45am Virtualizing Oracle On Oracle VM–Quick Tips Michael Corey

826

Monday 11:00am – 12:00pm Oracle VM Consolidation and Path to the Cloud on the Cisco Unified Computing System John McAbel

543

Monday 1:15pm – 2:15pm Oracle VM Implementation and Administration Edward Whalen

399

Monday 2:30pm – 3:30pm Using VirtualBox as your Company’s Virtualization Technology Chris Ostrowski

165

Monday 3:45pm – 4:45pm Virtualizing Oracle 11g/R2 RAC Database on Oracle VM 3.0: Methods/Tips Kai Yu

328

Monday 5:00pm – 6:00pm Plan/Configure/Deploy – Clusters/High Availability with Oracle VM Tariq Farooq

659

Tuesday 8:00am – 9:00am Demystifying Oracle Database Virtualization Part I of III Charles Kim

469

Tuesday 10:45am – 11:45am Demystifying Oracle Database Virtualization Part II of III George Trujillo

470

Tuesday 12:00pm – 1:00pm Virtualizing Oracle 11gR2 RAC on VMWare vSphere: Best Practices Don Sullivan

895

Tuesday 2:00pm – 3:00pm Demystifying Oracle Database Virtualization Part III of III Kannan Mani

468

Tuesday 4:30pm – 5:30pm What’s New with Oracle VM Server for x86 Wim Coekaerts

832


Build Your Oracle Virtualization Network at COLLABORATE 12

Meet with fellow Oracle Virtualization professionals at COLLABORATE in both formal and fun settings, including:

    • Welcome reception, Sunday April 22 – Operation Classified: It’s Personal Now!
    • Receptions and Happy Hours on Monday and Tuesday evenings in the exhibit hall
    • Birds of a feather – Round Tables
    • Virtualization SIG Meeting

    Posted in BrainSurface, Career Management / Upward Mobility, Cloud Computing, Data Warehousing, Database Family, Development, E-Business Suite, ERP / Applications, Enterprise Manager, Fusion Applications, Fusion Middleware, High Availability, Interview Questions, My Blogs, Oracle Open World, SOA, Systems, The BrainSurface Project, Training, Whats Hot? | Leave a comment

    Oracle Database Administration (DBA):
    1. What is an Oracle Instance?
    2. What information is stored in Control File?
    3. When you start an Oracle DB which file is accessed first?
    4. What is the Job of SMON, PMON processes?
    5. What is Instance Recovery?
    6. What is written in Redo Log Files?

    There are two types of redo log files online and archive. Oracle uses the concept of groups and a minimum of 2 groups are required, each group having at least one file. They are used in a circular fashion when one group fills up oracle will switch to the next log group.

    The LGWR process writes redo information from the redo buffer to the online redo logs when

    user commits a transaction
    redo log buffer becomes 1/3 full
    redo buffer contains 1MB of changed records
    switch of the log files

    7. How do you control number of Datafiles one can have in an Oracle database?
    8. How many Maximum Datafiles can there be in an Oracle Database?
    9. What is a Tablespace?
    10. What is the purpose of Redo Log files?
    11. Which default Database roles are created when you create a Database?
    12. What is a Checkpoint?
    13. Which Process reads data from Datafiles?
    14. Which Process writes data in Datafiles?
    15. Can you make a Datafile auto extendible. If yes, how?
    16. What is a Shared Pool?
    17. What is kept in the Database Buffer Cache?
    18. How many maximum Redo Logfiles one can have in a Database?
    19. What is difference between PFile and SPFile?
    20. What is PGA_AGGREGRATE_TARGET parameter?
    21. Large Pool is used for what?
    22. What is PCT Increase setting?
    23. What is PCTFREE and PCTUSED Setting?
    24. What is Row Migration and Row Chaining?
    25. What is 01555 – Snapshot Too Old error and how do you avoid it?
    26. What is a Locally Managed Tablespace?
    27. Can you audit SELECT statements?
    28. What does DBMS_FGA package do?
    29. What is Cost Based Optimization?
    30. How often you should collect statistics for a table?
    31. How do you collect statistics for a table, schema and Database?
    32. Can you make collection of Statistics for tables automatic?
    33. On which columns you should create Indexes?
    34. What type of Indexes are available in Oracle?
    35. What is B-Tree Index?
    36. A table is having few rows, should you create indexes on this table?
    37. A Column is having many repeated values which type of index you should create on this column, if you have to?
    38. When should you rebuilt indexes?
    39. Can you built indexes online?
    40. Can you see Execution Plan of a statement.
    41. A table is created with the following setting
    storage (initial 200k
    next 200k
    minextents 2
    maxextents 100
    pctincrease 40)
    What will be size of 4th extent?
    42. What is DB Buffer Cache Advisor?
    43. What is STATSPACK tool?
    44. Can you change SHARED_POOL_SIZE online?
    45. Can you Redefine a table Online?
    46. Can you assign Priority to users?
    47. You want users to change their passwords every 2 months. How do you enforce this?
    48. How do you delete duplicate rows in a table?
    49. What is Automatic Management of Segment Space setting?
    50. What is the difference between DELETE and TRUNCATE statements?
    51. What is COMPRESS and CONSISTENT setting in EXPORT utility?
    52. What is the difference between Direct Path and Convention Path loading?
    53. Can you disable and enable Primary key?
    54. What is an Index Organized Table?
    55. What is a Global Index and Local Index?
    56. What is the difference between Range Partitioning and Hash Partitioning?
    57. What is difference between Multithreaded/Shared Server and Dedicated Server?
    58. Can you import objects from Oracle ver. 7.3 to 9i?
    59. How do you move tables from one tablespace to another tablespace?
    60. How do see how much space is used and free in a tablespace?
    61. What are the steps for manual database upgrade?
    62: How to clone a database using RMAN?
    63: What are the manual steps to clone a database?
    64: How many ASM instances are required to operate multiple databases?
    65: What is the location of CRS Logs in a 10G RAC and what are they?
    66: What are the mandatory processes in 9i and 10G?
    67: What are the mandatory tablespaces required in 9i and 10G?
    68: What is RAC?
    69: What is Cache Fusion?
    70: What components in RAC must reside in shared storage?
    71: What is an interconnect network?
    72: What is the use of cluster interconnect?
    73: How do users connect to database in an Oracle RAC environment?
    74: What is the use of a service in Oracle RAC environemnt?
    75: Which enable the load balancing of applications in RAC?
    76: What is a virtual IP address or VIP?
    77: What is the use of VIP?
    78: How do we verify that RAC instances are running?
    79: What is FAN?
    80: What is rolling upgrade?
    81: Can rolling upgrade be used to upgrade from 10g to 11g database?
    82: What are the initialization parameters that must have same value for every instance in an Oracle RAC database?
    83: What are the components of Oracle clusterware?
    84: What are the performance views in an Oracle RAC environment?
    85: What are the types of connection load-balancing?
    86: What is the usage of srvctl?
    87: Can Oracle’s Data Guard be used on Standard Edition, and if so how?
    88: How can you test that the standby database is in sync?
    89: What is the difference between Active Dataguard, and the Logical Standby implementation of 10g dataguard?
    90: What is a Dataguard?
    91: What are the uses of Oracle Data Guard?
    92: What is Redo Transport Services?
    93: What is apply services?
    94: What is difference between physical and logical standby databases?
    95: What is Data Guard Broker?
    96: What are the Data guard Protection modes and summarize each?

    Backup & Recovery Questions for an Oracle DBA:
    1. Which types of backups you can take in Oracle?
    2. A database is running in NOARCHIVELOG mode then which type of backups you can take?
    3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
    4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
    5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode?
    6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
    7. Where should you place Archive logfiles, in the same disk where DB is or another disk?
    8. Can you take online backup of a Control file if yes, how?
    9. What is a Logical Backup?
    10. Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
    11. Why do you take tablespaces in Backup mode?
    12. What is the advantage of RMAN utility?
    13. How RMAN improves backup time?
    14. Can you take Offline backups using RMAN?
    15. How do you see information about backups in RMAN?
    16. What is a Recovery Catalog?
    17. Should you place Recovery Catalog in the Same DB?
    18. Can you use RMAN without Recovery catalog?
    19. Can you take Image Backups using RMAN?
    20. Can you use Backupsets created by RMAN with any other utility?
    21. Where RMAN keeps information of backups if you are using RMAN without Catalog?
    22. You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
    23. You want to retain only last 3 backups of datafiles. How do you go for it in RMAN?
    24. Which is more efficient Incremental Backups using RMAN or Incremental Export?
    25. Can you start and shutdown DB using RMAN?
    26. How do you recover from the loss of datafile if the DB is running in NOARCHIVELOG mode?
    27. You loss one datafile and it does not contain important objects. The important objects are there in other datafiles which are intact. How do you proceed in this situation?
    28. You lost some datafiles and you don’t have any full backup and the database was running in NOARCHIVELOG mode. What you can do now?
    29. How do you recover from the loss of datafile if the DB is running in ARCHIVELOG mode?
    30. You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
    31. You loss controlfile how do you recover from this?
    32. The current logfile gets damaged. What you can do now?
    33. What is a Complete Recovery?
    34. What is Cancel Based, Time based and Change Based Recovery?
    35. Some user has accidentally dropped one table and you realize this after two days. Can you recover this table if the DB is running in ARCHIVELOG mode?
    36. Do you have to restore Datafiles manually from backups if you are doing recovery using RMAN?
    37. A database is running in ARCHIVELOG mode since last one month. A datafile is added to the database last week. Many objects are created in this datafile. After one week this datafile gets damaged before you can take any backup. Now can you recover this datafile when you don’t have any backups?
    38. How do you recover from the loss of a controlfile if you have backup of controlfile?
    39. Only some blocks are damaged in a datafile. Can you just recover these blocks if you are using RMAN?
    40. Some datafiles were there on a secondary disk and that disk has become damaged and it will take some days to get a new disk. How will you recover from this situation?
    41. Have you faced any emergency situation. Tell us how you resolved it?
    42. At one time you lost parameter file accidentally and you don’t have any backup. How you will recreate a new parameter file with the parameters set to previous values.

    Unix related Oracle DBA Interview Questions:
    1. How do you see how many instances are running?
    2. How do you automate starting and shutting down of databases in Unix?
    3. You have written a script to take backups. How do you make it run automatically every week?
    4. What is OERR utility?
    5. How do you see Virtual Memory Statistics in Linux?
    6. How do you see how much hard disk space is free in Linux?
    7. What is SAR?
    8. What is SHMMAX?
    9. Swap partition must be how much the size of RAM?
    10. What is DISM in Solaris?
    11. How do you see how many memory segments are acquired by Oracle Instances?
    12. How do you see which segment belongs to which database instances?
    13. What is VMSTAT?
    14. How do you set Kernel Parameters in Red Hat Linux, AIX and Solaris?
    15. How do you remove Memory segments?
    16. What is the difference between Soft Link and Hard Link?
    17. What is stored in oratab file?
    18. How do you see how many processes are running in Unix?
    19. How do you kill a process in Unix?
    20. Can you change priority of a Process in Unix?

    Engr. Pawan Kumar

    Technical Support Analyst

    Posted in Career Management / Upward Mobility, Data Guard, Interview Questions, Oracle Database Family, Whats Hot? | Leave a comment

    So i’ve been working on building my own home server and it was going well until I tested the components I purchased from new egg.

    I bought:
    MSI mother board/cpu with dual 1.6GHz processor for 79.99
    8gb 1066 DDR3 ram
    Dvd burner lite-on
    Rosewill card reader
    Mini ITX case for easing moving

    So I tested the motherboard and it wont power on, I’ve waited a week for these components and the main board doesn’t work – with or without ram I’m so disappointed. So now I’m trying to decide if I should just load Oracle on my media server or just wait for the replacement motherboard to come in the mail. I’m so impatient. Hopefully I won’t have to wait to long, I’m really just bored since finishing college and just looking for little projects to do.

    Posted in My Blogs | Leave a comment

    This is my first blog ever so please excuse my… “noobness”.

    I’m new to oracle but I got to say I’m really excited about it.  This is my 4th week in my 6 month long class and I’m really looking forward to every single session. This is in contrast to my attitude about anything involving programming and was very adamant about not programming…EVER! I was very intimidated by programming because I felt that is what GUI’s are for :D so why do I need to learn programming. But you know what knowing this stuff makes you more marketable and that’s what I need at this point in my “future” IT career.

    But…. I’m loving it! (sorry McDonalds) creating my first table was awesome, inserting data and managing user permissions reminds me of when I was an Analyst in the army working with SCO Open server UNIX.  I never said I didn’t do this before I just didn’t like it and at the time I had no choice, the military was making a big move for how to manage data more effectively and efficiently and I was glad to be apart of it.

    Not to go off on a tangent, again I’m glad to be doing this at this point in my life, its a huge game changer and I’m looking forward to how my life will be after I finish this class.

    Only God, my own determination, and my instructor will ever know.

    Thanks!

    Posted in BrainSurface, Career Management / Upward Mobility, My Blogs, Oracle Open World | Tagged , | Leave a comment

    Patch apply steps

    Steps for July 2007 security Patch apply  on oracle 10.2.0.4 database

    1) Required opatch version  – The required opatch version is 10.2.0.4.8 or higher. This thing you can check from patch read manual.
    Check the opatch version and confirm that the patch can be applied
    #opatch version

    2) Compile all the invalid objects by running utlrp.sql script
    SQL> @ORACLE_HOME/rdbms/admin/utlrp.sql

    3) Login to each individual databases and Shutdown all the databases
    SQL>SHUTDOWN IMMEDIATE

    4) shutdown all the listners if it is running.
    #lsnrctl stop
    #lsnrctl status
    5) Ensure no process in the name of oracle running under the oracle bin folder
    #fuser -u $ORACLE_HOME/bin/oracle
    if you found any process running under its name then kill that session from its process id.
    #kill -9
    6)visit to the patch directory and apply the patch
    #opatch napply -skip_subset   -skip_duplicate
    Ensure no errors
    7) check the erros if any $ORACLE_HOME/cfgtoologs/catbundle and start the database  and execeute the catbundle script
    sqlplus / as sysdba
    startup
    @catbundle.sql cpu apply
    @utlrp.sql
    quit

    8) Now check in the registry file for any kind of error
    sql>select * from registry$history where id=6452863;

    9)now upgrade the database and apply the view_recompile package as bug in the july 2007 patch

    $cd $ORACLE_HOME/cpu/view_recompile
    sqlplus
    shutdown immediate
    statup upgrade
    @view_recompile_jan2008cpu.sql
    shutdown immediate
    startup;
    quit

    10)Compile any invalid objects if found
    cd $ORACLE_HOME/rdbms/admin
    sqlplus / as sysdba
    @utlrp.sql

    11) Check any object is invalid. If u found any object in invalid state then recompile it.
    example:- alter package compile;

    Remove failed node from 11gR2 RAC cluster

    To delete a failed node and de-registered it from the cluster:
    crsctl unpin css -n si01crsctl delete node -n si01
    crsctl stat res -t | grep si01crsctl remove vip -i si01-vip -f
    crsctl stat res -tcrsctl stat res -t | grep si01
    Validate current stage before adding the node back:
    cluvfy stage -pre nodeadd -n si01 -fixup -fixupdir /tmpcluvfy stage -post hwos -n si01 -verbose
    export IGNORE_PREADDNODE_CHECKS=Y
    si02:/apps/grid/11.2.0/grid/oui/bin./runInstaller -updateNodelist ORACLE_HOME=’/apps/grid/11.2.0/grid’ “CLUSTER_NODES=si02,si03″ CRS=TRUE

    Add node back to the cluster:
    ./addNode.sh -silent “CLUSTER_NEW_NODES={si01}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={si01-vip}”  Starting Oracle Universal Installer…    Checking swap space: must be greater than 500 MB.   Actual 32767 MB    Passed  Oracle Universal Installer, Version 11.2.0.2.0 Production  Copyright (C) 1999, 2010, Oracle. All rights reserved.      Performing tests to see whether nodes si01,si03,si01 are available  ……………………………………………………… 100% Done.
    WARNING:A new inventory has been created on one or more nodes in this session. However, it has not yet been registered as the central inventory of this system. To register the new inventory please run the script at ‘/apps/oraInventory/orainstRoot.sh’ with root privileges on nodes ‘si01′.If you do not register the inventory, you may not be able to update or patch the products you installed.The following configuration scripts need to be executed as the “root” user in each cluster node./apps/oraInventory/orainstRoot.sh #On nodes si01/apps/grid/11.2.0/grid/root.sh #On nodes si01To execute the configuration scripts:    1. Open a terminal window    2. Log in as “root”    3. Run the scripts in each cluster node The Cluster Node Addition of /apps/grid/11.2.0/grid was successful.Please check ‘/tmp/silentInstall.log’ for more details.

    - root: /apps/oraInventory/orainstRoot.shChanging permissions of /apps/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.
    Changing groupname of /apps/oraInventory to oinstall.The execution of the script is complete.:/etc/rc.d/init.d- root: /apps/grid/11.2.0/grid/root.shRunning Oracle 11g root script…
    The following environment variables are set as:    ORACLE_OWNER= oracle ORACLE_HOME=  /apps/grid/11.2.0/grid
    Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of “dbhome” have not changed. No need to overwrite.The contents of “oraenv” have not changed. No need to overwrite.The contents of “coraenv” have not changed. No need to overwrite.

    Creating /etc/oratab file…Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /apps/grid/11.2.0/grid/crs/install/crsconfig_paramsCreating trace directoryCRS-4046: Invalid Oracle Clusterware configuration.CRS-4000: Command Create failed, or completed with errors.Failure initializing entries in /etc/oracle/scls_scr/si01/apps/grid/11.2.0/grid/perl/bin/perl -I/apps/grid/11.2.0/grid/perl/lib -I/apps/grid/11.2.0/grid/crs/install /apps/grid/11.2.0/grid/crs/install/rootcrs.pl execution failed
    To fix this CRS-4046, CRS-4000 issue:
    /apps/grid/11.2.0/grid/crs/install
    ./rootcrs.pl -verbose -deconfig –force
    Then re-run root.sh
    - root: ./root.sh…
    Configure Oracle Grid Infrastructure for a Cluster … succeeded

    Posted in My Blogs | Leave a comment

    ============DATA GUARD=================
    ———–
    ===========PRIMARY STEPS=================

    <oracle.root>chown -R oracle:oinstall /u01

    SQL>alter database force logging;

    rman>backup database plus archivelog;     OR (backup database include current controlfile for standby plus archivelog;)
    rman>backup current controlfile for standby;

    ====>”Transfer backup to standby”
    ====> Now first create folder on standby like mkdir 2011_03_25;
    ====> Transfer the backup on standby server on same location

    [root@sameer 2011_04_29]#
    scp -p * umer.com:/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_04_29/

    1. SQL>alter system set db_unique_name=’pri’ scope=spfile;

    2. SQL>alter system set log_archive_dest_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pri’;

    3. SQL>alter system set log_archive_dest_2=’SERVICE=standby LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=standby’;

    4. SQL>alter system set fal_server=standby;

    5. SQL>alter system set fal_client=pri;

    6. SQL>create net services for primary(pri)

    ============STANDBY Steps=================

    <oracle.root>chown -R oracle:oinstall /u01

    optional–SQL>create pfile from spfile;  or just set parameter by alter command on nomout

    1. SQL>alter system set log_archive_dest_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby’;

    2. SQL>alter system set log_archive_dest_2=’SERVICE=standby LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=pri’;

    3. SQL>alter system set fal_server=pri;

    4. SQL>alter system set fal_client=standby;

    5. SQL>alter system set db_unique_name=’standby’ scope=spfile;

    6. SQL>create net services for standby (standby)

    ==========STANDBY SERVER==============
    ————-

    >startup nomount  // if you have create pfile the “startup nomount pfile (change pfile)

    rman
    rman>connect target sys/oracle@pri
    rman>connect auxiliary /
    rman>duplicate target database for standby nofilenamecheck;

    SQL>

    SQL>recover managed standby database disconnect from session;
    SQL>select sequence#, applied from v$archived_log;

    “This command for check error for pri or standby”
    SQL>select error from v$archive_dest;

    “This command use for check status standby database from pri
    SQL>select * from v$dataguard_status;

    =======FOR REAL TIME APPLY==========

    ———-Add logfile PRI———–

    SQL>alter database add standby logfile group 4 ‘/u01/app/oracle/oradata/orcl/redo04.log’ size 50m;
    SQL>alter database add standby logfile group 5 ‘/u01/app/oracle/oradata/orcl/redo05.log’ size 50m;
    SQL>alter database add standby logfile group 6 ‘/u01/app/oracle/oradata/orcl/redo06.log’ size 50m;

    ———-Add logfile STANDBY———-

    mount mode
    SQL>recover managed standby database cancel;

    SQL>alter database add standby logfile group 4 ‘/u01/app/oracle/oradata/orcl/redo04.log’ size 50m;
    SQL>alter database add standby logfile group 5 ‘/u01/app/oracle/oradata/orcl/redo05.log’ size 50m;
    SQL>alter database add standby logfile group 6 ‘/u01/app/oracle/oradata/orcl/redo06.log’ size 50m;
    SQL> recover managed  standby database disconnect using current logfile;

    If u have create user or table on pri then u can check on standby
    ================================================================

    SQL> recover managed standby database cancel;
    SQL>alter database open read only;
    SQL>select user_name from dba_users;

    mount mode
    =======protection mode===========
    ——-On primary database——-
    SQL>alter database set standby database to maximize protection;
    SQL>alter database set standby database to maximize availability;
    SQL>alter database set standby database to maximize performance;

    on standby to see (Real time apply);
    =================================
    SQL> recover managed standby database cancel;
    SQL>recover managed standby database using current logfile;

    – Convert primary database to standby
    SQL>CONNECT sys/change_on_install@prim1 AS SYSDBA
    SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;

    – Shutdown primary database
    SQL>SHUTDOWN IMMEDIATE;

    – Mount old primary database as standby database
    STARTUP NOMOUNT PFILE=C:\Oracle\Admin\TSH1\pfile\init.ora
    SQL>ALTER DATABASE MOUNT STANDBY DATABASE;
    SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

    – Convert standby database to primary
    SQL>CONNECT sys/change_on_install@stby1 AS SYSDBA
    SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

    – Shutdown standby database
    SHUTDOWN IMMEDIATE;

    – Open old standby database as primary
    STARTUP PFILE=C:\Oracle\Admin\TSH1\pfile\init.ora

    How to connect with Dataguard at standby
    —————————————
    SQL>Startup mount
    SQL>ALTER DATABASE RECOVER  managed standby database disconnect;
    SQL>ALTER DATABASE RECOVER  managed standby database disconnect using current logfile;

    Logical Standby
    ===============

    standby
    SQL>alter database recover managed standby database cancel;

    pri
    SQL>alter system set log_archive_dest_3=’LOCATION=/u01 VALID_FOR=(standby_logfiles,standby_ROLE) DB_UNIQUE_NAME=pri’;
    SQL>alter system set undo_retention=3600;
    SQL>EXECUTE DBMS_LOGSTDBY.BUILD;

    standby
    SQL>Alter database recover to logical standby ora;
    SQL>alter system set db_name=ora scope=spfile;
    SQL>shu immedite
    [oracle@oracle dbs]$ orapwd file=ORAPWora password=oracle entries=5 force=y
    SQL>statrtup mout;
    SQL>Alter database open resetlogs;
    SQL>Alter database start logical standby apply immediate;

    by Engr pawan kumar
    pawankella@yahoo.com

    Posted in Data Guard, My Blogs | Tagged | 1 Comment

    I got the following error on the UpdateNodeList log on the added node:

    SEVERE: oracle.sysman.oii.oiix.OiixException: The Oracle home ‘F:\app\11.2.0\grid’ could not be updated as it does not exist.
     at oracle.sysman.oii.oiic.OiicBaseInventoryApp.getOracleHomeInfo(OiicBaseInventoryApp.java:645)
     at oracle.sysman.oii.oiic.OiicUpdateNodeList.doOperation(OiicUpdateNodeList.java:206)
     at oracle.sysman.oii.oiic.OiicBaseInventoryApp.main_helper(OiicBaseInventoryApp.java:790)
     at oracle.sysman.oii.oiic.OiicUpdateNodeList.main(OiicUpdateNodeList.java:399)

    How to get rid of this problem?

    Regards

    ORA_QUEST

    Posted in My Blogs | Leave a comment