Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

archive destination

how we will find the archive destination in oracle database..
0
tonydba
Asked:
tonydba
1 Solution
 
Wasim Akram ShaikCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now