|
-
Originally posted by efrijters
Yes, offcourse you are right. Disk corruptions are rare, but it's better to be safe than sorry.
But... if I have only two control files, stored at separate places and backup the control files regularly to a trace file, than I would have better performance because of the lower number of control files and still have good backups of them. In case of problems, you can restore the control file out of the trace file.
I had this procedure in mind (from metalink):
Code:
CREATE OR REPLACE PROCEDURE proc_control_to_trace AS
2 cursor1 INTEGER;
3 BEGIN
4 cursor1 := dbms_sql.open_cursor;
5 dbms_sql.parse(cursor1, 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE',
dbms_sql.native);
6 dbms_sql.close_cursor(cursor1);
7 END;
That script just creates a control file creation script, thats all.
Rather than using ALTER DATABASE BACKUP CONTROLFILE TO TRACE use ALTER DATABASE BACKUP CONTROLFILE TO '/absolutepath/filename.ctl'
This will copy the actual control file to the specified location.
Amar
"There is a difference between knowing the path and walking the path."

Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|