oracle主备库重启,备库磁盘空间满后的处理

[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 --