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;
# 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;