Home » RDBMS Server » Backup & Recovery » Syntax for dump logfile options in 10g?
Syntax for dump logfile options in 10g? [message #177072] Mon, 12 June 2006 19:23 Go to next message
dreiger
Messages: 6
Registered: April 2005
Location: Broomfield, Co
Junior Member
I have a large redo log file for Oracle 10.2 on Windows and am trying to dump a portion of the log using the alter system dump logfile command:

SQL>alter system dump logfile 'C:\ORACLE\ORADATA\REDO01.LOG'
2 RBA MIN 22 . 5920
3 RBA MAX 22 . 5922
4 ;

However, I get the following error:
ERROR at line 2:
ORA-01963: Must specify a block number

This syntax worked with 9i. What is the syntax for 10g?

Thanks,
Derek

Re: Syntax for dump logfile options in 10g? [message #177075 is a reply to message #177072] Mon, 12 June 2006 20:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just exclude the dots. Like this
SQL>alter system dump logfile 'C:\ORACLE\ORADATA\REDO01.LOG'
2 RBA MIN 22  5920
3 RBA MAX 22  5922
4 ;
Re: Syntax for dump logfile options in 10g? [message #177267 is a reply to message #177075] Tue, 13 June 2006 14:43 Go to previous message
dreiger
Messages: 6
Registered: April 2005
Location: Broomfield, Co
Junior Member
Thanks very much!
Previous Topic: Import Error
Next Topic: db to open in RESETLOGS or NORESETLOGS ?
Goto Forum:
  


Current Time: Fri Mar 29 03:53:51 CDT 2024