Backup & Recovery 常用命令

《Backup & Recovery 常用命令》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Backup&Recovery常用命令Oracle学习笔记:发表时间：2009-03-06最后修改：2009-06-18<>猎头职位:北京:Ruby高级工程师相关文章:Oracle备份与恢复案例Oracle学习笔记:重建ControlFilebehaviorofdatabasebackupwith"plusarchivelog"推荐圈子:Database圈子更多相关推荐1.setdatabasetoarchivelogmodeSql代码SQL>shutdownimmediate;Databaseclosed.Databa

2、sedismounted.ORACLEinstanceshutdown.SQL>startupmount;ORACLEinstancestarted.TotalSystemGlobalArea251658240bytesFixedSize1248356bytesVariableSize83887004bytesDatabaseBuffers159383552bytesRedoBuffers7139328bytesDatabasemounted.SQL>alterdatabasearchivelog;Databasealt

3、ered.SQL>alterdatabaseopen;Databasealtered.SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence1319Nextlogsequencetoarchive1321Currentlogsequence1321SQL>shutdownimmediate;Databasec

4、losed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupmount;ORACLEinstancestarted.TotalSystemGlobalArea251658240bytesFixedSize1248356bytesVariableSize83887004bytesDatabaseBuffers159383552bytesRedoBuffers7139328bytesDatabasemounted.SQL>alterdatabasearchivelog

5、;Databasealtered.SQL>alterdatabaseopen;Databasealtered.SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence1319Nextlogsequencetoarchive1321Currentlogsequence13212.defineflashrecove

6、ryareaSql代码SQL>altersystemsetdb_recovery_file_dest='D:oracleflash_recovery_area'scope=both;Systemaltered.SQL>altersystemsetdb_recovery_file_dest_size=15Gscope=both;Systemaltered.SQL>altersystemsetdb_recovery_file_dest='D:oracleflash_recovery_area'scope=both;S

7、ystemaltered.SQL>altersystemsetdb_recovery_file_dest_size=15Gscope=both;Systemaltered.OraclewilluseOracleManagedFile(OMF)fortheflashrecoveryarea.ThefreespaceinrecoveryareacanbecheckedusingOEM:AllMetrics->RecoveryArea,orqueryvflash_recovery_area_usageview.Togetmor

8、efreespace,youcanusethefollowingcommandtobackupandthendeleteallthearchivedlogfiles.Sql代码RMAN>backuparchivelogalldeleteallinput;RMAN>backuparchivelogalldeleteal