disaster recovery plan for oracle VLDB

Posted on 2009-12-30
Last Modified: 2012-05-08
can anybody give me the sample disaster recovery plan for VLDB's??
Question by:ramavenkatesa
    LVL 15

    Accepted Solution

    There are different kind of disaster/recoveries. Some recovery is based on invalid update/deletes other may be because of drop.
    1. If by mistake somebody drops the table, that can be eaisly recover by Flashback drop feature. You can also undo the DML changes using this technique.
    2. If there is block level corruption, then you can either fix block(s) using RMAN which is recommended or using manual steps (if RMAN is not configured)
    3. If you lost whole database and you have standby servers, then you can use data guard, which can be brought back within minimal time.
    4. If you lost very important schema and all its objects are present in one tablespace which is very large, then you can also use Transportable Tablespace feature.
    5. If you lost all control files, then re-create it using create controlfile command and include all the datafile/logfiles, then reset redo log sequence.
    6. If you lost one of the redo log which was not current, then create it and flush it.
    7. If you lost non system datafile, take the copy from backup, apply archive log using recover datafile command.

    There are many more... Please ready Backup and Recovery Guide:

    Author Comment

    can u please explain in high level recovery process
    1. with  backup taken to tape
    2, with backup taken using timefinder

    Author Comment

    i mean .. how can i configure netbackup to work with RMAN?
    can anybody give me step by step how can i configure netbackup with RMAN so that i write to tape??

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now