1 2 Previous Next 16 Replies Latest reply on Apr 19, 2012 8:24 AM by Uwehesse-Oracle Go to original post
      • 15. Re: Oracle Database Backup
        C:\>sqlplus / as sysdba

        SQL*Plus: Release - Production on Thu Apr 19 11:50:55 2012

        Copyright (c) 1982, 2004, Oracle. All rights reserved.

        Connected to:
        Oracle Database 10g Enterprise Edition Release - Production
        With the Partitioning, OLAP and Data Mining options
        • 16. Re: Oracle Database Backup
          That's good news!
          Now look at the instance to be sure you got the right one:
          select * from v$instance;
          Give a password to sys:
          alter user sys identified by <yourpassword>;
          select * from v$pwfile_users;
          You should see an entry for sys in the last view.
          Now look whether there is a recovery area specified:
          show parameter recovery_area
          What do you see?

          Kind regards
          Uwe Hesse

          "Don't believe it, test it!"
          1 2 Previous Next