6 Replies Latest reply: May 16, 2007 10:02 AM by 439075 RSS

    Backing up controlfile to trace, but in a diff location

    rg2
      With the alter database backup controlfile to trace, how can I specify a diff. location. I tried it this way but got an error: I want to move it to another location so that one of my scripts can pick up this file and move it somewhere else (part of a backup scenario we have):

      SQL*Plus: Release 8.1.7.0.0 - Production on Wed May 16 09:45:39 2007

      (c) Copyright 2000 Oracle Corporation. All rights reserved.

      SQL> conn system@lifedev
      Connected.
      SQL> alter database backup controlfile to trace as 'c:\mytest.sql';
      alter database backup controlfile to trace as 'c:\mytest.sql'
      *
      ERROR at line 1:
      ORA-00933: SQL command not properly ended