Tuesday, 12 July 2016

Basic Database Commands for Regular Activities.

1. To check Database name,Current Status, Role.

SQL > select name,open_mode,database_role,created from v$database;

Posted by at
Labels:

2 comments:

  1. MKumar0729 October 2016 at 18:59

    http://www.tecmint.com/ssh-passwordless-login-using-ssh-keygen-in-5-easy-steps/
    ssh-keygen -t rsa
    touch $HOME/.ssh/authorized_keys
    chmod 600 $HOME/.ssh/authorized_keys
    cat $HOME/.ssh/id_rsa.pub >> $HOME/.ssh/authorized_keys
    chmod 400 $HOME/.ssh/authorized_keys


    oracle@localdb01 CAFOS]$ sh /home/oracle/scripts/archivemove_DB01.sh
    sending incremental file list
    ./
    1_277_916187371.dbf
    1_278_916187371.dbf
    1_279_916187371.dbf
    1_280_916187371.dbf
    1_281_916187371.dbf
    1_282_916187371.dbf

    sent 124137499 bytes received 130 bytes 3819619.35 bytes/sec
    total size is 54621243392 speedup is 440.01
    [oracle@localdb01 CAFOS]$
    [oracle@localdb01 CAFOS]$ cat /home/oracle/scripts/archivemove_CAFOS.sh
    export ORACLE_SID=CAFOS
    export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
    export PATH=$ORACLE_HOME/bin:$PATH:.
    rsync -avz -u --update --include '1_*dbf' /u01/app/oracle/CAFOS/archive/ 10.1.1.91:/u01/app/oracle/DR/archive



    [oracle@localdb01 CAFOS]$ crontab -l

    15,30,45,59 * * * * /home/oracle/scripts/archivemove_CAFOS.sh > /home/oracle/scripts/archivemove_CAFOS.log



    ReplyDelete
  2. Anonymous29 October 2016 at 20:19

    http://pandidba.blogspot.in/2015/11/archive-gap-between-primary-and-standby.html

    ReplyDelete

Subscribe to: Post Comments (Atom)