OraFAQ Forum: Backup & Recovery » Oracle 9i Backup getting stuck

Home » RDBMS Server » Backup & Recovery » Oracle 9i Backup getting stuck

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i Backup getting stuck [message #219287]

Tue, 13 February 2007 19:34

Ista
Messages: 14
Registered: January 2007

Junior Member

Greetings to all,

We have been using the following rman script to perform our 9.2.0.3 database backups for a couple of years.
Today, we noticed that the backup always gets stuck when trying to execute this script.
I have listed the rman script and part of the alert_CEMSDB.log.
I have noticed that there is a gap in the alert log between Mon Feb 12 10:11:25 2007
and Tue Feb 13 01:31:57 2007.
The last succesful backup was performed on Feb 12 @ 6:00 AM.
One of the failed backups was attempted @Tue Feb 13 12:39:23 2007 (details below).
I have also noticed below some complaints about being unable to archive.
If I do a ps -ef | grep ora I see the rman processes there sitting idle.

Any idea on why it is happening and how to solve this issue.

Thanks.

run {
ALLOCATE CHANNEL C1 TYPE DISK;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP INCREMENTAL LEVEL=0 CUMULATIVE format '$dir/level0' DATABASE include current controlfile for standby FORCE;
BACKUP CURRENT CONTROLFILE format '$dir/control_primary' FORCE;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP ARCHIVELOG ALL format '$dir/archivelogs_%s_%t';
}
EXIT;

Mon Feb 12 10:05:31 2007
Thread 1 advanced to log sequence 3593
Current log# 3 seq# 3593 mem# 0: /opt/app/db/oracle/u02/oradata/APPDB/redo3_1.log
Current log# 3 seq# 3593 mem# 1: /opt/app/db/oracle/u03/oradata/APPDB/redo3_2.log
Mon Feb 12 10:05:31 2007
ARC1: Evaluating archive log 1 thread 1 sequence 3592
ARC1: Beginning to archive log 1 thread 1 sequence 3592
Creating archive destination LOG_ARCHIVE_DEST_2: 'redundant_host'
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/app/db/oracle/u06/oradata/APPDB/1_3592.dbf'
ARC1: Completed archiving log 1 thread 1 sequence 3592
Mon Feb 12 10:06:39 2007
ARC0: Evaluating archive log 3 thread 1 sequence 3593
Mon Feb 12 10:06:39 2007
Thread 1 advanced to log sequence 3594
Current log# 2 seq# 3594 mem# 0: /opt/app/db/oracle/u02/oradata/APPDB/redo2_1.log
Current log# 2 seq# 3594 mem# 1: /opt/app/db/oracle/u03/oradata/APPDB/redo2_2.log
Mon Feb 12 10:06:39 2007
ARC0: Beginning to archive log 3 thread 1 sequence 3593
Creating archive destination LOG_ARCHIVE_DEST_2: 'redundant_host'
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/app/db/oracle/u06/oradata/APPDB/1_3593.dbf'
Mon Feb 12 10:11:23 2007
ARCH: Evaluating archive log 3 thread 1 sequence 3593
ARCH: Unable to archive log 3 thread 1 sequence 3593
Log actively being archived by another process
Mon Feb 12 10:11:25 2007
Thread 1 advanced to log sequence 3595
Current log# 1 seq# 3595 mem# 0: /opt/app/db/oracle/u02/oradata/APPDB/redo1_1.log
Current log# 1 seq# 3595 mem# 1: /opt/app/db/oracle/u03/oradata/APPDB/redo1_2.log
Tue Feb 13 01:31:57 2007
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Tue Feb 13 01:31:58 2007
Created Undo Segment _SYSSMU12$
Undo Segment 12 Onlined
Tue Feb 13 01:31:58 2007
Created Undo Segment _SYSSMU12$
Undo Segment 12 Onlined
Tue Feb 13 01:31:59 2007
Created Undo Segment _SYSSMU13$
Undo Segment 13 Onlined
Created Undo Segment _SYSSMU14$
Undo Segment 14 Onlined
Tue Feb 13 01:32:00 2007
Created Undo Segment _SYSSMU15$
Undo Segment 15 Onlined
Tue Feb 13 01:32:00 2007
Created Undo Segment _SYSSMU16$
Tue Feb 13 01:32:00 2007
Undo Segment 16 Onlined
Tue Feb 13 01:32:00 2007
Created Undo Segment _SYSSMU17$
Undo Segment 17 Onlined
Tue Feb 13 01:32:00 2007
Created Undo Segment _SYSSMU18$
Undo Segment 18 Onlined
Tue Feb 13 01:32:10 2007
Created Undo Segment _SYSSMU19$
Undo Segment 19 Onlined
Tue Feb 13 01:32:16 2007
Created Undo Segment _SYSSMU20$
Undo Segment 20 Onlined
Tue Feb 13 01:32:16 2007
Created Undo Segment _SYSSMU21$
Tue Feb 13 01:32:16 2007
Undo Segment 21 Onlined
Tue Feb 13 01:32:16 2007
Created Undo Segment _SYSSMU22$
Tue Feb 13 01:32:16 2007
Undo Segment 22 Onlined
Tue Feb 13 01:32:16 2007
Created Undo Segment _SYSSMU23$
Undo Segment 23 Onlined
ue Feb 13 01:32:16 2007
Created Undo Segment _SYSSMU24$
Undo Segment 24 Onlined
Tue Feb 13 01:32:16 2007
Created Undo Segment _SYSSMU25$
Undo Segment 25 Onlined
Tue Feb 13 01:34:58 2007
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
SMON offlining US=16
SMON offlining US=17
SMON offlining US=18
SMON offlining US=19
SMON offlining US=20
SMON offlining US=21
SMON offlining US=22
SMON offlining US=23
SMON offlining US=24
SMON offlining US=25
Tue Feb 13 01:39:11 2007
Undo Segment 11 Onlined
Tue Feb 13 01:39:19 2007
Undo Segment 12 Onlined
Tue Feb 13 01:39:19 2007
Undo Segment 13 Onlined
Tue Feb 13 01:39:19 2007
Undo Segment 14 Onlined
Tue Feb 13 01:39:19 2007
Undo Segment 15 Onlined
Tue Feb 13 01:39:32 2007
Undo Segment 16 Onlined
Tue Feb 13 01:39:32 2007
Undo Segment 17 Onlined
Tue Feb 13 01:39:32 2007
Undo Segment 18 Onlined
Tue Feb 13 01:39:34 2007
Undo Segment 19 Onlined
Tue Feb 13 01:39:34 2007
Undo Segment 20 Onlined
Tue Feb 13 01:39:34 2007
Undo Segment 21 Onlined
Tue Feb 13 01:39:34 2007
Undo Segment 22 Onlined
Tue Feb 13 01:39:35 2007
Undo Segment 23 Onlined
Tue Feb 13 01:39:35 2007
Undo Segment 24 Onlined
Undo Segment 25 Onlined
Tue Feb 13 01:39:36 2007
Created Undo Segment _SYSSMU26$
Undo Segment 26 Onlined
Tue Feb 13 12:39:23 2007
ARCH: Evaluating archive log 3 thread 1 sequence 3593
ARCH: Unable to archive log 3 thread 1 sequence 3593
Log actively being archived by another process
ARCH: Evaluating archive log 2 thread 1 sequence 3594
ARCH: Beginning to archive log 2 thread 1 sequence 3594
Creating archive destination LOG_ARCHIVE_DEST_2: 'redundant_host'
Tue Feb 13 12:48:42 2007
ARCH: Evaluating archive log 3 thread 1 sequence 3593
ARCH: Unable to archive log 3 thread 1 sequence 3593
Log actively being archived by another process
ARCH: Evaluating archive log 2 thread 1 sequence 3594
ARCH: Unable to archive log 2 thread 1 sequence 3594
Log actively being archived by another process
Tue Feb 13 13:36:42 2007
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
SMON offlining US=16
SMON offlining US=17
SMON offlining US=18
SMON offlining US=19
SMON offlining US=20
SMON offlining US=21
SMON offlining US=22
SMON offlining US=23
SMON offlining US=24
SMON offlining US=25
SMON offlining US=26
Tue Feb 13 14:08:43 2007
ARCH: Evaluating archive log 3 thread 1 sequence 3593
ARCH: Unable to archive log 3 thread 1 sequence 3593
Log actively being archived by another process
ARCH: Evaluating archive log 2 thread 1 sequence 3594
ARCH: Unable to archive log 2 thread 1 sequence 3594
Log actively being archived by another process
Tue Feb 13 14:17:34 2007
ARCH: Evaluating archive log 3 thread 1 sequence 3593
ARCH: Unable to archive log 3 thread 1 sequence 3593
Log actively being archived by another process
ARCH: Evaluating archive log 2 thread 1 sequence 3594
ARCH: Beginning to archive log 2 thread 1 sequence 3594
Creating archive destination LOG_ARCHIVE_DEST_2: 'redundant_host'
ARCH: Evaluating archive log 3 thread 1 sequence 3593
ARCH: Unable to archive log 3 thread 1 sequence 3593
Log actively being archived by another process
ARCH: Evaluating archive log 2 thread 1 sequence 3594
ARCH: Beginning to archive log 2 thread 1 sequence 3594
Creating archive destination LOG_ARCHIVE_DEST_2: 'redundant_host'

Report message to a moderator

Re: Oracle 9i Backup getting stuck [message #219696 is a reply to message #219287]

Thu, 15 February 2007 10:15

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Less usefull information for any possible troubleshooting.
Check v$session_longops/v$backup_async_io/v$backup_sync_io etc to see where exactly RMAN is stalling.

Report message to a moderator

Previous Topic:	Oracle 9i - Cannot delete Archived Redolog files
Next Topic:	rman repository and duplicate DBID's

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:36:42 CST 2024