Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Oracle 11g Feature Multisection Backup.

  1. #1
    Oracle Administrator
    Join Date
    Dec 2011
    Posts
    92

    Oracle 11g Rman Feature Multisection Backup.

    With this new feature RMAN backups can be split
    into multiple pieces.

    Suppose you want to backup your system tablespace and spread the
    backups to three different backup locations.
    You can do so through the following query.

    Code:
    RMAN> run {
     allocate channel c1 type disk format '/dest1/%U';
     allocate channel c2 type disk format '/dest1/%U';
     allocate channel c3 type disk format '/dest1/%U';
     backup
     section size 200M
     tablespace system;
    }
    In the above query the backups of the system tablespace will be done
    to three different locations with backup chunks of 200M each.

    After backup you can find your datafile number for the tablespace
    system by using the following command:

    Code:
    RMAN> report schema;
    Then the backups of a particular datafile can be checked
    by using the following command:

    Code:
    RMAN> list backup of datafile 1;
    Last edited by ajaychandi; 01-09-2012 at 02:33 PM.

+ Reply to Thread

Similar Threads

  1. Oracle 11g Feature Read Only Tables.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-10-2012, 09:29 PM
  2. Oracle 11gR2 Compression feature.
    By ajaychandi in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 01-03-2012, 03:28 AM
  3. Oracle Database Startup Restricted Feature.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-03-2012, 03:02 AM
  4. Oracle 11g I/O Calibration Feature.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 12-22-2011, 09:45 PM
  5. Oracle 11g Memory Advisor feature.
    By ajaychandi in forum Database Performance Management,Database Links,Materialized Views
    Replies: 0
    Last Post: 12-20-2011, 02:20 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics