Results 1 to 6 of 6

Thread: Ora-19802

  1. #1
    Join Date
    Jan 2006
    Posts
    4

    Unanswered: Ora-19802

    Hi,
    I have this problem:
    ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

    oracle version is 10g on Linux.
    The db had worked fine until I restarted it .

    some one could help me?

  2. #2
    Join Date
    Sep 2004
    Posts
    60

    Lightbulb

    One of the site give the probable cause & action you should do:

    Cause: There are two possible cause for this error:
    1) The DB_RECOVERY_FILE_DEST parameter was in use when no DB_RECOVERY_FILE_DEST_SIZE parameter was encountered while fetching initialization parameter.
    2) An attempt was made to set DB_RECOVERY_FILE_DEST with the ALTER SYSTEM command when no DB_RECOVERY_FILE_DEST_SIZE was in use.

    Action: Correct the dependency parameter definitions and retry the command.
    ------------------------------------------
    Please see your INIT.ORA or SPFILE to set the proper parameters.

  3. #3
    Join Date
    Jan 2006
    Posts
    4
    I did it but nothing is changed

  4. #4
    Join Date
    Jan 2006
    Posts
    4
    that is my init.ora:
    audit_file_dest = /u03/app/oracle/admin/orcl/adump
    background_dump_dest = /u03/app/oracle/admin/orcl/bdump
    core_dump_dest = /u03/app/oracle/admin/orcl/cdump
    db_file_multiblock_read_count = 16
    dispatchers = '(PROTOCOL=TCP) (SERVICE=orclXDB)'
    job_queue_processes = 10
    user_dump_dest = /u03/app/oracle/admin/orcl/udump
    compatible = 10.2.0.1.0
    control_files = ('/u03/app/oracle/oradata/orcl/control01.ctl', '/u03/app/oracle/oradata/orcl/control02.ctl', '/u03/app/oracle/oradata/orcl/control03.ctl')
    db_block_size = 8192
    db_domain = ''
    db_name = orcl
    db_recovery_file_dest = /u03/app/oracle/flash_recovery_area
    db_recovery_file_dest_size = 2G
    open_cursors = 300
    pga_aggregate_target = 90M
    processes = 150
    remote_login_passwordfile = EXCLUSIVE
    sga_target = 427819008
    undo_management = AUTO
    undo_tablespace = UNDOTBS1

    do you see something wrong?

  5. #5
    Join Date
    Sep 2004
    Posts
    60
    When did you receive this error? If it was at database startup then check whether you are using spfile or pfile.

  6. #6
    Join Date
    Jan 2006
    Posts
    4
    I am using spfile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •