Backup control file to trace

alter database backup controlfile to trace as'/home/oracle/BACKUP/trace_control.bck';--Crea dos conjuntos de comandos SQL, cada uno crea un nuevo controlfile --y lo usa para abrir la base de datos. El primer script abre la base de --datos con la opción NORESETLOGS y debe ser usado solo sí las versiones --actuales de los logs estan disponibles. STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "RCAT" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 '+DATA/rcat/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '+DATA/rcat/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '+DATA/rcat/redo03.log' SIZE 50M BLOCKSIZE 512DATAFILE '+DATA/rcat/system01.dbf', '+DATA/rcat/sysaux01.dbf', '+DATA/rcat/undotbs01.dbf', '+DATA/rcat/users01.dbf', '+DATA/rcat01.dbf'CHARACTER SET AL32UTF8; -- Commands to re-create incarnation table -- Below log names MUST be changed to existing filenames on -- disk. Any one log file from each branch can be used to -- re-create incarnation records. -- ALTER DATABASE REGISTER LOGFILE '+FRA'; -- ALTER DATABASE REGISTER LOGFILE '+FRA'; -- Recovery is required if any of the datafiles are restored backups, -- or if the last shutdown was not normal or immediate. RECOVER DATABASE -- All logs need archiving and a log switch is needed. ALTER SYSTEM ARCHIVE LOG ALL; -- Database can now be opened normally. ALTER DATABASE OPEN; --El segundo script reset logs indica que la base se abrirá --con la opciónn ALTER DATABASE OPEN RESETLOGS esta opción es valida --solo si los online logs no estan disponibles. STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "RCAT" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 '+DATA/rcat/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '+DATA/rcat/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '+DATA/rcat/redo03.log' SIZE 50M BLOCKSIZE 512-- STANDBY LOGFILE DATAFILE '+DATA/rcat/system01.dbf', '+DATA/rcat/sysaux01.dbf', '+DATA/rcat/undotbs01.dbf', '+DATA/rcat/users01.dbf', '+DATA/rcat01.dbf'CHARACTER SET AL32UTF8; -- Commands to re-create incarnation table -- Below log names MUST be changed to existing filenames on -- disk. Any one log file from each branch can be used to -- re-create incarnation records. -- ALTER DATABASE REGISTER LOGFILE '+FRA'; -- ALTER DATABASE REGISTER LOGFILE '+FRA'; -- Recovery is required if any of the datafiles are restored backups, -- or if the last shutdown was not normal or immediate. RECOVER DATABASE USING BACKUP CONTROLFILE -- Database can now be opened zeroing the online logs. ALTER DATABASE OPEN RESETLOGS;