Home » RDBMS Server » Backup & Recovery » RMAN command hang long time (Oracle 11g release 2 ,linux (x64))
RMAN command hang long time [message #548085] Tue, 20 March 2012 05:07 Go to next message
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
Re: RMAN command hang long time [message #548087 is a reply to message #548085] Tue, 20 March 2012 05:17 Go to previous messageGo to next message
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
Re: RMAN command hang long time [message #548093 is a reply to message #548087] Tue, 20 March 2012 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
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
Re: RMAN command hang long time [message #548100 is a reply to message #548093] Tue, 20 March 2012 05:54 Go to previous messageGo to next message
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
Re: RMAN command hang long time [message #548106 is a reply to message #548100] Tue, 20 March 2012 07:04 Go to previous message
Michel Cadot
Messages: 65385
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

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


Current Time: Tue Feb 20 02:16:34 CST 2018

Total time taken to generate the page: 0.02979 seconds