FQFN – Fully Qualified Filenames in ASM

Database-View DBA_DATA_FILES

SQL>select file_name from dba_data_files;
+DATA/tbsusers08.dbf

ASM Storage

ASMCMD> cd +DATA
ASMCMD> ls -l  tbsconcurrentusers08.dbf
Type      Redund  Striped  Time             Sys  Name
N    tbsusers08.dbf => +DATA/CSMDB/DATAFILE/TBSUSERS08.309.884792141

http://blog.dbvisit.com/fqfn-fully-qualified-filenames-in-asm/

https://nikhildbasavvy.wordpress.com/2014/10/01/renaming-datafile-in-asm-save-time-by-using-rman/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s