Listen Software Solution "How to" Series 5: Log files

Solve


Listen Software Solution "How to" Series 5: Log Files





Create the database with the instance Manager (Oracle9i is abolished, so omitted)


Create a development environment (omitted)





log File





all relevant log files


Reset Log Option


completes a full cold backup


1 Creates a database prototype, placing a new SCN in the head of all database files.


2) Reset log serial number to 1


3 If present, reformat the online redo log





unintentionally resuming online redo logs


When you restore a database, you may accidentally resume an online redo log. This will force a complete recovery rather than a full recovery.





status and position:


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#





Switch log file


Alter System Switch logfile





Add online redo log filegroup


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;


 


 


Delete an online log file member





Alter Database drop logfile member


' E:\log\log3a.rdo '


The previous statement removes


the logfile member ' E:\log\log3a.rdo '


from GROUP 3.


 


clears a corrupted log file


Alter Database Clear Logfile





The current redo log file is missing





If the database is open rather than suspended





1. Determine the current log filegroup


SELECT * from V$log


2. Clear the Archive log filegroup


* ALTER DATABASE clear unarchived


logfile Group #nbr


3. Complete full Database backup








If the database is in a closed state (incomplete recovery) (Translator Note: The following according to my understanding, and the original version of the discrepancy)





1. Determine the current log file sequence number


SELECT * from V$log


2. Restore Database


recover database until cancel;


3. Open Database


ALTER DATABASE open resetlogs;


 


Archive of archived redo log files





ALTER SYSTEM ARCHIVE LOG current;





Archive all non-current redo log files





ALTER SYSTEM ARCHIVE LOG all;