今天在网上看到一个朋友问:为什么在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喎?https://www.2cto.com/kf/ware/vc/” target=”_blank” class=”keylink”>vc2FtcGxlL2NvbnRyb2xmaWxlL0N1cnJlbnQuMjU2LjU0MTk1NjQ3MyA8YnI+CllvdSBjYW4gdXNlIHRoZSBmdWoracle账号xseSBxdWFsaWZpZWQgZmlsZW5hbWUgdG8gcmVmZXJlbmNlIChyZWFkIG9yIHJldHJpZXZlKSBhbiBBU00gZmlsZS4gQVNNIGdlbmVyYXRlcyBhIGZ1bGx5IHF1YWxpZmllZCBmaWxlbmFtZSB1cG9uIGFueSByZXF1ZXN0IHRvIGNyZWF0ZSBhIGZpbGUuIEEgY3JlYXRpb24gcmVxdWVzdCBjYW5ub3Qgc3BlY2lmeSBhIGZ1bGx5IHF1YWxpZmllZCBmaWxlbmFtZS4gSW5zdGVhZCwgaXQgdXNlcyBhIHNpbXBsZXIgc3ludGF4IHRvIHNwZWNpZnkgYSBmaWxlLCBzdWNoIGFzIGFuIGFsaWFzIG9yIGp1c3QgYSBkaXNrIGdyb3VwIG5hbWUuIEFTTSB0aGVuIGNyZWF0ZXMgdGhlIGZpbGUsIHBsYWNpbmcgaXQgaW4gdGhlIGNvcnJlY3QgQVNNIKGwcGF0aKGxIGFjY29yZGluZyB0byBmaWxlIHR5cGUsIGFuZCB0aGVuIGFzc2lnbnMgYW4gYXBwcm9wcmlhdGUgZnVsbHkgcXVhbGlmaWVkIGZpbGVuYW1lLiBJZiB5b3Ugc3BlY2lmeSBhbiBhbGlhcyBpbiB0aGUgY3JlYXRpb24gcmVxdWVzdCwgQVNNIGFsc28gY3JlYXRlcyB0aGUgYWxpYXMgc28gdGhhdCBpdCByZWZlcmVuY2VzIHRoZSBmdWxseSBxdWFsaWZpZWQgZmlsZW5hbWUuPC9wPgoKPHA+1+6682xzIC1sIL+0wcvPwkFTTcDv1eLBvbj2xL/CvM/CtcS56bW1yNXWvs7EvP6687eiz9ajrMi3yrW+zcrH1eLW1sfpv/ajujwvcD4KCjxwPjxpbWcgc3JjPQ==”https://www.2cto.com/uploadfile/Collfiles/20150309/2015030910133392.jpg” alt=”这里写图片描述” title=”Z喎?https://www.2cto.com/database/Oracle/” target=”_blank” class=”keylink”>Oracle不希望我们改这些文件的路径,但我们热衷于做这个,而且ORacle自动产生的文件名不方便人为记忆并管理,估计oracle也意识到了这问题便也有了别名了。