Home » RDBMS Server » Backup & Recovery » Syntax for dump logfile options?
Syntax for dump logfile options? [message #117207] Mon, 25 April 2005 14:08 Go to next message
dreiger
Messages: 6
Registered: April 2005
Location: Broomfield, Co
Junior Member
I have a large redo log file for Oracle 920 on Windows and am trying to dump a portion of the log using the alter system dump logfile command:

alter system dump logfile 'logfile_name'
RBA_MIN 5631.68818
RBA_MAX 5631.68830
;

However, I get the following error:
SQL> alter system dump logfile 'logfile_name'
2 RBA MIN 5631.68818
3 RBA MAX 5631.68830
4 ;
RBA MIN 5631.68818
*
ERROR at line 2:
ORA-02017: integer value required

I'm confident the syntax I'm using is correct (and clearly 5631 is an integer), based on the error messages I get when I try different variations. I am trying to dump this log using a different Oracle instance than the one that created the log, but they are the same version. Also, I can't even get the syntax to work on a log that was created by the same instance.

Thanks,
Derek
Re: Syntax for dump logfile options? [message #117209 is a reply to message #117207] Mon, 25 April 2005 14:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
syntax typo.
include a 'space' around the 'dot'
 
alter system dump logfile 'logfile_name'
RBA MIN 5631 . 68818
RBA MAX 5631 . 68830;
icon14.gif  Re: Syntax for dump logfile options? [message #117214 is a reply to message #117209] Mon, 25 April 2005 15:48 Go to previous message
dreiger
Messages: 6
Registered: April 2005
Location: Broomfield, Co
Junior Member
Thank you very much!

Derek
Previous Topic: Is your backup is going to work while recovery?
Next Topic: RMAN stuck in scheduled status ...
Goto Forum:
  


Current Time: Sat Apr 20 08:30:00 CDT 2024