I backup my controlfiles using both these methods:
alter database backup controlfile to trace;
alter database backup controlfile to
The second one I noticed actually copies the control file to that location. I am using hotbackups (tablespace in backup mode etc), I was wondering if this copy was valuable. I mean the database is up while I used this command. If something happened to all my controlfiles, could I use this to restore?
The first command (to trace) creates the create command, but the second actually copies a control file. I tried opening it (the second one) and it was different from the first one. And the second one matches the actual size of control file.
I was trying to figure out whether the second one was of any use since it was done with the database open.