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.
#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博客 ” ，链接：https://blog.itpub.net/28793776/viewspace-1592399/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
shell编程之if判断的总结
请登录后发表评论
登录
全部评论
