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

本文介绍如何在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. 校验位置

1
2
3
4
5
6
7
8
9
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.

1
2
3
4
5
6
7
8
9
10
11
12
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.修改数据字典

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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. 检查是否成功

1
2
3
4
5
6
7
8
9
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>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值