Home » RDBMS Server » Backup & Recovery » rman backup + nfs mount
rman backup + nfs mount [message #160708] Tue, 28 February 2006 02:50 Go to next message
olga.daft
Messages: 7
Registered: July 2005
Junior Member
Hi,
we are using multiplex archived logs.
First archive_log_destination is on the local hard disk.
Second destination is on the novell file server (via nfs mount)
The database will be backed up with rman. This is a full backup (datafiles + archivelogs). After backup, all archivelogs will be deleted from hard disk (delete obsolete).
But rman seems to hang. Rman allocates a channel 'type=disk', but after command "delete obsolete" rman seems to break.
I guess, rman has a problem with nfs mount.
Which parameters are necessary for nfs mount?

Best regards
Marie
Re: rman backup + nfs mount [message #160716 is a reply to message #160708] Tue, 28 February 2006 03:20 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
please post the detail error msgs.

Here is the parameters used to mount nfs:
rw,hard,intr,rsize=16384,wsize=16384
Re: rman backup + nfs mount [message #160732 is a reply to message #160708] Tue, 28 February 2006 03:43 Go to previous messageGo to next message
olga.daft
Messages: 7
Registered: July 2005
Junior Member
There are no error messages.
The output is:
RMAN> delete obsolete;
RMAN> retention policy will be applied to the command
RMAN> retention policy is set to redundancy 1

After this rman will be aborted.
Re: rman backup + nfs mount [message #160734 is a reply to message #160732] Tue, 28 February 2006 03:52 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
That mean the command is running successfully!

Delete obsolete only used to delete the backup sets. It will not delete the archived logs. If you want delete the archived logs, you can use "backup archivelog all delete input".

Alex zeng
Re: rman backup + nfs mount [message #160742 is a reply to message #160708] Tue, 28 February 2006 04:15 Go to previous messageGo to next message
olga.daft
Messages: 7
Registered: July 2005
Junior Member
If the backup job runs seccessfully, the output is:

RMAN> delete obsolete;
RMAN> retention policy will be applied to the command
RMAN> retention policy is set to redundancy 1
using channel ORA_DISK_1
deleting the following obsolete backups and copies:
Backup Set ....
Archive Log .....

deleted backup piece handle=....

RMAN> **end-of-file**
Recovery Manager complete.

Thank you

What rsize/wsize means? Are the values default?

Re: rman backup + nfs mount [message #160750 is a reply to message #160742] Tue, 28 February 2006 04:28 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
rsize=8192,wsize=8192
This will make your nfs connection faster than with the default
buffer size of 4096. (NFSv2 does not work with larger values of
rsize and wsize.)

for detail information, run "man mount"
Re: rman backup + nfs mount [message #160776 is a reply to message #160732] Tue, 28 February 2006 05:49 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
olga.daft wrote on Tue, 28 February 2006 03:43

There are no error messages.
The output is:
RMAN> delete obsolete;
RMAN> retention policy will be applied to the command
RMAN> retention policy is set to redundancy 1

After this rman will be aborted.


Perhaps that's only because these is no obsolete backup sets.

Try to run report obsolete to see if there any obsolete backup sets.
Re: rman backup + nfs mount [message #160810 is a reply to message #160708] Tue, 28 February 2006 07:54 Go to previous messageGo to next message
olga.daft
Messages: 7
Registered: July 2005
Junior Member
It's same result:
RMAN> report obsolete;
RMAN> retention policy will be applied to the command
RMAN> retention policy is set to redundancy 1

Then rman breaks. Sad
Re: rman backup + nfs mount [message #160824 is a reply to message #160810] Tue, 28 February 2006 09:39 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
please check your alert log to see if there are any errors.

Alex zeng
Re: rman backup + nfs mount [message #161000 is a reply to message #160708] Wed, 01 March 2006 06:18 Go to previous messageGo to next message
olga.daft
Messages: 7
Registered: July 2005
Junior Member
Alert log contains no error messages.

Regards
Re: rman backup + nfs mount [message #161015 is a reply to message #160708] Wed, 01 March 2006 07:38 Go to previous messageGo to next message
olga.daft
Messages: 7
Registered: July 2005
Junior Member
Ok, it is known Bug on Oracle 9.2.0.7

Best regards
Re: rman backup + nfs mount [message #161021 is a reply to message #161015] Wed, 01 March 2006 07:58 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
oh, Next time, let's check on metalink at first Laughing
Previous Topic: clonning a database
Next Topic: help
Goto Forum:
  


Current Time: Fri Apr 19 04:32:48 CDT 2024