Home » RDBMS Server » Backup & Recovery » Archiver Stuck (Suse Enterprise 10 , Oracle 11G)
Archiver Stuck [message #541003] Fri, 27 January 2012 01:34 Go to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
Hi gurus,

i get the attached error log when i try to take online full backup. Harddrive has enough space and archive log and datafiles mounted on "/opt". Permissions are ok. Any idea?

Filesystem Size Used Avail Use% Mounted on
/dev/sda1 104G 69G 30G 70% /
udev 35G 786M 35G 3% /dev
/dev/sdb1 1.1T 145G 899G 14% /opt



ERRORE LOG

BR0202I Saving /oracle/V01/112_64/dbs/initV01.sap
BR0203I to /opt/oracle/backup/V01 ...

BR0280I BRBACKUP time stamp: 2012-01-26 19.21.46
BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2012-01-26 19.21.46
BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0201I Compressing /opt/oracle/sapdata2/sr3_1/sr3.data1
BR0203I to /opt/oracle/backup/behtetcm/sr3.data1.Z ...

#FILE..... /opt/oracle/sapdata2/sr3_1/sr3.data1
#SAVED.... /opt/oracle/backup/behtetcm/sr3.data1.Z #1/1 9.1064:1 1151471267

BR0280I BRBACKUP time stamp: 2012-01-26 19.25.41
BR0063I 1 of 9 files processed - 10000.008 of 66804.953 MB done
BR0204I Percentage done: 14.97%, estimated end time: 19:47
BR0001I *******___________________________________________

BR0201I Compressing /opt/oracle/sapdata2/sr3_2/sr3.data2
BR0203I to /opt/oracle/backup/behtetcm/sr3.data2.Z ...

#FILE..... /opt/oracle/sapdata2/sr3_2/sr3.data2
#SAVED.... /opt/oracle/backup/behtetcm/sr3.data2.Z #1/2 82.3164:1 254767420

BR0280I BRBACKUP time stamp: 2012-01-26 19.29.02
BR0063I 2 of 9 files processed - 30000.016 of 66804.953 MB done
BR0204I Percentage done: 44.91%, estimated end time: 19:37
BR0001I **********************____________________________
BR0280I BRBACKUP time stamp: 2012-01-26 19.29.02
BR0301E SQL error -257 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-00257: archiver error. Connect internal only, until freed.
BR0310E Connect to database instance V01 failed
BR0311E Connect to database instance V01 during online backup failed

BR0115I Compression rate for all files 22.3698:1
BR0280I BRBACKUP time stamp: 2012-01-26 19.29.04
BR0301E SQL error -257 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-00257: archiver error. Connect internal only, until freed.
BR0310E Connect to database instance V01 failed

BR0056I End of database backup: behtetcm.and 2012-01-26 19.29.02
BR0280I BRBACKUP time stamp: 2012-01-26 19.29.04
BR0054I BRBACKUP terminated with errors

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 5

BR0280I BRTOOLS time stamp: 2012-01-26 19.29.04
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2012-01-26 20.04.06
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2012-01-26 20.04.06
  • Attachment: Hata.txt
    (Size: 2.52KB, Downloaded 469 times)
Re: Archiver Stuck [message #541008 is a reply to message #541003] Fri, 27 January 2012 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle does not agree with you.
There is no room in one archive destination (not backup destination).

Regards
Michel
Re: Archiver Stuck [message #541015 is a reply to message #541008] Fri, 27 January 2012 01:55 Go to previous messageGo to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /opt/oracle/oraflash
db_recovery_file_dest_size big integer 30000M

there is enough space on "/opt/" . I don't understand problem.
Re: Archiver Stuck [message #541016 is a reply to message #541015] Fri, 27 January 2012 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter archive

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.


Regards
Michel
Re: Archiver Stuck [message #541017 is a reply to message #541016] Fri, 27 January 2012 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also
show parameter audit

Regards
Michel
Re: Archiver Stuck [message #541019 is a reply to message #541017] Fri, 27 January 2012 02:01 Go to previous messageGo to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
SQL> show parameter archive

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string /opt/oracle/archivelog/V01arch
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
standby_archive_dest string ?/dbs/arch

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

SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /oracle/V01/saptrace/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string NONE
Re: Archiver Stuck [message #541024 is a reply to message #541019] Fri, 27 January 2012 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 27 January 2012 08:57
show parameter archive

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.


Regards
Michel

Re: Archiver Stuck [message #541028 is a reply to message #541024] Fri, 27 January 2012 02:40 Go to previous messageGo to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
I can't see any problem in this log. If you have problem in this log, could you explain?
Thnx.

SQL> show parameter archive

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string /opt/oracle/archivelog/V01arch
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
standby_archive_dest string ?/dbs/arch
Re: Archiver Stuck [message #541030 is a reply to message #541028] Fri, 27 January 2012 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 27 January 2012 09:27
Michel Cadot wrote on Fri, 27 January 2012 08:57
show parameter archive

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.


Regards
Michel


Re: Archiver Stuck [message #541055 is a reply to message #541030] Fri, 27 January 2012 05:58 Go to previous messageGo to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
Is this correct?

SQL> show parameter archive

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string /opt/oracle/archivelog/V01arch
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
standby_archive_dest string ?/dbs/arch

Re: Archiver Stuck [message #541058 is a reply to message #541055] Fri, 27 January 2012 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
Missed: align the columns in result.

Regards
Michel

Re: Archiver Stuck [message #541097 is a reply to message #541058] Fri, 27 January 2012 09:44 Go to previous messageGo to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
this ?

SQL> show parameter archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string      /opt/oracle/archivelog/V01arch
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
log_archive_dest_24                  string
log_archive_dest_25                  string
log_archive_dest_26                  string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_27                  string
log_archive_dest_28                  string
log_archive_dest_29                  string
log_archive_dest_3                   string
log_archive_dest_30                  string
log_archive_dest_31                  string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_11            string      enable
log_archive_dest_state_12            string      enable
log_archive_dest_state_13            string      enable
log_archive_dest_state_14            string      enable
log_archive_dest_state_15            string      enable
log_archive_dest_state_16            string      enable
log_archive_dest_state_17            string      enable
log_archive_dest_state_18            string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_19            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_20            string      enable
log_archive_dest_state_21            string      enable
log_archive_dest_state_22            string      enable
log_archive_dest_state_23            string      enable
log_archive_dest_state_24            string      enable
log_archive_dest_state_25            string      enable
log_archive_dest_state_26            string      enable
log_archive_dest_state_27            string      enable
log_archive_dest_state_28            string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_29            string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_30            string      enable
log_archive_dest_state_31            string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      %t_%s_%r.dbf
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     4
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
standby_archive_dest                 string      ?/dbs/arch


any solution?
Re: Archiver Stuck [message #541098 is a reply to message #541097] Fri, 27 January 2012 09:55 Go to previous messageGo to next message
BlackSwan
Messages: 26183
Registered: January 2009
Location: SoCal
Senior Member
post formatted results like below
bcm@bcm-laptop:~$ df -k
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda1            230582428  68803116 150066340  32% /
none                   1894020       308   1893712   1% /dev
none                   1898548    981604    916944  52% /dev/shm
none                   1898548        96   1898452   1% /var/run
none                   1898548         0   1898548   0% /var/lock
none                   1898548         0   1898548   0% /lib/init/rw
Re: Archiver Stuck [message #541099 is a reply to message #541097] Fri, 27 January 2012 09:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet this one full:
log_archive_dest                     string      /opt/oracle/archivelog/V01arch


Regards
Michel
Re: Archiver Stuck [message #541103 is a reply to message #541099] Fri, 27 January 2012 10:08 Go to previous messageGo to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
pandora:v01adm 11> df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             104G   69G   30G  70% /
udev                   35G  786M   35G   3% /dev
/dev/sdb1             1.1T  145G  899G  14% /opt
Re: Archiver Stuck [message #541149 is a reply to message #541103] Sat, 28 January 2012 02:41 Go to previous messageGo to next message
xeeq
Messages: 8
Registered: January 2012
Location: Turkey
Junior Member
Oracle couldn't create the archive log files , but already have free space in /opt/.
I don't understand the problem.

If archivelogoff , everything is ok.
Re: Archiver Stuck [message #542343 is a reply to message #541149] Mon, 06 February 2012 13:55 Go to previous message
mjpalm
Messages: 1
Registered: June 2011
Location: Sioux Falls, SD
Junior Member
/opt/oracle/archivelog/V01arch is not necessarily the same mountpoint as /opt. A good sysadmin would have separate mountpoints for archivelogs, my guess is there is a separate mountpoint.
Previous Topic: Backup archive log file using RMAN
Next Topic: NETAPP and Oracle DR
Goto Forum:
  


Current Time: Mon Oct 15 20:32:11 CDT 2018