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
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