Home » RDBMS Server » Backup & Recovery » Getting ORA-19700 with various RMAN Commands (Oracle 9.2.0.8)
Getting ORA-19700 with various RMAN Commands [message #465752] Thu, 15 July 2010 09:11 Go to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi@all,
i have the following configuration.
The production server and the development server have an shared storage via nfs. The development server has the physical files and the production server has the nfs mounted.

Here is my config.
RMAN> show all;

using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata3/transfer/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F'; # default
CONFIGURE DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oradata3/transfer/%d_%T_%U.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/9.2.0/dbs/snapcf_DATABASENAME.f'; # default


No i wanted to do the following
RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 07/15/2010 16:09:52
ORA-19700: device type exceeds maximum length of 16


The same error occurs when i try to use an crosscheck backupset command.

Have you any hints whats wrong here?

Thanks in advance

Regards

Ralph
Re: Getting ORA-19700 with various RMAN Commands [message #465756 is a reply to message #465752] Thu, 15 July 2010 09:18 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
 ORA-19700 device type exceeds maximum length of string 
Cause
The device type indicated is invalid. 

Action
Supply a correct device type and retry the allocation. 

Re: Getting ORA-19700 with various RMAN Commands [message #465758 is a reply to message #465756] Thu, 15 July 2010 09:23 Go to previous messageGo to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi rahulvb,
thank you for your reply. But i really dont know whats wrong with my config. The path /oradata3/transfer really exists.
So what is exactly the problem?

Sorry but i cant see it at the moment.
Re: Getting ORA-19700 with various RMAN Commands [message #465763 is a reply to message #465752] Thu, 15 July 2010 09:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Most probably your nfs mounts are not mounted with proper options.
Re: Getting ORA-19700 with various RMAN Commands [message #465765 is a reply to message #465758] Thu, 15 July 2010 09:34 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata3/transfer/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F'; # default



if you are on unix dont you think so Both path should be in CAPS or other way round..

People please correct if I am wrong..
Re: Getting ORA-19700 with various RMAN Commands [message #465766 is a reply to message #465763] Thu, 15 July 2010 09:36 Go to previous messageGo to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
The strange thing about this is, that my backups work fine.
If recently done an backup archivelog all; without any problems.
The backupset are in the expected locations.

Regards

Ralph
Re: Getting ORA-19700 with various RMAN Commands [message #465768 is a reply to message #465765] Thu, 15 July 2010 09:38 Go to previous messageGo to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
rahulvb wrote on Thu, 15 July 2010 16:34

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata3/transfer/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F'; # default



if you are on unix dont you think so Both path should be in CAPS or other way round..

People please correct if I am wrong..


But i did not configure the second entrie youve listet. I think this is automatically generated from the first one? Isn't it?

Re: Getting ORA-19700 with various RMAN Commands [message #465770 is a reply to message #465768] Thu, 15 July 2010 09:43 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
People please correct if I am wrong..
Re: Getting ORA-19700 with various RMAN Commands [message #465772 is a reply to message #465768] Thu, 15 July 2010 09:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>
But i did not configure the second entrie youve listet
Quote:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata3/transfer/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F'; # default

Well, somebody did. And the syntax is wrong with second entry.
Re: Getting ORA-19700 with various RMAN Commands [message #465773 is a reply to message #465772] Thu, 15 July 2010 09:53 Go to previous messageGo to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Mahesh Rajendran wrote on Thu, 15 July 2010 16:49
>>
But i did not configure the second entrie youve listet
Quote:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradata3/transfer/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F'; # default

Well, somebody did. And the syntax is wrong with second entry.

Ok. Can you please tell me how to clear it?

I tried it using the following
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F' clear;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02001: unrecognized punctuation symbol "/"

RMAN>  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F' clear

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02001: unrecognized punctuation symbol "/"

RMAN>  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE clear

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "clear": expecting one of: "double-quoted-string, disk, identifier, single-quoted-string"
RMAN-01007: at line 1 column 57 file: standard input



Thank you for your help..
Re: Getting ORA-19700 with various RMAN Commands [message #465779 is a reply to message #465773] Thu, 15 July 2010 10:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have no idea how you managed to get that entry without quotes.
Here is a demo.
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
[b]CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' TO '%F';[/b]
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/home/dbs/snapcf_test9.f'; # default

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' clear;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' TO '%F';
RMAN configuration parameters are successfully reset to default value

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/home/dbs/snapcf_test9.f'; # default
Re: Getting ORA-19700 with various RMAN Commands [message #465780 is a reply to message #465773] Thu, 15 July 2010 10:20 Go to previous messageGo to next message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
You've messed up your configuration, at some point you must have executed this:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' to '%F%';

which is wrong, it worked only because you used quotes. You must clear it with this,
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' clear;

and then use the correct command, which (remember your case sensitivity) might be
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/ORADATA3/TRANSFER/%F';

and do the same for backup copies and archivelog configured defaults.
Re: Getting ORA-19700 with various RMAN Commands [message #465837 is a reply to message #465780] Thu, 15 July 2010 13:11 Go to previous messageGo to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi John,
thank you for your suggestion.
I've tried this but i am not able to reset the config.
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' clear;

RMAN configuration parameters are successfully reset to default value

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /ORADATA3/TRANSFER//%D_%T_%U.BKP TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE '/ORADATA3/TRANSFER/%D_%T_%U.BKP' PARALLELISM 1;
CONFIGURE DEVICE TYPE '/ORADATA3/TRANSFER//%D_%T_%U.BKP' PARALLELISM 1;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /ORADATA3/TRANSFER//%D_%T_%U.BKP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /ORADATA3/TRANSFER/%D_%T_%U.BKP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /ORADATA3/TRANSFER//%D_%T_%U.BKP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oradata3/transfer/%d_%T_%U.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/9.2.0/dbs/snapcf_CXTEST.f'; # default

Is there any way to force resetting all rman configurations? Then i could start from the beginning.

Thanks for any help.

Regards

Ralph
Re: Getting ORA-19700 with various RMAN Commands [message #465859 is a reply to message #465837] Thu, 15 July 2010 15:21 Go to previous messageGo to next message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
If you were to re-create the controlfile (which is simple enough), you would have an empty RMAN repository. I can't think of any other way to remove it completely. The commands I gave worked for me.
Re: Getting ORA-19700 with various RMAN Commands [message #465861 is a reply to message #465859] Thu, 15 July 2010 16:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to go into SQL*Plus and issue the following as SYS:

SQL> execute dbms_backup_restore.resetConfig;

This will reset all your CONFGURE parameters, so be sure to capture all your present CONFIGURE parameters prior to executing this command.
Re: Getting ORA-19700 with various RMAN Commands [message #465919 is a reply to message #465861] Fri, 16 July 2010 01:12 Go to previous messageGo to next message
eigeneachse
Messages: 37
Registered: July 2008
Member
Hi ebrian,
thank you very much for your suggestion. This worked for me.
Now my other operations work as expected.

Thanks to all who helped on solving this issue.

Regards

Ralph
Re: Getting ORA-19700 with various RMAN Commands [message #465938 is a reply to message #465919] Fri, 16 July 2010 01:39 Go to previous messageGo to next message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
@ebrian, nice one. I've learnt something today already! (Before breakfast, GMT+1)
Re: Getting ORA-19700 with various RMAN Commands [message #466025 is a reply to message #465938] Fri, 16 July 2010 08:29 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You are welcome. Always good to start the day off with information that "should" be in the Oracle documentation.
Previous Topic: RMAN backup on Windows 2008
Next Topic: Cloning the Oracle 9i on Windows
Goto Forum:
  


Current Time: Tue Sep 02 01:57:37 CDT 2014

Total time taken to generate the page: 0.06509 seconds