OraFAQ Forum: Backup & Recovery » RMAN backup cant start

Home » RDBMS Server » Backup & Recovery » RMAN backup cant start (Oracle, 10.2.0.1, CentOS 4 i386)

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

RMAN backup cant start [message #313279]

Fri, 11 April 2008 05:26

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

Report message to a moderator

Re: RMAN backup cant start [message #313282 is a reply to message #313279]

Fri, 11 April 2008 05:36

alanm
Messages: 284
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

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

Smile

Report message to a moderator

Re: RMAN backup cant start [message #313287 is a reply to message #313279]

Fri, 11 April 2008 05:47

alanm
Messages: 284
Registered: March 2005

Senior Member

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

thanks

Alan

Report message to a moderator

Re: RMAN backup cant start [message #313295 is a reply to message #313279]

Fri, 11 April 2008 06:00

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

Smile

regards,
Nikola

Report message to a moderator

Re: RMAN backup cant start [message #313297 is a reply to message #313279]

Fri, 11 April 2008 06:03

varu123
Messages: 754
Registered: October 2007

Senior Member

You can view v$session,v$session_wait to see what it is waiting for

Report message to a moderator

Re: RMAN backup cant start [message #313310 is a reply to message #313295]

Fri, 11 April 2008 06:29

alanm
Messages: 284
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

Report message to a moderator

Re: RMAN backup cant start [message #313314 is a reply to message #313279]

Fri, 11 April 2008 06:36

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

alanm
Messages: 284
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

Report message to a moderator

Re: RMAN backup cant start [message #313324 is a reply to message #313279]

Fri, 11 April 2008 06:59

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

Report message to a moderator

Re: RMAN backup cant start [message #313333 is a reply to message #313279]

Fri, 11 April 2008 07:07

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.

Report message to a moderator

Re: RMAN backup cant start [message #313334 is a reply to message #313324]

Fri, 11 April 2008 07:08

alanm
Messages: 284
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

Report message to a moderator

Re: RMAN backup cant start [message #313338 is a reply to message #313279]

Fri, 11 April 2008 07:18

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

Confused

i cant see tablespace created message...

any idea?

Regards,
Nikola

Report message to a moderator

Re: RMAN backup cant start [message #313347 is a reply to message #313338]

Fri, 11 April 2008 08:06

alanm
Messages: 284
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

Report message to a moderator

Re: RMAN backup cant start [message #313350 is a reply to message #313347]

Fri, 11 April 2008 08:16

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

Report message to a moderator

Re: RMAN backup cant start [message #313352 is a reply to message #313350]

Fri, 11 April 2008 08:23

alanm
Messages: 284
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

Report message to a moderator

Re: RMAN backup cant start [message #313357 is a reply to message #313279]

Fri, 11 April 2008 08:32

Nikola
Messages: 9
Registered: April 2008

Junior Member

hi,

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

Smile

Regards,
Nikola

Report message to a moderator

Re: RMAN backup cant start [message #313363 is a reply to message #313357]

Fri, 11 April 2008 08:50

alanm
Messages: 284
Registered: March 2005

Senior Member

ok, well as long as it works, that is great

Report message to a moderator

Previous Topic:	Standby in R/W mode with Flashback
Next Topic:	Problem connecting to the target using RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 12 06:42:52 CDT 2024