4 Replies Latest reply: Apr 6, 2013 9:02 AM by Seberg RSS

    rman

    975449
      hai all
      version 10.2.0.

      I am trying to take back up of archive logs on my database


      rman target /
      RMAN> backup archivelog all;

      Starting backup at 06-APR-13
      using channel ORA_DISK_1
      specification does not match any archive log in the recovery catalog
      backup cancelled because all files were skipped
      Finished backup at 06-APR-13

      rman>exit
      sqlplus / as sysdba
      alter system switch logfile when ever i fire this command its is hanging like in this
      way
      sql>alter system switch logfile;



      then i typed ctrl+c
      _______________

      how to over come this situation
      my database is in archive log mode

      SQL> archive log list;
      Database log mode Archive Mode
      Automatic archival Enabled
      Archive destination /u01/app/oracle/product/10.2.0/db_1/oradata/data/arch/
      Oldest online log sequence 10
      Next log sequence to archive 10
      Current log sequence 12
        • 1. Re: rman
          mseberg
          Hello;

          Check to make sure this exists :
           /u01/app/oracle/product/10.2.0/db_1/oradata/data/arch/
          If yes check the permissions to write to it and available space on the mount point.

          Also this version 10.2.0. is incomplete, you are missing a number. Use v$version to collect correct information.

          Try reading this before you proceed :

          https://wikis.oracle.com/display/Forums/Forums+FAQ

          Best Regards

          mseberg

          Edited by: mseberg on Apr 6, 2013 8:47 AM
          • 2. Re: rman
            asahide
            Hi,

            Could you show us your alert log file ?
            And is your version 10.2.0.x ? what is x ?

            Regards,
            • 3. Re: rman
              975449
              ARCi: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:15 2013
              ARCj: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:18 2013
              ARCk: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:21 2013
              ARCl: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:21 2013
              ARCm: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:24 2013
              ARCn: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:27 2013
              ARCo: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:30 2013
              ARCp: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:33 2013
              ARCq: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:36 2013
              ARCr: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:39 2013
              ARCs: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:42 2013
              ARCt: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:45 2013
              ARC0: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:48 2013
              ARC1: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:51 2013
              ARC2: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:54 2013
              ARC3: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:32:57 2013
              ARC4: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:33:00 2013
              ARC5: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:33:03 2013
              ARC6: Failed to archive thread 1 sequence 10 (19504)
              Sat Apr 6 18:33:06 2013
              Type :quit<Enter> to exit Vim


              AND MY VERSION IS 10.2.0.1.0
              • 4. Re: rman
                Seberg
                With all due respect you are not using the forum very well. Try reading all the replies you get and closing (marking answered) old questions. What you are doing is opening multiple questions on the same topic, a shotgun method.

                How about you slow down and read the forum FAQ?