Suggestions on daily Oracle Management

Oracle is not a good bowl of rice. There are many risks and suggestions.
1. Incomplete recovery based on time points requires brainwashing of the control file, tearing up the account book (redo the log), and re-printing the account book. This is a road without looking back and needs to protect the site, leave a path for yourself. Remember to back up the entire database, even a few TB. The process is as follows:
1) shutdown immediate
2) startup mount
3) cp the entire database.
4 )........ (Everyone understands the next step and won't be nagging)
 
2. Sort out reasonable rman initial backup solutions
1) delete backup
2) backup archivelog all delete all input
3) backup tag 'in in _ full_0_backup 'incremental level 0 database plus archivelog;
Through the above sorting, five rman backups are left in the flash back area, which is simple and clear. Remember to copy the previous ones.
 
3. Remember to maintain the/home/oracle directory because it also affects performance.
 
4 flash_recovery_area: by default, oracle stores backup-related files, such as rman backup, control files and log files, and archive log backup. Therefore, this region is full, remember to clean up. Otherwise, an error will be reported during Backup. However, the image of the control file and log file must be left behind during cleaning.
 
5. Based on the business needs, we suddenly need to shut down large databases. After waiting for a long time, we can't close the database, but we can quickly turn it off. What should we do?
1) First, kill all connected sessions;
2) alter system checkpoint;
3) shutdown abort;
Minimize the impact so that the database can be opened normally next time.
 
6. Redo the log group to avoid multiple active groups. Because there is no RBA and no start point for roll-forward on the active node.
 
7. The system tablespace cannot store business tables. It is not recommended that a tablespace correspond to only one data file. It is not recommended that a redo log group be too large.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12