OraFAQ Forum: Backup & Recovery » RMAN command hang long time

Home » RDBMS Server » Backup & Recovery » RMAN command hang long time (Oracle 11g release 2 ,linux (x64))

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

RMAN command hang long time [message #548085]

Tue, 20 March 2012 05:07

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Dear All,

We would take backup regulary by RMAN(catalog). Last two days we could not take backup. Backup start but after take backup some datafile then rman does not do anything.

please help

Report message to a moderator

Re: RMAN command hang long time [message #548087 is a reply to message #548085]

Tue, 20 March 2012 05:17

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

My RMAN script & output ,there is no error at alert log file

---------------------------
RMAN> run
2> {
3> allocate channel Channel1 type disk ;
4> allocate channel Channel2 type disk ;
5> allocate channel Channel3 type disk ;
6> backup as compressed backupset format '/oracle/database/backuptwo/Full_****_%T_%s'( database include current contro
lfile );
7> }

allocated channel: Channel1
channel Channel1: SID=199 device type=DISK

allocated channel: Channel2
channel Channel2: SID=601 device type=DISK

allocated channel: Channel3
channel Channel3: SID=1377 device type=DISK

Starting backup at 20-MAR-12
channel Channel1: starting compressed full datafile backup set
channel Channel1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/database/oradata/****/system01.dbf
input datafile file number=00002 name=/oracle/database/oradata/****/sysaux01.dbf
input datafile file number=00009 name=/oracle/database/oradata/****/system02.dbf
channel Channel1: starting piece 1 at 20-MAR-12
channel Channel2: starting compressed full datafile backup set
channel Channel2: specifying datafile(s) in backup set
input datafile file number=00004 name=/oracle/database/oradata/****/a4m01.dbf
input datafile file number=00003 name=/oracle/database/oradata/****/undotbs01.dbf
input datafile file number=00007 name=/oracle/database/oradata/****/a4m04.dbf
channel Channel2: starting piece 1 at 20-MAR-12
channel Channel3: starting compressed full datafile backup set
channel Channel3: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/database/oradata/****/a4m02.dbf
input datafile file number=00006 name=/oracle/database/oradata/****/a4m03.dbf
input datafile file number=00008 name=/oracle/database/oradata/****/a4m05.dbf
channel Channel3: starting piece 1 at 20-MAR-12
channel Channel2: finished piece 1 at 20-MAR-12
piece handle=/oracle/database/backuptwo/Full_****_20120320_4080 tag=TAG20120320T153728 comment=NONE
channel Channel2: backup set complete, elapsed time: 00:09:06
channel Channel2: starting compressed full datafile backup set
channel Channel2: specifying datafile(s) in backup set
including current control file in backup set
channel Channel2: starting piece 1 at 20-MAR-12
channel Channel2: finished piece 1 at 20-MAR-12
piece handle=/oracle/database/backuptwo/Full_****_20120320_4082 tag=TAG20120320T153728 comment=NONE
channel Channel2: backup set complete, elapsed time: 00:00:01
- (cursor blinking)

please help me

Report message to a moderator

Re: RMAN command hang long time [message #548093 is a reply to message #548087]

Tue, 20 March 2012 05:42

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

truss/tusc the RMAN process to know what they do.
Watch IO on the target disks (and source ones).

Regards
Michel

Report message to a moderator

Re: RMAN command hang long time [message #548100 is a reply to message #548093]

Tue, 20 March 2012 05:54

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Thanks .
please explain "russ/tusc the RMAN process to know what they do.", I could not understand.
how can I watch IO on the target disks (and source ones).

Regards
mirasraf

Report message to a moderator

Re: RMAN command hang long time [message #548106 is a reply to message #548100]

Tue, 20 March 2012 07:04

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have you a sysadmin or are you the sysadmin of the server?

Regards
Michel

Report message to a moderator

Previous Topic:	Incermental backup taking too long to complete
Next Topic:	RMAN duplicate Database Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 07:09:50 CDT 2023