Re: TIMEOUT ON CONTROL FILE ENQUEUE

In <1126279871.743116.258320_at_g49g2000cwa.googlegroups.com> jkstill_at_gmail.com writes:

>To answer question #3:

>You may startup the database in mount mode and run the following SQL
>to generate SQL that may be used to take datafiles out of backup mode.

>select 'alter database datafile ' || '''' || f.name || '''' || ' end
>backup;'
>from v$datafile f, v$backup b
>where b.status = 'ACTIVE'
>and f.file# = b.file#;

>This can be done before or after the backup.

Thanks, and 2 follwoup questions.

1, Is it safe to do this before making the backups? 2. Since I only dealy with DBA'ing every couple of years, when something goes wrong, I am very weak on this side of thisgs :-(. So, having admited my ignorance :-), How do I "startup the database in mount mode" ?

Thanks for bbeing patient with me.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin