linux scp命令及其他处理

1.scp命令
# scp kltest20150407.dmp root@121.43.153.233:/
The authenticity of host '121.43.153.233 (121.43.153.233)' can't be established.
RSA key fingerprint is 18:20:c1:72:e8:14:19:01:67:aa:e6:58:5c:ef:c2:ed.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '121.43.153.233' (RSA) to the list of known hosts.
root@121.43.153.233's password: 
kltest20150407.dmp                                             100% 1576KB   1.5MB/s   00:00    
# pwd
/home/oracle/backup




2.klform 等用户名密码过期


create profile klform_profile limit password_life_time unlimited;
alter user klform profile klform_profile; 
select username,account_status,expiry_date,profile from dba_users where username='KLFORM';
select * from dba_profiles where profile='KLFORM_PROFILE';


改密码的命令为：
alter user klform identify by klform111;


3.导出时报 EXP-00011错误


(1)用system帐号进入： 
  1.1 查看是否为true 
show parameter deferred_segment_creation; 
  1.2 修改为false 
alter system set deferred_segment_creation=false; 


(2)用数据库帐号登录： 
  2.1 查找所有数据表为空的表 
select table_name from user_tables where NUM_ROWS=0; 
  2.2 把这些表组成修改Segment的脚本： 
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0; 
  2.3 将2.2中查询的结果导出来，或者复制出来，并执行修改所有空表。 




4.定时任务脚本维护


查看定时任务
# crontab -l
0  1  * * *  su - oracle -c /home/oracle/archbak.sh
0  2  * * *  su - oracle -c /home/oracle/archdel.sh
0  0  1 * * root rdate -s time.nist.gov


编辑定时任务
#crontab -e
添加下面几行进去
0  1  * * *  su - oracle -c /home/oracle/archbak.sh
0  2  * * *  su - oracle -c /home/oracle/archdel.sh
0  0  1 * * root rdate -s time.nist.gov


$ pwd
/home/oracle
$ vi archdel.sh
find /backup/archlog -ctime +1 -exec rm -rf {} \;
find /u01/11g/admin/kldb/adump -ctime +5 -exec rm -rf {} \;
find /u01/11g/admin/erptest/adump -ctime +5 -exec rm -rf {} \;
find /u01/11g/diag/rdbms/kldb/kldb/trace -ctime +5 -exec rm -rf {} \;
find /u01/11g/diag/rdbms/erptest/erptest/trace -ctime +5 -exec rm -rf {} \;




5.创建新的归档和闪回目录


SQL> shutdown immediate;
SQL> startup mount;


SQL> alter system set db_recovery_file_dest_size=2g scope=both;


SQL> alter system set db_recovery_file_dest='/u01/11g/flashback';


SQL> alter database archivelog;


SQL> alter system set log_archive_dest='/u01/11g/archive' scope=spfile;


SQL> alter database flashback on;
SQL> alter database open;


SQL> select flashback_on from v$database;


RMAN> configure retention policy to recovery window of 1 days;
RMAN>CONFIGURE RETENTION POLICY REDUNDANCY 3;
SQL>alter system set db_recovery_file_dest_size=4G scope=both;


SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;