oracle新装之后必须做的

--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.启动用户跟踪后，记得一定要关闭