[oracle@hxlbak ~]$ df (备库)
Filesystem1K-blocksUsed Available Use% Mounted on
/dev/sda177806763393768398528846% /
tmpfs49915204991520% /dev/shm
/dev/sda310970784 1040445244 100% /u01
3.查看备库的归档路径1(因为下面的步骤需要修改该参数)
SQL> show parameters log_archive_dest_1;(备库)
NAMETYPEVALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1stringlocation=/u01/app/oracle/dupli
cate/valid_for=(all_logfiles,all_
roles)db_unique_name=oraclbak
4.修改备库的归档路径(将之前的目录u01修改为u02,u02是加载在新添加的硬盘上的)
SQL>alter system set log_archive_dest_1='location=/u02/app/oracle/duplicate/ valid_for=(all_logfiles,all_roles) db_unique_name=oraclbak' scope=spfile;(备库)
5.重启备库
SQL> shutdown immediate(备库)
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount (备库)
ORACLE instance started.
Total System Global Area 1048576000 bytes
Fixed Size1223368 bytes
Variable Size268436792 bytes
Database Buffers775946240 bytes
Redo Buffers2969600 bytes
Database mounted.
6.备库应用归档日志SQL> alter database recover managed standby database disconnect from session;(备库)
7.主库切换日志SQL> alter system switch logfile;(主库)
System altered.
SQL> alter system switch logfile;(主库)
System altered.
8.主库的归档日志已经传到备库修改后的归档路径
[root@hxlbak duplicate]# pwd
/u02/app/oracle/duplicate
[root@hxlbak duplicate]# ls -l
total 16
-rw-r----- 1 oracle oinstall 12288 May 23 05:26 1_151_775456988.arc
-rw-r----- 1 oracle oinstall1024 May 23 05:27 1_152_775456988.arc
-- The End --