Home » RDBMS Server » Backup & Recovery » RMAN backup cant start (Oracle, 10.2.0.1, CentOS 4 i386)
RMAN backup cant start [message #313279] Fri, 11 April 2008 05:26 Go to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
Hello,

I have problem with rman full db backup, cronjob starts backup script, but output just says channel db_fullback_disk1: starting piece 1 and no ending...

Starting backup at 11.04.08
channel db_fullback_disk1: starting full datafile backupset
channel db_fullback_disk1: specifying datafile(s) in backupset
input datafile fno=00002 name=/u01/app/oracle/oradata/<sid>/undotbs01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/<sid>/sysaux01.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/<sid>/system01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/<sid>/USER1_LOB.dbf
input datafile fno=00009 name=/u01/app/oracle/oradata/<sid>/USER2_LOB.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/<sid>/USER2_DATA.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/<sid>/USER1_DATA.dbf
input datafile fno=00010 name=/u02/oradata/<sid>/USER2_INDEX.dbf
input datafile fno=00007 name=/u02/oradata/<sid>/USER1_INDEX.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/<sid>/users01.dbf
channel db_fullback_disk1: starting piece 1 at 11.04.08


I notice also too many inactive rman sessions.
is there some known bug affecting version 10.2.0.1?
Backup media is disk, oracle version 10.2.0.1 standard, os is linux CentOS 4

rman command:

run{
allocate channel db_fullback_disk1 type disk
format '/mnt/backup/rmanbackup/%U';
backup database;
release channel db_fullback_disk1;
restore database validate;
delete noprompt obsolete;
}

Thanks in advance!
Nikola
Re: RMAN backup cant start [message #313282 is a reply to message #313279] Fri, 11 April 2008 05:36 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

how big is the database?
how long have you left rman before stopping it?

Have you tried to run the rman script from the rman prompt and not through cron?

regards

Alan

[Updated on: Fri, 11 April 2008 05:46]

Report message to a moderator

Re: RMAN backup cant start [message #313284 is a reply to message #313279] Fri, 11 April 2008 05:43 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
user datafiles are not so big approximately 0.5GB
undotablespace is 8GB and sysaux 4GB

last time i wait 5hour and before that 24h Smile
Re: RMAN backup cant start [message #313287 is a reply to message #313279] Fri, 11 April 2008 05:47 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

can you run the rman script from the rman prompt?
What does this give you?

thanks

Alan
Re: RMAN backup cant start [message #313295 is a reply to message #313279] Fri, 11 April 2008 06:00 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
same output,
i'm little bit confused there was no changes in configuration and everything goes smut until now... Smile

regards,
Nikola
Re: RMAN backup cant start [message #313297 is a reply to message #313279] Fri, 11 April 2008 06:03 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
You can view v$session,v$session_wait to see what it is waiting for
Re: RMAN backup cant start [message #313310 is a reply to message #313295] Fri, 11 April 2008 06:29 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

Hi,
Can you check your alert log file to see if there are any errors reported whilst you are doing the rman backup.

Are you carrying this out with a recovery catalog or with the controlfile?

Dou you sufficient disk space available to you for the backup?

regards

Alan
Re: RMAN backup cant start [message #313314 is a reply to message #313279] Fri, 11 April 2008 06:36 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
Hi,

alert.log is empty, backup is done with controlfile also disk space is not problem...

I notice one more thing, rman create backup file and stops at exactly 88K every time.

Also i didn't mention backup disk is mounted ntfs drive but drive was first that i checked.

[Updated on: Fri, 11 April 2008 06:40]

Report message to a moderator

Re: RMAN backup cant start [message #313323 is a reply to message #313279] Fri, 11 April 2008 06:55 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

ok well it could be that the mount options are not correct and maybe need changing.

can you post back the options you set for the drive?

regards

Alan
Re: RMAN backup cant start [message #313324 is a reply to message #313279] Fri, 11 April 2008 06:59 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
Here are mount options:

server.domain:/mounts-1/10g /mnt/backup nfs rw,noac,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsvers=3,tcp 0 0

But there was no changes in mount option for a long time.

Regards,
Nikola
Re: RMAN backup cant start [message #313333 is a reply to message #313279] Fri, 11 April 2008 07:07 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
In sessions i can see last SQL:

SELECT action
FROM gv$session
WHERE sid = :1
AND serial# = :2
AND inst_id = :3

i suppose it hangs here.
Re: RMAN backup cant start [message #313334 is a reply to message #313324] Fri, 11 April 2008 07:08 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

could you try the following,

create a datafile on the drive

SQL> create tablespace test1 datafile 'your_drive\test1.dbf' size 100m;

and let me know what happens
Re: RMAN backup cant start [message #313338 is a reply to message #313279] Fri, 11 April 2008 07:18 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
huh,

Like i have some bigger problem,
it creates datafile 101MB but comman in sqlplus wont ends Confused i cant see tablespace created message...

any idea?

Regards,
Nikola
Re: RMAN backup cant start [message #313347 is a reply to message #313338] Fri, 11 April 2008 08:06 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
all that did was confirm that oracle could write to the drive. you can drop the tablespace.

ok so from an rman prompt can you report anything from any backups that you have taken

report obsolete
list backup

etc etc

regards

Alan
Re: RMAN backup cant start [message #313350 is a reply to message #313347] Fri, 11 April 2008 08:16 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
Hi Alan,

Thanks for assistance, problem is solved... i just recreate temp teblespace and after that all worked just fine.

Strange thing is it was not full...

Kind Regards,
Nikola
Re: RMAN backup cant start [message #313352 is a reply to message #313350] Fri, 11 April 2008 08:23 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
have you recently then restored your database from backup?

the temp tablespace is not backed up and has to be created seperately

rergards

Alan
Re: RMAN backup cant start [message #313357 is a reply to message #313279] Fri, 11 April 2008 08:32 Go to previous messageGo to next message
Nikola
Messages: 9
Registered: April 2008
Junior Member
hi,

there was no restore recently, db was more then stable Smile

Regards,
Nikola
Re: RMAN backup cant start [message #313363 is a reply to message #313357] Fri, 11 April 2008 08:50 Go to previous message
alanm
Messages: 282
Registered: March 2005
Senior Member

ok, well as long as it works, that is great
Previous Topic: Standby in R/W mode with Flashback
Next Topic: Problem connecting to the target using RMAN
Goto Forum:
  


Current Time: Mon Dec 05 11:21:24 CST 2016

Total time taken to generate the page: 0.04998 seconds