• 博客访问: 24851
  • 博文数量: 19
  • 用 户 组: 普通用户
  • 注册时间: 2009-06-11 09:46
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章存档

2009年(1)

2008年(18)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

Oracle Archive mode 2008-11-28 17:38:42

分类: Oracle

Configure for multiple archiver processes

log_archive_max_processes=;

SELECT value
FROM gv$parameter
WHERE name = 'log_archive_max_processes';

ALTER SYSTEM SET log_archive_max_processes=3;

SELECT value
FROM gv$parameter
WHERE name = 'log_archive_max_processes';

Startup The Database In Archivelog Mode


Steps Required To Take A Database Not In Archive Log Mode And Alter It To Archive Log Mode

SELECT log_mode
FROM gv$database;

SHUTDOWN;

STARTUP MOUNT EXCLUSIVE;

ALTER DATABASE
ARCHIVELOG;

ALTER DATABASE OPEN;

SELECT log_mode
FROM gv$database;

Startup The Database In NoArchivelog Mode


Steps Required To Take A Database In Archive Log Mode And Alter It To No Archive Log Mode

SELECT log_mode
FROM gv$database;

SHUTDOWN;

STARTUP MOUNT EXCLUSIVE;

ALTER DATABASE
NOARCHIVELOG;

ALTER DATABASE OPEN;

SELECT log_mode
FROM gv$database;

Restart After Archiving Logging Failure

Archive Logging Restart

SHUTDOWN;

STARTUP;

ARCHIVE
LOG START;

ARCHIVE
LOG ALL;

Archive Log Related Commands

Start Archive Logging

alter system archive log start;

Stop Archive Logging

alter system archive log stop;

Force archiving of all log files

alter system archive log all;

Force archiving of the current log file

alter system archive log current;

[@more@]

阅读(1385) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册