Sunday, 16 September 2018

Rman backup

run {
allocate channel D1 type disk;
change archivelog all validate;
backup as compressed backupset database include current controlfile
format '/u02/oracle/backups/db1_%t_%s_%p';
sql 'alter system archive log current';
backup archivelog all delete input
format '/u02/oracle/backups/db1_arch_%t_%s_%p';
release channel D1;
}

1 comment:


  1. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    http://chennaitraining.in/sap-rem-training-in-chennai/
    http://chennaitraining.in/sap-scm-training-in-chennai/
    http://chennaitraining.in/sap-sd-training-in-chennai/
    http://chennaitraining.in/sap-sm-training-in-chennai/
    http://chennaitraining.in/sap-srm-training-in-chennai/
    http://chennaitraining.in/sap-success-factor-training-in-chennai/
    http://chennaitraining.in/sap-tr-training-in-chennai/
    http://chennaitraining.in/sap-wf-training-in-chennai/

    ReplyDelete

Featured post

duplicate db from standy to other server

 Duplicate Testuat   $ export ORACLE_SID=Testuat3 $ sqlplus '/as sysdba' Testuat3 SQL> alter system set cluster_database=FALSE sc...