redo log移动位置并重新命名步骤

最新推荐文章于 2024-03-18 17:59:28 发布

原创最新推荐文章于 2024-03-18 17:59:28 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#11g #database #数据库

基本管理专栏收录该内容

6 篇文章

订阅专栏

本文介绍如何在Oracle 11g R2及10g环境下移动和重命名在线重做日志文件。包括数据库关闭、日志文件复制、数据字典更新及验证步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

It is possible to move/rename the online redo logs should the need arise. This document will detail the steps required to move/rename the online redo logs in an 11gR2 environment on Linux. These steps also apply to a 10g environment.

在有特殊需求时我们可能需要对联机在线日志进行移动或重命名，遵照一下步骤即可完成（9i/10g/11g）

1. 校验位置

SQL>
select 
member from 
v$logfile;
 
MEMBER
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/orcl/redo03.log
/u02/app/oracle/oradata/orcl/redo02.log
/u02/app/oracle/oradata/orcl/redo01.log
 
SQL>

2. 关闭数据库拷贝

source: /u02/app/oracle/oradata/orcl target：/u02/app/oracle/oradata/orcl/redo

确保数据库处于mount状态

First we will shutdown the database and move the online redo logs to their new location.

SQL> shutdown immediate
Database
closed.
Database
dismounted.
ORACLE instance shut down.
SQL> host
[oracle@ora1 ~]$ mv /u02/app/oracle/oradata/orcl/redo01.log /u02/app/oracle/oradata/orcl/redo/redo01.log
[oracle@ora1 ~]$ mv /u02/app/oracle/oradata/orcl/redo02.log /u02/app/oracle/oradata/orcl/redo/redo02.log
[oracle@ora1 ~]$ mv /u02/app/oracle/oradata/orcl/redo03.log /u02/app/oracle/oradata/orcl/redo/redo03.log
[oracle@ora1 ~]$ exit
exit
 
SQL>

3.修改数据字典

SQL> startup mount
ORACLE instance started.
 
Total System
Global 
Area  849530880 bytes
Fixed
Size                  
1339824 bytes
Variable
Size             
528485968 bytes
Database
Buffers          314572800 bytes
Redo Buffers                5132288 bytes
Database
mounted.
SQL>
alter 
database rename file '/u02/app/oracle/oradata/orcl/redo01.log'
to '/u02/app/oracle/oradata/orcl/redo/redo01.log';
 
Database
altered.
 
SQL>
alter 
database rename file '/u02/app/oracle/oradata/orcl/redo02.log'
to '/u02/app/oracle/oradata/orcl/redo/redo02.log';
 
Database
altered.
 
SQL>
alter 
database rename file '/u02/app/oracle/oradata/orcl/redo03.log'
to '/u02/app/oracle/oradata/orcl/redo/redo03.log';
 
Database
altered.
 
SQL>
alter 
database open;
 
Database
altered.
 
SQL>

4. 检查是否成功

SQL>
select 
member from 
v$logfile;
 
MEMBER
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/orcl/redo/redo03.log
/u02/app/oracle/oradata/orcl/redo/redo02.log
/u02/app/oracle/oradata/orcl/redo/redo01.log
 
SQL>