小麦苗的常用代码--常用命令（仅限自己使用）--下

小麦苗的常用代码--常用命令（仅限自己使用）--下

上篇：https://blog.csdn.net/lihuarongaini/article/details/100743471

--------------------------------------------------------------------------------------------------------------   修改日期的显示格式
execute immediate 'alter session set NLS_DATE_FORMAT=''YYYY-MM-DD DY HH24:MI:SS'''; 
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
alter system set nls_date_format='yyyy-mm-dd hh24:mi:ss' scope=spfile;


----------------------------------------------------------------------------- sqlplus 设置
 --$ORACLE_HOME/sqlplus/admin/glogin.sql


 sqlplus中的清屏命令： clear scr

 --修改提示符
set linesize 9999 pagesize 9999
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "



 
set time on;
set line 9999
set pagesize 9999;
set timing on;
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "



set echo on;
set time on;
SET  99999999;
SET CHUNKSIZE 1000000;
set timing on;
set serveroutput on  size 1000000;
set sqlblanklines on;
set linesize 800;
set pagesize 50000;
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "
host color 02 
alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';
set errorlogging on table lhr.sperrorlog;
set errorlogging on identifier LHR_SESSION


---  alter session set nls_date_language='american' ;

--------------------------------------------------------rman备份--  全备 ---------------------------------------------------------

backup database include current controlfile plus archivelog delete input ;
backup as backupset database  format  '/u05/oracle/oracle_bk/orclasm/full_%n_%T_%t_%s_%p.bak' include current controlfile plus archivelog;
backup  as compressed backupset  format  '/arch/oracle_bk/ora2lhr/full_%n_%T_%t_%s.bak' database include current controlfile plus archivelog delete input ;

run
{
 backup as compressed backupset database;
 sql 'alter system archive log current';
 backup archivelog all ;
 backup current controlfile;
}


----------------------------- 归档 open 全备
export ORACLE_SID=ora11g
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
MYDATE=`date +'%Y%m%d%H%M%S'`
BACKUP_DIR=/home/oracle/oracle_bk/$ORACLE_SID
mkdir -p $BACKUP_DIR/log

 
rman target /  log $BACKUP_DIR/log/rman_full_$MYDATE.log append <