Useful commands RMAN

------------------------to take backup as copy/image or  backupset---------------------

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO backupset;

--------------------------------check for all archives--------------------------------------

crosscheck archivelog all;

-----------------------------------skip inaccessible-----------------------------------------

backup database plus archivelog skip inaccessible ;

---------------------------------delete all archives-----------------------------------------

delete archivelog all

-----------------delete archives after backup & skip inaccessible-----------------------

RMAN> backup database plus archivelog skip inaccessible delete all input;




------------- Creating Duplicate SB database in networking----------------

DUPLICATE TARGET DATABASE
  FOR STANDBY
  FROM ACTIVE DATABASE
 SPFILE
  SET DB_NAME='ORCL'
  SET DB_UNIQUE_NAME='ORCL'
  SET DB_RECOVERY_FILE_DEST='E:\app\navneet\flash_recovery_area'
  SET  CONTROL_FILES='E:\APP\NAVNEET\ORADATA\ORCL\CONTROL01.CTL',     'E:\APP\NAVNEET\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'
  SET DB_FILE_NAME_CONVERT='E:\app\navneet\oradata\strdb\', 'E:\app\navneet\oradata\orcl\'
  SET LOG_FILE_NAME_CONVERT='E:\app\navneet\oradata\strdb\', 'E:\app\navneet\oradata\orcl\';