Database Administration (MOSC)

MOSC Banner

making LOG_ARCHIVE_DEST_1 become null again

edited Apr 21, 2014 2:45AM in Database Administration (MOSC) 2 commentsAnswered ✓

I was fixing this database that I have to go through another ssh that also contains a database. (so ssh to a db server, and from there ssh to another db server).

I might have type exit one extra time. So I logged to the wrong db with sqlplus / as sysdba and from null I have done this :

------------This is original value ----

SQL> show parameter log_archive_dest

NAME                     TYPE     VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest             string

log_archive_dest_1             string

log_archive_dest_10             string

log_archive_dest_11             string

----------------------------

Then I did this:

alter system set  LOG_ARCHIVE_DEST_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center