歸檔路徑切換(alternate)

platform.:linux as4.7 64bit+oracle 10.2.0.4

1. alter system set log_archive_dest_1='location=/data/asusl10/arch/ mandatory alternate=log_archive_dest_2 noreopen';

SYS@asusl10>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

alert_asusl10.log

Shutting down instance: further logons disabled
Tue Mar 29 10:11:25 2011
Stopping background process QMNC
Tue Mar 29 10:11:25 2011
Stopping background process CJQ0
Tue Mar 29 10:11:26 2011
Stopping background process MMNL
Tue Mar 29 10:11:27 2011
Stopping background process MMON
Tue Mar 29 10:11:28 2011
Shutting down instance (immediate)
License high water mark = 16
Tue Mar 29 10:11:28 2011
Stopping Job queue slave processes, flags = 7
Tue Mar 29 10:11:28 2011
Process OS id : 29829 alive after kill
Errors in file /u01/product/admin/asusl10/udump/asusl10_ora_29787.trc
Tue Mar 29 10:11:31 2011
Waiting for Job queue slaves to complete
Tue Mar 29 10:11:31 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Mar 29 10:11:33 2011
ALTER DATABASE CLOSE NORMAL
Tue Mar 29 10:11:33 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Mar 29 10:11:34 2011
Shutting down archive processes
Archiving is disabled
Tue Mar 29 10:11:44 2011
ARC1: Becoming the heartbeat ARCH
Tue Mar 29 10:11:44 2011
ARCH shutting down
ARC0: Archival stopped
Tue Mar 29 10:11:44 2011
ARC1: Archiving disabled
ARCH shutting down
ARC1: Archival stopped
Tue Mar 29 10:11:45 2011
Thread 1 closed at log sequence 7543
Successful close of redo thread 1
Tue Mar 29 10:11:45 2011
Completed: ALTER DATABASE CLOSE NORMAL
Tue Mar 29 10:11:45 2011
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Mar 29 10:12:15 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3

SYS@asusl10>startup
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory

注﹕需要修復LOG_ARCHIVE_DEST_1為available后才能正常啟動

2. alter system set log_archive_dest_1='location=/data/asusl10/arch/ mandatory alternate=log_archive_dest_2 reopen=3 max_failure=10';

經測試﹐不能切換

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

转载于:http://blog.itpub.net/25198367/viewspace-691190/