一、数据库启动到mount状态
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size 2020192 bytes
Variable Size 92277920 bytes
Database Buffers 184549376 bytes
Redo Buffers 2170880 bytes
Database mounted.
二、把归档路径设置空，然后设置log_archive_dest_1路径
SQL> alter system set log_archive_dest=''scope=spfile;
System altered.
SQL> alter system set log_archive_dest_1='location=/u01/backup/back/'scope=spfile;
System altered.
三、重启数据库查看
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size 2020192 bytes
Variable Size 92277920 bytes
Database Buffers 184549376 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/backup/back/
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size 2020192 bytes
Variable Size 92277920 bytes
Database Buffers 184549376 bytes
Redo Buffers 2170880 bytes
Database mounted.
二、把归档路径设置空，然后设置log_archive_dest_1路径
SQL> alter system set log_archive_dest=''scope=spfile;
System altered.
SQL> alter system set log_archive_dest_1='location=/u01/backup/back/'scope=spfile;
System altered.
三、重启数据库查看
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size 2020192 bytes
Variable Size 92277920 bytes
Database Buffers 184549376 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/backup/back/
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29618264/viewspace-2093966/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORACLE RMAN备份及还原
下一篇：
关于pfile，spfile的一些命令
请登录后发表评论
登录
全部评论
