OraFAQ Forum: Backup & Recovery » Getting ORA-19700 with various RMAN Commands

Home » RDBMS Server » Backup & Recovery » Getting ORA-19700 with various RMAN Commands (Oracle 9.2.0.8)

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

Getting ORA-19700 with various RMAN Commands [message #465752]

Thu, 15 July 2010 09:11

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

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465756 is a reply to message #465752]

Thu, 15 July 2010 09:18

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.

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465758 is a reply to message #465756]

Thu, 15 July 2010 09:23

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.

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465763 is a reply to message #465752]

Thu, 15 July 2010 09:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Most probably your nfs mounts are not mounted with proper options.

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465765 is a reply to message #465758]

Thu, 15 July 2010 09:34

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..

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465766 is a reply to message #465763]

Thu, 15 July 2010 09:36

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

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465768 is a reply to message #465765]

Thu, 15 July 2010 09:38

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?

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465770 is a reply to message #465768]

Thu, 15 July 2010 09:43

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

People please correct if I am wrong..

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465772 is a reply to message #465768]

Thu, 15 July 2010 09:49

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465773 is a reply to message #465772]

Thu, 15 July 2010 09:53

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..

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465779 is a reply to message #465773]

Thu, 15 July 2010 10:19

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465780 is a reply to message #465773]

Thu, 15 July 2010 10:20

John Watson
Messages: 8929
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.

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465837 is a reply to message #465780]

Thu, 15 July 2010 13:11

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

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465859 is a reply to message #465837]

Thu, 15 July 2010 15:21

John Watson
Messages: 8929
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.

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465861 is a reply to message #465859]

Thu, 15 July 2010 16:14

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.

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465919 is a reply to message #465861]

Fri, 16 July 2010 01:12

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

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #465938 is a reply to message #465919]

Fri, 16 July 2010 01:39

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

@ebrian, nice one. I've learnt something today already! (Before breakfast, GMT+1)

Report message to a moderator

Re: Getting ORA-19700 with various RMAN Commands [message #466025 is a reply to message #465938]

Fri, 16 July 2010 08:29

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.

Report message to a moderator

Previous Topic:	RMAN backup on Windows 2008
Next Topic:	Cloning the Oracle 9i on Windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 05:11:23 CDT 2024