RAC修改归档路径有绝招

实例一下面，用oracle用户执行：
#srvctl stop database -d portaldb
#srvctl status database -d portaldb
sql>startup mount
sql>alter system set log_archive_dest_1='LOCATION=+flash/arch/ldapuat' scope=spfile sid='*';
sql>alter system set cluster_database=false scope=spfile;
sql>shutdown immediate
sql>startup mount
sql>alter database archivelog
sql>alter database open
sql>alter system set cluster_database=true scope=spfile;
sql>shutdown immediate
sql>startup
实例二下面，startup开启数据库
SQL> startup;
ORACLE instance started.
Total System Global Area 1.6134E+10 bytes
Fixed Size    2242440 bytes
Variable Size 8086620280 bytes
Database Buffers 8019509248 bytes
Redo Buffers   26054656 bytes
Database mounted.
Database opened.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28793776/viewspace-1592399/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28793776/viewspace-1592399/