Home » RDBMS Server » Backup & Recovery » Error while config RMAN (10g/Unix)
Error while config RMAN [message #339883] Sat, 09 August 2008 07:36 Go to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Hellow Everybody,

I was just trying to configure the RMAN, till I configure "CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/RMANBKP/snapcf_prod01'" it was woring fine, and then I tried to configure the channel "CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/u01/RMANBKP/%U.bak' MAXPIECESIZE 4G;", I got the below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 08/09/2008 17:33:39
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/09/2008 17:33:39
ORA-01580: error creating control backup file /u01/RMANBKP/SNCFprod01.ORA
ORA-27040: file create error, unable to create file
HP-UX Error: 2: No such file or directory


Tried to clear the configuration, but getting the same error.
Now I am not able to use SHOW ALL also as it tooreturns the same error.

Appreciate if you can guide me where I am doing wrong.

Thanks in advance.
Maddy
Re: Error while config RMAN [message #339888 is a reply to message #339883] Sat, 09 August 2008 07:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>>HP-UX Error: 2: No such file or directory

Are you sure file and directory exist? means PATH is correct.
Re: Error while config RMAN [message #339890 is a reply to message #339883] Sat, 09 August 2008 08:07 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Yeah I am sure that the path is correct.

I wanted to clear the configuration, but I am not even able to do so.

Regards.
Re: Error while config RMAN [message #339896 is a reply to message #339883] Sat, 09 August 2008 09:01 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
I sorted out the issue...
Re: Error while config RMAN [message #339897 is a reply to message #339883] Sat, 09 August 2008 09:03 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
So please post the solution so others may benefit in the future.
Re: Error while config RMAN [message #339901 is a reply to message #339883] Sat, 09 August 2008 09:25 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Well anacedent, I had specified the control file snapshot to the diffrent path where as it should have been set to the $ORACLE_HOME/dbs.

I connected to the target database with /nocatalogoption then corrected the path to the $Oracle_home/dbs.

It worked fine.

However when I try to connect target database using a catalog option the problem remains the same, I ried to change the pathe same way as I did in nocatalog mode but error remains the same,what should be the problem.

Appreciate your guidenece in this regard.

Regards,
Maddy
Re: Error while config RMAN [message #339902 is a reply to message #339883] Sat, 09 August 2008 09:38 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Any Clues...
Re: Error while config RMAN [message #339935 is a reply to message #339901] Sat, 09 August 2008 23:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
me_maddy wrote on Sat, 09 August 2008 08:36

I was just trying to configure the RMAN, till I configure "CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/RMANBKP/snapcf_prod01'" it was woring fine, and then I tried to configure the channel "CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/u01/RMANBKP/%U.bak' MAXPIECESIZE 4G;", I got the below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 08/09/2008 17:33:39
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/09/2008 17:33:39
ORA-01580: error creating control backup file /u01/RMANBKP/SNCFprod01.ORA
ORA-27040: file create error, unable to create file
HP-UX Error: 2: No such file or directory


Tried to clear the configuration, but getting the same error.
Now I am not able to use SHOW ALL also as it tooreturns the same error.


/u01/RMANBKP/snapcf_prod01 and /u01/RMANBKP/SNCFprod01.ORA

These two paths don't seem to match?

If you can no longer execute show all, then you may have to go into SQL*Plus and issue the following as SYS:

SQL> execute dbms_backup_restore.resetConfig;
Re: Error while config RMAN [message #339961 is a reply to message #339883] Sun, 10 August 2008 07:05 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Thanks for your response.

I did

SQL> execute dbms_backup_restore.resetConfig;


PL/SQL procedure successfully completed.

I also used set snapshot contrilfile command to set the confile to the default $ORACLE_HOME/dbs path.
But when i try to do SHOW ALL, I am still getting the same error.

$ rman TARGET sys/sysuser#@prod01 CATALOG rmanager/rmanager@rmcat

Recovery Manager: Release 10.1.0.5.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: PROD01 (DBID=1044431665)
connected to recovery catalog database

RMAN> show all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 08/10/2008 17:22:28
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/10/2008 17:22:28
ORA-01580: error creating control backup file /orasoft/ora10/dbs/snapprod01.f
ORA-27040: file create error, unable to create file
HP-UX Error: 2: No such file or directory



PLease suggest!

Regards
Maddy.
Re: Error while config RMAN [message #339964 is a reply to message #339883] Sun, 10 August 2008 07:56 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
I am also unable to clear the snapshot controlfile configuartion

Below is the output.


RMAN> set snapshot controlfile name to '/orasoft/ora10/dbs/snapprod01.f';

executing command: SET SNAPSHOT
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of CSET command at 08/10/2008 18:12:31
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/10/2008 18:12:31
ORA-01580: error creating control backup file /orasoft/ora10/dbs/snapprod01.f
ORA-27040: file create error, unable to create file
HP-UX Error: 2: No such file or directory

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;

[B]Bus error(coredump)[/B]
$ 



I droped the old catalog schema(which was in a seperate catalog database)created a new schema and gave recovery_catalog_owner role to the schema,
Tried to register/unregister target database, but no good.


$ rman TARGET sys/sysuser#@prod01 CATALOG rmanager/rmanager@rmcat

Recovery Manager: Release 10.1.0.5.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: UNIDB (DBID=1044431665)
connected to recovery catalog database

RMAN> unregister database
2> ;

database name is "PROD01" and DBID is 1044431665

Do you really want to unregister the database (enter YES or NO)? yes
database unregistered from the recovery catalog

RMAN> exit
Recovery Manager complete.

$ rman TARGET sys/sysuser#@prod01 CATALOG rmanager/rmanager@rmcat

Recovery Manager: Release 10.1.0.5.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: PROD01 (DBID=1044431665)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
ORA-01580: error creating control backup file /orasoft/ora10/dbs/snapprod01.f
ORA-27040: file create error, unable to create file
HP-UX Error: 2: No such file or directory


Appreciate your suggestions!!
Maddy
Re: Error while config RMAN [message #339974 is a reply to message #339964] Sun, 10 August 2008 10:31 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you perform the resetconfig on the target database?

Also, try to connect ONLY to the target database and run:

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;
RMAN> SHOW ALL;

Re: Error while config RMAN [message #340658 is a reply to message #339883] Wed, 13 August 2008 13:18 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Hi

I re-configured the RMAN settings and now when I try to take the backup of the tablespace namely "testtab", it gets backed up in the server mountpoints where database is stored,whereas I have configured the RMAN chennels to create the backup set on the catalog server which is a seperate server with a seperate storage connected.
I also noticed channel is ignored in the configuation.


$ rman TARGET sys/sysuser#@prod01

Recovery Manager: Release 10.1.0.5.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: PROD01 (DBID=1044431665)

RMAN> show all;

using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata01/cat/RMAN_BKP/ctl_sp_bak_%d_%t%F';
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
configuration for DISK channel 4 is ignored
configuration for DISK channel 5 is ignored
configuration for DISK channel 6 is ignored
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/oradata02/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT   '/oradata03/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT   '/oradata04/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT   '/oradata05/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT   '/oradata06/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/orasoft/ora10/dbs/snapprod01.f'; # default


RMAN> backup tablespace testtab;

Starting backup at 13-AUG-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=786 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00382 name=/unora/testtab/testtab.dbf
channel ORA_DISK_1: starting piece 1 at 13-AUG-08
channel ORA_DISK_1: finished piece 1 at 13-AUG-08
piece handle=/orasoft/ora10/dbs/2vjnv813_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:56
Finished backup at 13-AUG-08


RMAN> exit


Recovery Manager complete.
$ rman TARGET sys/sysuser#@prod01 catalog bkpman/bkpman@rcat

Recovery Manager: Release 10.1.0.5.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: PROD01 (DBID=1044431665)
connected to recovery catalog database

RMAN> backup tablespace testtab;

Starting backup at 13-AUG-08
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
configuration for DISK channel 4 is ignored
configuration for DISK channel 5 is ignored
configuration for DISK channel 6 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2053 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00382 name=/unora5/testtab/testtab.dbf
channel ORA_DISK_1: starting piece 1 at 13-AUG-08
channel ORA_DISK_1: finished piece 1 at 13-AUG-08
piece handle=/orasoft/ora10/dbs/30jnv89e_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:26
Finished backup at 13-AUG-08



RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata01/cat/RMAN_BKP/ctl_sp_bak_%d_%t%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/oradata02/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT   '/oradata03/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT   '/oradata04/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT   '/oradata05/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT   '/oradata06/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/orasoft/ora10/dbs/snapcf_unidb.f'; # default



Appreciate you suggestions!!.

Maddy.
Re: Error while config RMAN [message #340665 is a reply to message #340658] Wed, 13 August 2008 13:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You need CONFIGURE DEVICE TYPE DISK FORMAT to the appropriate location and if you want multiple channels you should either ALLOCATE more than one channel or increase your PARALLELISM.

[Updated on: Wed, 13 August 2008 14:05]

Report message to a moderator

Re: Error while config RMAN [message #340680 is a reply to message #339883] Wed, 13 August 2008 14:18 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Thanks for the reply.

Please look onto the below output, I have already configured the chennels using the configure command.there are already 5 chennels
(2-6) aleady configured.

RMAN> show all;

using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata01/cat/RMAN_BKP/ctl_sp_bak_%d_%t%F';
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
configuration for DISK channel 4 is ignored
configuration for DISK channel 5 is ignored
configuration for DISK channel 6 is ignored
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/oradata02/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT   '/oradata03/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT   '/oradata04/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT   '/oradata05/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT   '/oradata06/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/orasoft/ora10/dbs/snapprod01.f'; # default



Do I have to again mention allocate channel <chennel name> while firing backup command.

Regards,

Maddy
Re: Error while config RMAN [message #340685 is a reply to message #339883] Wed, 13 August 2008 14:45 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
$ rman TARGET sys/sysuser#@prod01 catalog bkpman/bkpman@rcat

Recovery Manager: Release 10.1.0.5.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: PROD01 (DBID=1044431665)
connected to recovery catalog database

RMAN> backup tablespace testtab;

Starting backup at 13-AUG-08
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
configuration for DISK channel 4 is ignored
configuration for DISK channel 5 is ignored
configuration for DISK channel 6 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2053 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00382 name=/unora5/testtab/testtab.dbf
channel ORA_DISK_1: starting piece 1 at 13-AUG-08
channel ORA_DISK_1: finished piece 1 at 13-AUG-08
piece handle=/orasoft/ora10/dbs/30jnv89e_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:26
Finished backup at 13-AUG-08


Do I have to again mention allocate channel <chennel name> while firing backup command.

Regards,

Maddy
Re: Error while config RMAN [message #340688 is a reply to message #340685] Wed, 13 August 2008 14:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Please re-read my reply above.

FIRST:
ebrian wrote on Wed, 13 August 2008 14:39
You need CONFIGURE DEVICE TYPE DISK FORMAT to the appropriate location

SECOND:
ebrian wrote on Wed, 13 August 2008 14:39

... and if you want multiple channels you should either ALLOCATE more than one channel or increase your PARALLELISM.

I realize you configured more than one channel, but your PARALLELISM is 1, plus in your example, you are ONLY backing up ONE datafile. Allocate and configure are two distinct parameters.
Re: Error while config RMAN [message #341078 is a reply to message #339883] Sat, 16 August 2008 01:22 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Thanks for your replies.

I did allocate channels manually, but still RMAN takes backup onto the DB server mountpoints, whereas I have dedicated a seperate server for catalog database and mountpoints to store backup pieces.

suppose DB Server A has mountpoints (1,2,3) and Catalog server B has mountpoins(4,5,6).

Database is in server 'A' and catalog DB is server 'B', now I want to take the RMAN backup of server A onto the mountpoints of server B.

But RMAN takes backup on the path /orasoft/ora10/dbs/

Where and what path do I set the so that RMAN takes backup on the server B mountpoints.


Please see the existing configuration below.


RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata01/cat/RMAN_BKP/ctl_sp_bak_%d_%t%F';
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
configuration for DISK channel 4 is ignored
configuration for DISK channel 5 is ignored
configuration for DISK channel 6 is ignored
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/oradata02/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT   '/oradata03/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT   '/oradata04/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK FORMAT   '/oradata05/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT   '/oradata06/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/orasoft/ora10/dbs/snapprod01.f'; # default


Appreciate your suggestion!

Maddy
Re: Error while config RMAN [message #341085 is a reply to message #339883] Sat, 16 August 2008 03:11 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
Is Anybody there to suggest what is wrong in the mentioned configuration!!
Re: Error while config RMAN [message #341117 is a reply to message #341085] Sat, 16 August 2008 11:12 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you want the backups to reside on the catalog server, you need to ensure the mount points are in place and the appropriate privileges are applied. Be aware that you could run into issues with NFS and RMAN.

Nevertheless, try to configure you settings as follows (this assumes parallelism of 3):

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '<path_to_remote_mount>/%U.bak';

Be careful with how many channels you configure for parallelism; this could have a huge impact on your server and backup performance.
Re: Error while config RMAN [message #341896 is a reply to message #339883] Wed, 20 August 2008 13:25 Go to previous messageGo to next message
me_maddy
Messages: 31
Registered: April 2008
Member
I have DB server on 192.168.6.25 and catalog DB on 192.168.6.2 server.

I did re-config the settings as below

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '192.168.6.2:/oradata02/cat/RMAN_BKP/%U.bak' MAXPIECESIZE 4 G;


but still backup pieces does not get backed up on the catalog server.

Please suggest!!

Maddy
Re: Error while config RMAN [message #341947 is a reply to message #341896] Wed, 20 August 2008 17:16 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That's not even a valid path.

Can you simply perform the following as oracle from an O/S command prompt:

touch 192.168.6.2:/oradata02/cat/RMAN_BKP/test.bak

You need to specify a valid NFS mount point. Mount the remote directory appropriately and then specify that path in the FORMAT clause above.
Previous Topic: Backup & Archivelog Location
Next Topic: datbase not opened (merged)
Goto Forum:
  


Current Time: Thu Dec 08 08:13:29 CST 2016

Total time taken to generate the page: 0.13413 seconds