alter system backup controlfile to trace内容详解.docVIP

alter system backup controlfile to trace内容详解 ---下面通过alter system backup controlfile to trace抽取的控制文件源本，讲得很不错-- Below are two sets of SQL statements, each of which creates a new-- control file and uses it to open the database. The first set opens-- the database with the NORESETLOGS option and should be used only if-- the current versions of all online logs are available. The second-- set opens the database with the RESETLOGS option and should be used-- if online logs are unavailable.-- The appropriate set of statements can be copied from the trace into-- a script. file, edited as necessary, and executed when there is a-- need to re-create the control file.-------注解：重建控制控制文件分为两种类型：noresetlogs和resetlogs。----- 二者区别：前者主要用于所在在线日志可以用，后者相反，就是在线日志不可用-- Set #1. NORESETLOGS case---- The following commands will create a new control file and use it-- to open the database.-- Data used by Recovery Manager will be lost.---重建后rman所有使用的数据就不能用了，所以马上进行备份方为安全-- Additional logs may be required for media recovery of offline-- Use this only if the current versions of all online logs are-- available.-- After mounting the created controlfile, the following SQL ---这个是说，mount了重建的控制文件之后，如下sql会把数据库加载到一个合适的保护模式（dg)-- statement will place the database in the appropriate-- protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE--重建控制文件数据库在nomount状态下STARTUP NOMOUNT----重建控制文件CREATE CONTROLFILE REUSE DATABASE ONLY NORESETLOGS ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 292LOGFILE GROUP 1 +ASM1/only/redo01.log SIZE 50M, GROUP 2 +ASM1/only/redo02.log SIZE 50M, GROUP 3 +ASM1/only/redo03.log SIZE 50M, GROUP 4 +ASM1/only/redo04.log SIZE 50M-- STANDBY LOGFILEDATAFILE +ASM1/only/system01.dbf, +ASM1/only/undotbs01.dbf, +ASM1/only/sysaux01.dbf, +ASM1/only/users01.dbf, +ASM1/only/undotbs02.dbfCHARACTER SET WE8ISO8859P1;----下列讲的啥，呵呵。一些重建化身表的命令，log名字以下