【控制文件丢失-恢复-1】(八)
base not open
Database dismounted.
ORACLE instance shut down.
[oracle@oracle ~]$ vi /tmp/s.sql
[oracle@oracle ~]$ vi /tmp/s.sql
[oracle@oracle ~]$ sed '/^$/d' /tmp/s.sql >/tmp/s1.sql
[oracle@oracle ~]$ sed 's/^ //g' -i /tmp/s1.sql
[oracle@oracle ~]$ sed 's/^ //g' -i /tmp/s1.sql
[oracle@oracle ~]$ sed 's/^ //g' -i /tmp/s1.sql
[oracle@oracle ~]$ sed 's/^ //g' -i /tmp/s1.sql
[oracle@oracle ~]$ cat /tmp/s1.sql
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by Recovery Manager will be lost.
-- The contents of online logs will be lost and all backups will
-- be invalidated. Use this only if online logs are damaged.
-- WARNING! The current control file needs to be checked against
-- the datafiles to insure it contains the correct files. The
-- commands printed here may be missing log and/or data files.
-- Another report should be made after the database has been
-- successfully opened.
-- After mounting the created controlfile, the following SQL
-- statement will place the database in the appropriate
-- protection mode:
-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "JADL10G" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/oracle/oradata/jadl10g/redo01.log' SIZE 50M,
GROUP 2 '/u01/oracle/oradata/jadl10g/redo02.log' SIZE 50M,
GROUP 3 '/u01/oracle/oradata/jadl10g/redo03.log' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/u01/oracle/oradata/jadl10g/system01.dbf',
'/u01/oracle/oradata/jadl10g/undotbs01.dbf',
'/u01/oracle/oradata/jadl10g/sysaux01.dbf',
'/u01/oracle/oradata/jadl10g/users01.dbf',
'/u01/oracle/oradata/jadl10g/example01.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 '/u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE '/u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_1_%u_.arc';
-- 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;
-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/jadl10g/temp01.dbf' REUSE;
-- End of tempfile additions.
--
SQL>
start /tmp/s1.sql
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 2098112 bytes
Variable Size 163580992 bytes
Database Buffers 427819008 bytes
Redo Buffers 6287360 bytes
Control file created.
ORA-00279: change 424293 generated at 11/06/2014 12:50:02 needed for thread 1
ORA-00289: suggestion :
/u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_5_b5ozjrrr
_.arc
ORA-00280: change 424293 for thread 1 is in sequence #5
ORA-00308: cannot open archived log '--'
ORA-27037: unable to obtain