11g New Features Contd

                                                11g New Features Contd

        

        Rman cloning

        Rman cloning from active database

        $rman target sys/manager@totarget nocatalog auxiliary sys/manager@totest

        Rman> duplicate target database to ‘test’ from active database;

 

        Configuring physical standby from active backup

        $rman target sys/manager@totarget nocatalog auxiliary sys/manager@tostdby

        Rman>duplicate target database for standby from active database;

       Converting physical standby to snapshot standby

   1.configure FRA (flashback recovery area) at standby side

        sql>alter database recover managed standby database disconnect;

        sql> alter database recover managed standby database cancel;

        sql>alter database convert to snapshot standby;

        open the database

        sql>select database_role from v$database;

        converting snapshot standby database back to physical standby

        sql>startup mount

        sql>alter database convert to physical standby;

        sql>select database_role from v$database;

      

        Parallel backup through section(chunks)           

        Rman>run

      {

      Allocate channel c1 device type disk;

      Allocate channel c2 device type disk;

      Allocate channel c3 device type disk;

      Backup section size 500m datafile 10;

      }

      Rman> list backup of datafile 10;

      Rman>list failure; (list block corruption and data failure)

      Rman>list failure <id>

      Rman>advise failure;

      Rman >repair failure;

 

      Faster backup compression using new algorithm ZLIB

      Rman>CONFIGURE COMPRESSION ALGORITHM 'ZLIB';

     Virtual catalog

-          prod (catalog db),  target db –> proda , prodb

 

     At catalog side –

-          create one more catalog user.

(prodb)

-          From any target db  (ex. proda)

-          $rman target / catalog rman/rman@tocatalog

-           Rman>grant catalog for database prodb to prodb;

Rman > list db_unique_name all;

     From prodb database

          $rman target / catalog prodb/prodb@tocatalog;

          Rman>create virtual catalog;

          Rman > list db_unique_name all;

 

      Now for prodb database backup information will  be store  in virtual catalog as well as base   catalog.

 

        ASM related new features:

 

        Asmcmd>lsdsk (shows the available no of disk)

        For Diskgroup meta data  backup

        Asmcmd>md_backup –b <file_name> -g <disk_group_name>

        Restore diskgroup meta data

        Asmcmd>md_restore –b <file_name>