控制文件<br>(Control Files)<br>v$controlfile<br>
<b>备份方法1(OffLine Backup)</b><br>关闭数据库(kddown)<br>拷贝Control file到备份路径<br>在$KD_SID.tip文件中追加<u><i>CONTROL_FILES</i></u>参数<br>启动数据库 (kdboot)<br>
<b>备份方法2(OnLine Trace)</b><br>ALTER DATABASE BACKUP CONTROLFILE TO TRACE <br>AS (Control File 备份的目标文件路径与名称 ) REUSE NORESETLOGS;<br>
重做日志<br>(Redo Logs)<br>V$LOG, V$LOGFILE<br>
[0]重做日志组<br>(Redo Log Group)
[1]重做日志文件<br>(Redo Log File)
[2]重做日志文件<br>
[*]重做日志文件<br><b>追加重做日志:</b><br>ALTER DATABASE ADD LOGFILE MEMBER <br>'/home/KDB/kddata/redo23.log' <br>TO GROUP 2;<br>
[1]重做日志组
[*]重做日志组<br><b>追加重做日志组:<br></b>ALTER DATABASE ADD LOGFILE GROUP 2 <br>('/home/KDB/kddata/redo21.log',<br> '/home/KDB/kddata/redo22.log'<br>) SIZE 10m;<br>
