涉密,这里只写步骤,不写履行成果: 0.掌握文件备份 alter session set tracefile_identifier="bak_control"; alter database backup controlfile to trace; 1.确认掌握文件名称 select name from v$controlfile; 2.添加新的掌握文件路径 alter system set control_files="+DATA1/dxmy/controlfile/current.260.820062903","+DATA2" scope=spfile; 3.关闭数据库,启动到nomount模式 srvctl stop database -d orcl srvctl start database -d orcl -o nomount 4.检讨新添加的路径是不是在control_files参数 show parameter control_files 5.应用RMAN进行掌握文件的restore到新的路径下 rman target / restore controlfile from "+DATA1/dxmy/controlfile/current.260.820062903"; 6.关掉数据库然后正常启动 srvctl stop database -d orcl srvctl start database -d orcl 7.检讨设置成果: show parameter control_files; select name from v$controlfile;涉密,这里只写步骤,不写履行成果: 0.掌握文件备份 alter session set t