Thursday, May 2, 2019

How to check control file location on oracle 12c and 18c database ?

Question :How to check control file location on oracle 12c and 18c database ?

Answer: By using below query you will get control file location on oracle database.

Query :
SQL> show parameter control file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      +DATA/TESTDB/CONTROLFILE/curren
                                                 t.257.10005678985


No comments:

Post a Comment

How can I restore Cassandra snapshots?