instance和media损坏恢复

1.相关视图

 v$sga

 v$sgastat

 v$instance

 v$process

 v$bgprocess

 v$database

 v$datafile

 v$instance_recovery

 v$fast_start_servers

 v$fast_start_transactions

 

2.参数

fast_start_mttr_target

log_checkpoint_timeout(9i前)

log_checkpoint_interval(9i前)

recovery_parallelism(并发数，往datafile中的并发数)

fast_start_parallel_rollback(回滚参数)

 

3.更改数据库为归档模式

  1)shutdown immediate,

  2)startup mount

  3)alter database archivelog

  4)alter database open

  5)full database backup(冷备份)

 

4.显示环境变量

 env|grep oracle

 export oracle_SID=denver

 

5.查看服务器模式

 archive log list

 自动归档

 LOG_ARCHIVE_START=TRUE

 手动归档

 LOG_ARCHIVE_START=FALSE

 

LOG_ARCHIVE_MAX_PROCESS=N(最大为10)

 

6.启动归档

 alter system archive log start to 'c:/u04/oracle/test/log';

 停止自动归档

alter system archive log stop

LOG_ARCHIVE_START=FALSE

 

7.测试

alter system  swith logfile;

查看数据

 

8.设置归档路径

log_archive_dest_n ="LOCATION=/archive1" mandatory

log_archive_dest_n ="SERVICE=standby_db1" optionnal ropen= 600

例：

 alter system set log_archive_dest_1 = "location=/u01/admin/den/test/" scope=both;

 alter system set log_archive_format="kkk%S.arc" scope=spfile;

 

9.相关视图

 v$archived_log

 v$archive_log

 v$log_history

 v$database

 v$archive_processes