oracle移动数据文件11g,oracle 11g Data Guard 移动数据文件

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  413372416 bytes

Fixed Size                  2213896 bytes

Variable Size             318769144 bytes

Database Buffers           88080384 bytes

Redo Buffers                4308992 bytes

Database mounted.

SQL>  host mv /u01/app/oradata/user04.dbf /u01/app/oradata/orcl/user04.dbf

SQL>  host mv /u01/app/oradata/user04.dbf /u01/app/oradata/orcl/user04.dbf

mv: 无法获取"/u01/app/oradata/user04.dbf" 的文件状态(stat): 没有那个文件或目录

SQL> alter system set standby_file_management=manual;

System altered.

SQL> alter database rename file '/u01/app/oradata/user04.dbf' to '/u01/app/oradata/orcl/user04.dbf';

Database altered.

SQL> alter system set standby_file_management=auto;

System altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL>

四 验证主备同步

主库

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL>

[oracle@primaryone trace]$ tail -f alert_orcl.log

Current log# 1 seq# 46 mem# 0: /u01/app/oradata/orcl/redo01.log

Thread 1 advanced to log sequence 47 (LGWR switch)

Current log# 2 seq# 47 mem# 0: /u01/app/oradata/orcl/redo02.log

Tue Feb 10 15:20:34 2015

Archived Log entry 82 added for thread 1 sequence 46 ID 0x5329e127 dest 1:

Tue Feb 10 15:21:23 2015

Thread 1 advanced to log sequence 48 (LGWR switch)

Current log# 3 seq# 48 mem# 0: /u01/app/oradata/orcl/redo03.log

Tue Feb 10 15:21:23 2015

Archived Log entry 83 added for thread 1 sequence 47 ID 0x5329e127 dest 1:

备库(要稍等几分钟)

[oracle@standbytwo trace]$ tail -f alert_orcl.log

RFS[7]: Selected log 4 for thread 1 sequence 48 dbid 1395237927 branch 867457193

Tue Feb 10 15:23:22 2015

Expanded controlfile section 11 from 28 to 186 records

Requested to grow by 158 records; added 6 blocks of records

Archived Log entry 44 added for thread 1 sequence 48 ID 0x5329e127 dest 1:

Media Recovery Log /u01/app/oracle/archivelogarc481867457193.arc

RFS[7]: Selected log 4 for thread 1 sequence 49 dbid 1395237927 branch 867457193

Media Recovery Waiting for thread 1 sequence 49 (in transit)

Recovery of Online Redo Log: Thread 1 Group 4 Seq 49 Reading mem 0

Mem# 0: /u01/app/oradata/orcl/stredo01.log