今天晚上做了个升级,结束的比较早,又把一个系统的数据库做了个"倒退的"调整,由于存储上的空间不够,只好将一部分做RMAN的空间释放出来,步骤如下:
1、2台机器分别smitty clstop
2、DB1上varyonvg datavg
3、DB1上su - oracle
4、vi /oracle/app/oracle/product/9.2.0.6/dbs/inityz.ora
#20080627 zhushi archive mode
#log_archive_dest='/archivelog'
#log_archive_max_processes=8
#log_archive_start=TRUE
#log_buffer=4000000
5、
zjdb1@root[/oracle/app/oracle/product/9.2.0.6/dbs>]sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jun 27 21:05:36 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3826752000 bytes
Fixed Size 748032 bytes
Variable Size 671088640 bytes
Database Buffers 3154116608 bytes
Redo Buffers 798720 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
6、varyoffvg datavg
7、smitty clstart
阅读(1026) | 评论(0) | 转发(0) |
