Oracle Cloud Infrastructure
Coming soon ...
Apps R12.2
  • R12.2 Architecture
  • Cloning Error (RC-50208)
  • Apps R12.1
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Oracle 12c Database
  • Oracle12c PSU Apply
  • Oracle12c Datafile moved Online
  • Oracle 11g Database
  • Upgrade 10g to 11g R1
  • Upgrade 11.2.0.2 to 11.2.0.3
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    Wednesday, April 29, 2009
    RMAN Setup
    Hello Everyone!!!

    Setup RMAN User, Catalog & Register
    -----------------------------------------
    MAKE SURE ALL DATABASE have PASSWORD FILE

    sqlplus system/manager@rman <<__1

    drop user rman_TEST cascade;

    create user rman_TEST identified by rman_TEST
    default tablespace users
    temporary tablespace ts_temp
    quota unlimited on users
    quota unlimited on ts_temp ;
    grant connect , resource, recovery_catalog_owner to rman_TEST;
    exit
    __1
    # create the catalog
    rman catalog rman_TEST/rman_TEST@rman << __2
    create catalog;
    exit
    __2
    rman target \"sys/pass9999@TEST as sysdba\" \
    catalog rman_TEST/rman_TEST@rman << __3
    register database ;
    EXIT
    __3


    Full Backup Script – Hot Backup – Target DB in Archivelog Mode
    -------------------------------------------------------------------
    run {
    allocate channel c1 type disk;
    set limit channel c1 kbytes 500000;
    backup full
    filesperset 2
    (database format '/rman_backup/BACKUP/TEST_data_%U');
    sql "alter system archive log current";
    backup filesperset 10
    format '/rman_backup/BACKUP/TEST_arch%U'
    (archivelog all );
    release channel c1;
    }
    exit;



    Incremental Backup Script
    ------------------------------
    resync catalog;
    change archivelog all validate;
    run{
    allocate channel c1 type 'SBT_TAPE';
    allocate channel c2 type 'SBT_TAPE';
    backup
    format '/intr/cf_t%t_s%s_p%p'
    (current controlfile);
    backup
    incremental level 0
    tag db_intr_0
    filesperset 5
    format '/intr/df_t%t_s%s_p%p'
    (database);
    sql 'alter system archive log current';
    backup
    filesperset 20
    format '/intr/rl_t%t_s%s_p%p'
    (archivelog all delete input);
    release channel c1;
    release channel c2;
    }


    Full Backup Script – To Tape
    --------------------------------

    run {
    allocate channel t1 type 'SBT_TAPE';
    backup
    format 'db_%d_t%t_s%s_p%p'
    (database);
    sql 'alter system archive log current';
    backup
    format 'arch_%d_t%t_s%s_p%p'
    (archivelog all delete input);
    }


    Recover Specific Datafile
    -----------------------------
    run
    {
    allocate channel c1 type disk;
    sql 'alter database datafile 2 offline drop';
    restore datafile 2;
    recover datafile 2;
    release channel c1;
    }


    COMPLETE RECOVERY script using current controlfile
    -------------------------------------------------------
    run {
    allocate channel d1 type disk;
    restore database;
    sql 'alter database mount';
    recover database;
    }


    INCOMPLETE RECOVERY script using backup controlfile
    --------------------------------------------------------
    -- Required if there are gaps in log sequence

    run {
    SET UNTIL logseq = 6 thread = 1;
    allocate channel d1 type disk ;
    restore controlfile;
    restore database;
    sql 'alter database mount';
    recover database;
    sql 'alter database open resetlogs';
    }


    COMPLETE RECOVERY script using backup controlfile
    ------------------------------------------------------
    run {
    allocate channel d1 type disk;
    restore controlfile;
    restore database;
    sql 'alter database mount';
    recover database;
    sql 'alter database open resetlogs';
    }


    INCOMPLETE RECOVERY script using backup controlfile
    --------------------------------------------------------
    -- Required if there are gaps in log sequence

    run {
    # recover database until specific time
    allocate channel dev1 type 'SBT_TAPE';
    set until time 'Apr 20 2003 12:15:00';
    sql "alter database mount" ;
    restore database;
    switch datafile all;
    recover database;
    sql "alter database open resetlogs";
    release channel dev1;
    }



    Happy Learning
    --Sreene

    Labels:

    posted by Srinivasan .R @ 4:23 AM  
    0 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 14+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • Change hostname in Linux
  • R12:Major changes from 11i
  • Clone Apps 11i Instance
  • Upgrading 9i to 10g with 11i
  • Upgrade from 11.5.10.2 to R12
  • How to access EBS in mozile borwser in linux
  • Change hostname for E-Business Suite
  • Discoverer Troubleshooting
  • Error:ORA-01631
  • Multi-Node Installation
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal