Listen Software Solution "How to" Series 5: Log File
Create a database with an instance manager (abolished in Oracle9i, slightly going) to create a development environment (去)
Log file
All log file reset log options Complete a complete cold backup 1) Create a database original shape, put a new SCN. 2) Reset log serial number to 1 3) If there is, re-format Coat up to do log
Inadvertently recovering online redo log When restoring the database, you may accidentally restore online redo logs. This will force a completion of an incomplete recovery rather than complete recovery.
Status and location: Select A.Group #, A.Members, A.status, A.SEquence #, A.BYTES, B.STATUS from V $ log A, V $ logfile b where A.Group # = b.group #
Switching log file ALTER SYSTEM SWITCH LOGFILE adds online recruit log file group ALTER DATABASE Add logfile ('E: /LOG/LOG3A.RDO', 'f: /log/log3b.rdo') Size 1M Add log file member ALTER DATABASE ADD Logfile Member 'e: /log/log4a.rdo' to group 3 Delete online redo log group ALTER DATABASE DROP LOGFILE Group 3; Remove online log file members
ALTER DATABASE DROP LOGFILE MEMBER 'E: /LOG /LOG3A.RDO' The Previous Statement Removes The logfile Member 'E: /LOG /LOG3A.RDO' from Group 3. Clear a corrupted log file Alter Database Clear logfile
The current redo log file is lost if the database is open and not hang
1. Determine the current log file group Select * from v $ log 2. Clear an unmature log file group * ALTER DATABASE CLEAR UnarchiveD logfile group #nbr 3. Complete database full backup
If the database is turned off (incomplete recovery) (Translator Note: The following is translated according to my understanding, with the original text)
1. Determine the current log file serial number Select * from v $ log 2. Restore database Recover Database Until Cancel; 3. Open Database ALTER DATABASE OPEN RESETLOGS; archive unidentified redo log file
Alter System Archive Log Current;
Archive all non-current redo log files
Alter System Archive Log ALL;
