1 2 Previous Next 26 Replies Latest reply: Aug 2, 2009 6:00 AM by 608424 Go to original post RSS
      • 15. Re: How to recover my database using hot backup?
        Hussein Sawwan-Oracle
        SG,

        Could you please verify the value of the following parameters?

        log_archive_format
        log_archive_max_processes
        log_archive_min_succeed_dest
        log_archive_start

        Regards,
        Hussein
        • 16. Re: How to recover my database using hot backup?
          SG2
          Dear Sawwan,

          kindly check the last action plan result.

          SQL> show parameter log_archive_format

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_format string %%ORACLE_SID%%S%T%R.ARC

          SQL> show parameter log_archive_max_processes

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_max_processes integer 2

          SQL> show parameter log_archive_min_succeed_dest

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_min_succeed_dest integer 1

          SQL> show parameter log_archive_start

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          log_archive_start boolean FALSE
          SQL>

          Regards,
          SG
          • 17. Re: How to recover my database using hot backup?
            Hussein Sawwan-Oracle
            SG,

            Please see if (Note: 1023517.6 - ARCHIVE FILES ARE NOT GOING TO LOG_ARCHIVE_DEST) helps.

            Regards,
            Hussein
            • 18. Re: How to recover my database using hot backup?
              SG2
              Dear Sawwan,

              I followed the above note 1023517.6, still the archive files are not generating.

              Best Regards,
              SG
              • 19. Re: How to recover my database using hot backup?
                Hussein Sawwan-Oracle
                SG,

                Did you try to disable archiving and enable it again?

                Regards,
                Hussein
                • 20. Re: How to recover my database using hot backup?
                  SG2
                  Dear Sawwan,

                  I disabled and enabled the archive log still it is not creating any archive files.

                  SQL> startup mount
                  ORACLE instance started.

                  Total System Global Area 599785472 bytes
                  Fixed Size 1250356 bytes
                  Variable Size 167775180 bytes
                  Database Buffers 423624704 bytes
                  Redo Buffers 7135232 bytes
                  Database mounted.
                  SQL> alter database noarchivelog;

                  Database altered.

                  SQL> alter database open;

                  Database altered.

                  SQL> archive log list;
                  Database log mode No Archive Mode
                  Automatic archival Disabled
                  Archive destination C:\oracle\product\10.2.0\OraHome10\database\arc
                  ve\
                  Oldest online log sequence 24
                  Current log sequence 26
                  SQL> shutdown immediate
                  Database closed.
                  Database dismounted.
                  ORACLE instance shut down.
                  SQL> startup mount pfile='C:\oracle\product\10.2.0\admin\db1\pfile\init.ora'
                  ORACLE instance started.

                  Total System Global Area 599785472 bytes
                  Fixed Size 1250356 bytes
                  Variable Size 163580876 bytes
                  Database Buffers 427819008 bytes
                  Redo Buffers 7135232 bytes
                  Database mounted.
                  SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

                  LOG_MODE
                  ------------
                  NOARCHIVELOG

                  SQL> alter database archivelog;

                  Database altered.

                  SQL> alter database open;

                  Database altered.

                  SQL> archive log list;
                  Database log mode Archive Mode
                  Automatic archival Enabled
                  Archive destination C:\oracle\product\10.2.0\OraHome10\database\archi
                  ve\
                  Oldest online log sequence 24
                  Next log sequence to archive 26
                  Current log sequence 26
                  SQL>


                  Best Regards,
                  SG
                  • 21. Re: How to recover my database using hot backup?
                    SG2
                    Dear Sawwan,

                    My alert log file is showing Archival stopped why it is like that? Please check the alert log bellow.


                    Completed: ALTER DATABASE MOUNT
                    Sun Aug 02 11:12:26 2009
                    alter database archivelog
                    Sun Aug 02 11:12:26 2009
                    Completed: alter database archivelog
                    Sun Aug 02 11:12:34 2009
                    alter database open
                    Sun Aug 02 11:12:35 2009
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=15, OS id=5408
                    Sun Aug 02 11:12:35 2009
                    ARC0: Archival started
                    Sun Aug 02 11:12:35 2009
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    Thread 1 opened at log sequence 26
                    Current log# 1 seq# 26 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB1\REDO01.LOG
                    Successful open of redo thread 1
                    Sun Aug 02 11:12:35 2009
                    MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
                    Sun Aug 02 11:12:35 2009
                    ARC0: STARTING ARCH PROCESSES
                    ARC2: Archival started
                    Sun Aug 02 11:12:35 2009
                    ARC0: STARTING ARCH PROCESSES COMPLETE
                    ARC0: Becoming the 'no FAL' ARCH
                    ARC0: Becoming the 'no SRL' ARCH
                    ARC1 started with pid=17, OS id=4568
                    Sun Aug 02 11:12:36 2009
                    ARC1: Becoming the heartbeat ARCH
                    Sun Aug 02 11:12:36 2009
                    Successfully onlined Undo Tablespace 1.
                    Sun Aug 02 11:12:36 2009
                    SMON: enabling cache recovery
                    Sun Aug 02 11:12:36 2009
                    SMON: enabling tx recovery
                    Sun Aug 02 11:12:36 2009
                    Database Characterset is WE8MSWIN1252
                    ARC2 started with pid=18, OS id=4492
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=19, OS id=4240
                    Sun Aug 02 11:12:42 2009
                    db_recovery_file_dest_size of 2048 MB is 29.85% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Sun Aug 02 11:12:43 2009
                    Completed: alter database open
                    Sun Aug 02 11:18:36 2009
                    Shutting down archive processes
                    Sun Aug 02 11:18:41 2009
                    ARCH shutting down
                    ARC2: Archival stopped



                    ========================
                    SQL> select name,log_mode from v$database;

                    NAME LOG_MODE
                    --------- ------------
                    DB1 ARCHIVELOG

                    SQL> select archiver from v$instance;

                    ARCHIVE
                    -------
                    STARTED

                    SQL> show parameter log_archive_max_processes

                    NAME TYPE VALUE
                    ------------------------------------ ----------- ----------------------
                    log_archive_max_processes integer 2
                    SQL>

                    Best Regards,
                    SG
                    • 22. Re: How to recover my database using hot backup?
                      608424
                      Hi SG,
                      I disabled and enabled the archive log still it is not creating any archive files.
                      Do some manual switching of archive logs,

                      SQL> alter system switch logfile;+

                      And check if they create any archives. Also, please let check the o/p of the query,
                      SQL> Select NAME, CREATED, LOG_MODE, CHECKPOINT_CHANGE#,
                      ARCHIVE_CHANGE# from V$DATABASE
                      Thanks,
                      Anchorage :)
                      • 23. Re: How to recover my database using hot backup?
                        SG2
                        Dear Anchorage,

                        Still it is not created any archive files.

                        Best Regards,
                        SG
                        • 24. Re: How to recover my database using hot backup?
                          608424
                          SG,

                          Can you provide the query o/p.

                          Thanks,
                          Anchorage :)
                          • 25. Re: How to recover my database using hot backup?
                            SG2
                            Dear Anchorage,

                            Here is the query output. It is showing the 21st July but not todays date.

                            SQL> alter system switch logfile;

                            System altered.

                            SQL> Select NAME, CREATED, LOG_MODE, CHECKPOINT_CHANGE#,
                            2 ARCHIVE_CHANGE# from V$DATABASE;

                            NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#
                            --------- --------- ------------ ------------------ ---------------
                            DB1 21-JUL-09 ARCHIVELOG 967136 967131

                            SQL>

                            Best Regards,
                            SG
                            • 26. Re: How to recover my database using hot backup?
                              608424
                              SG,

                              Is your database is in use? Try to manually switch the archive logs 10/20 times and see if any archive is generating.

                              If that's not the case I would rather suggest you to log an SR.

                              Thanks,
                              Anchorage :)
                              1 2 Previous Next