This content has been marked as final. Show 6 replies
I´m not sure, but I think it is not possible to create a backup in text version and point to a different location.
Backup a Binary Version of the control File
ALTER DATABASE BACKUP CONTROLFILE TO 'd:\orant\control_backup'
Backup a Text Version of the Control File
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Let´s see the others.....How I said before...I´m not sure.....
Yeap...just try it....
SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 16 11:54:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/opt/app/oracle/admin/ORA102/control.trc';
SQL> ! ls -l contr*
-rw-r--r-- 1 oracle oinstall 6285 May 16 11:55 control.trc