第29次：2014-08-26

botang

2014-08-26-crontab.txt:

1. ORACLE_BASE=/u01/app/oracle
   
2. ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
   
3. ORACLE_SID=orcl
   
4. 
   
5. 
   
6. * * * * *   /u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / cmdfile=/home/oracle/mybackup.rcv
   

复制代码

2014-08-26-mybackup.rcv:

1. backup tablespace users;
   
2. delete noprompt obsolete redundancy 2;
   
3. exit;
   

复制代码

2014-08-26-plsql.sql:

1. select  * from tab;
   
2. 
   
3. select * from db;
   
4. 
   
5. select  * from RC_BACKUP_SET;

复制代码