Manually check if controlfiles need rename in init.ora
Save this result [moves]:
select 'mv ' || file_name || ' ' || replace(file_name, '/ora02_gene', '/ora01_gene') mv
from (
select * from (
select file_name from dba_data_files
union all
select member from v$logfile
)
)
where file_name like '/ora02_gene%'
order by 1
Save this result [rename]:
select 'alter database rename file ''' || file_name || ''' to ''' || replace(file_name, '/ora02_gene', '/ora01_gene') || ''';' rename_file from (
select * from (
select file_name from dba_data_files
union all
select member from v$logfile
)
)
where file_name like '/ora02_gene%'
order by 1
Shutdown instance
move physically the files [moves]
startup mount
run rename [rename]
|