List out the database all directories with full path

 

To list out the Database Directories which can be useful in Database Restore 

       
select distinct regexp_substr(name,'^.*/') as db_path from v$tempfile union all
select distinct regexp_substr(name,'^.*/') as db_path from v$datafile union all
select DESTINATION as db_path from V$ARCHIVE_DEST where dest_id=1 union all
select distinct regexp_substr(name,'^.*/') as db_path from V$CONTROLFILE union all
select distinct regexp_substr(member,'.*/') as db_path from v$logfile union all
select distinct value as db_path from V$PARAMETER
where name in
('core_dump_dest', 'db_recovery_file_dest','background_dump_dest', 'user_dump_dest','core_dump_dest', 'audit_file_dest') ;