今天在網上看到一個朋友問:為什麼在ASM存儲管理的方式下明明只設置了log_archive_dest_1來指定歸檔的路徑,卻在ASM下發現了兩處歸檔日志文件?(未開閃回)
我查了一些資料,認為是這樣的:
Every file created in ASM gets a system-generated filename, otherwise known as a fully qualified filename (FQFN). The fully qualified filename represents a complete path name in the ASM file system. An example of a fully qualified filename is:
+dgroup2喎?http://www.Bkjia.com/kf/ware/vc/" target="_blank" class="keylink">vc2FtcGxlL2NvbnRyb2xmaWxlL0N1cnJlbnQuMjU2LjU0MTk1NjQ3MyA8YnI+CllvdSBjYW4gdXNlIHRoZSBmdWxseSBxdWFsaWZpZWQgZmlsZW5hbWUgdG8gcmVmZXJlbmNlIChyZWFkIG9yIHJldHJpZXZlKSBhbiBBU00gZmlsZS4gQVNNIGdlbmVyYXRlcyBhIGZ1bGx5IHF1YWxpZmllZCBmaWxlbmFtZSB1cG9uIGFueSByZXF1ZXN0IHRvIGNyZWF0ZSBhIGZpbGUuIEEgY3JlYXRpb24gcmVxdWVzdCBjYW5ub3Qgc3BlY2lmeSBhIGZ1bGx5IHF1YWxpZmllZCBmaWxlbmFtZS4gSW5zdGVhZCwgaXQgdXNlcyBhIHNpbXBsZXIgc3ludGF4IHRvIHNwZWNpZnkgYSBmaWxlLCBzdWNoIGFzIGFuIGFsaWFzIG9yIGp1c3QgYSBkaXNrIGdyb3VwIG5hbWUuIEFTTSB0aGVuIGNyZWF0ZXMgdGhlIGZpbGUsIHBsYWNpbmcgaXQgaW4gdGhlIGNvcnJlY3QgQVNNIKGwcGF0aKGxIGFjY29yZGluZyB0byBmaWxlIHR5cGUsIGFuZCB0aGVuIGFzc2lnbnMgYW4gYXBwcm9wcmlhdGUgZnVsbHkgcXVhbGlmaWVkIGZpbGVuYW1lLiBJZiB5b3Ugc3BlY2lmeSBhbiBhbGlhcyBpbiB0aGUgY3JlYXRpb24gcmVxdWVzdCwgQVNNIGFsc28gY3JlYXRlcyB0aGUgYWxpYXMgc28gdGhhdCBpdCByZWZlcmVuY2VzIHRoZSBmdWxseSBxdWFsaWZpZWQgZmlsZW5hbWUuPC9wPgoKPHA+1+6682xzIC1sIL+0wcvPwkFTTcDv1eLBvbj2xL/CvM/CtcS56bW1yNXWvs7EvP6687eiz9ajrMi3yrW+zcrH1eLW1sfpv/ajujwvcD4KCjxwPjxpbWcgc3JjPQ=="http://www.2cto.com/uploadfile/Collfiles/20150309/2015030910133392.jpg" alt="這裡寫圖片描述" title="Z喎?http://www.Bkjia.com/database/Oracle/" target="_blank" class="keylink">Oracle不希望我們改這些文件的路徑,但我們熱衷於做這個,而且ORacle自動產生的文件名不方便人為記憶並管理,估計oracle也意識到了這問題便也有了別名了。