We can use ASM provided
command “cp” to copy files from file system to ASM diskgroup and vice versa;
and also from one ASM diskgroup to the other. If you receive ORA-15046 while
copying a file to an ASM diskgroup from file system, or from another diskgroup,
mostly it is because you are providing a file name for the destination file
that is not allowed in the ASM. From file name here I mean the file name in the
format that is used in ASM i.e. file_name.235.84753829.
Same error would also come if an invalid directory location is provided. Following
is an example of this error message
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Sunday, February 23, 2020
Friday, February 7, 2020
DBA_TABLESPACE_USAGE_METRICS and CDB_TABLES_ACES_USAGE_METRICS
DBA_TABLESPACE_USAGE_METRICS and CDB_TABLESPACE_USAGE_METRICS (starting 12c) provide us summary of space usage of each tablespace including TEMP and UNDO tablespaces. Only different between these 2 views is same as between all other CDB* and DBA* views whereby CDB* views contain information from all PDBs that is viewable from root container and have an extra column CON_ID to correspond each row to a particular PDB. Using this view makes it very easy to analyze space usage. In this article I would explain how to get information from these dictionary views to check the utilization of space within the tablespace(s). You may also want to read my articles about Tablespace space usage history and forecast for 12c and above, and for 11g and 10g.