Podstawowe komendy RMAN

BACKUP
   
    shutdown immediate;
    startup mount;
    configure controlfile autobackup format for device type disk clear;
    configure retention policy to redundancy 2;
    configure controlfile autobackup on;
    sql "create pfile=''%SPFILE2INIT%'' from spfile";
    backup as backupset device type disk database;
    configure controlfile autobackup off;
    alter database open;
    delete noprompt obsolete;

    //dla trybu archivelog
    configure controlfile autobackup format for device type disk clear;
    configure retention policy to redundancy 2;
    configure controlfile autobackup on;
    sql "create pfile=''%SPFILE2INIT%'' from spfile";
    backup as backupset device type disk database;
    configure controlfile autobackup off;
    sql 'alter system archive log current';
    delete noprompt obsolete;

RESTORE

    shutdown immediate;
    startup nomount pfile="%SPFILE2INIT%";
    restore (spfile from autobackup) (controlfile from autobackup);
    startup mount force;
    configure controlfile autobackup off;
    restore database;

    //dla trybu archivelog
    set  on;
    restore (spfile from autobackup db_recovery_file_dest='%rcvarea_loc%');
    startup nomount force;
    restore (controlfile from autobackup);
    alter database mount;
    configure controlfile autobackup off;
    restore database;