archive destination

how we will find the archive destination in oracle database..
tonydbaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Wasim Akram ShaikConnect With a Mentor Commented:
login to oracle database via sysdba

sqlplus "/ as sysdba"

and type this

show parameter dest;

or login to system and execute the query

select * from v$parameter where name='log_archive_dest';
0
 
sdstuberCommented:
you can have more than one archive destination

select * from v$parameter where name like 'log_archive_dest%'


you definitely do NOT need to be sysdba to run that query.

you will need some elevated privileges to select from that dictionary view but it's not a good practice to get into the habit of logging in as sysdba.  It's rarely needed and usually improper to do so.
0
 
tonydbaAuthor Commented:
yes it is fine..
0
All Courses

From novice to tech pro — start learning today.