--oracle新装之后必须做的
1.开启闪回,归档,数据库参数忧化
参数名称 参数值
db_cache_size 根据实际内存规划
db_keep_cache_size 根据实际内存规划
db_file_multiblock_read_count 16
db_writer_processes 6
cursor_sharing similar
shared_pool_size 根据实际内存规划
shared_pool_reserved_size shared_pool_size*10%
open_cursors 3000
open_links 30
session_cached_cursors 300
job_queue_processes 10
java_pool_size 200M
large_pool_size 200M
log_buffer 16000000
log_archive_max_processes 9
processes 根据用户并发数规划
pga_aggregate_target 根据实际内存规划
undo_retention 3600
optimizer_dynamic_sampling 2
optimizer_index_cost_adj 10
optimizer_index_caching 10
startup mount
alter database archivelog
alter database flashback on
2.修改归档的存储路径
show parameter log%
alter system set log_archive_dest_1='location=/opt/oracle/archivelog/';
3.增加日志文件组或成员
select * from v$logfile
alter database add logfile group 4 ('/opt/oracle/database/temp1/redo04.log') size 50m;
alter database add logfile member
'/opt/oracle/database/temp1/redo01a.log' to group 1,
'/opt/oracle/database/temp1/redo02a.log' to group 2,
'/opt/oracle/database/temp1/redo03a.log' to group 3;
4.增加控制文件到其它分区(可选)
show parameter control%
alter system set control_files=
'/opt/oracle/oradata/orcl/control01.ctl',
'/opt/oracle/oradata/orcl/control02.ctl',
'/opt/oracle/oradata/orc;/control03.ctl',
'/opt/oracle/oradata/control00.ctl' scope=spfile
5.部署RMAN
1.创建表空间
create tablespace rman datafile '$ORACLE_BASE/rman/rman.dbf' size 300m
extent management local segment space management auto;
2.创建用户
create user rman identified by rman default tablespace rman
3.授权
grant connect,resource,recovery_catalog_owner to rman
RMAN设置
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS; 保证至少有一个备份能恢复到Sysdate-5 的时间点上
a)CONFIGURE RETENTION POLICY TO REDUNDANCY 2; (每次备份2份)
b)CONFIGURE CONTROLFILE AUTOBACKUP ON; (每次自动备份控制文件)
c)CONFIGURE DEVICE TYPE DISK PARALLELISM 2 ; (每次自动备份时并行通道相当于开几个进程)
d)CONFIGURE BACKUP OPTIMIZATION ON; (备份时忧化速度)
e)CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/sda8/oraclebak/rmanorcl_%u';(指定备份文件路径和文件名)
6. 定期清理alert.log文件
7.启动用户跟踪后,记得一定要关闭