Several concept issues, please enlighten me
I read a foggy water to see the book, I was dizzy and confused. I would like to teach. 1. Under what circumstances, you need to pay control files, for example, if I accidentally delete a data file, and there is no backup, and this data file is time spatial, no content, then, when the control file is done, the system will read it. The system view, re-record the files of the current normal status, so that the database can be restored. 2. When doing a database backup (about RMAN), see what is 0-level backup, first-level backup, etc. What is a 0-level backup, a level of backup, like a similar word, such as looking at incremental backup (Still talking about the RMAN), what is the meaning of "the same level, lower level", etc., what does this mean? 3. Doing incremental backups with EXP, what is the connection or difference between the concept of this incremental backup in the accumulated backup and RMAN?
Author: snowhite2000
Time: 02-04-06 06:53
Seeing the PM you left for me, I want to answer your questions in the forum. 1. Under what circumstances, you need to pay control files, for example, if I accidentally delete a data file, and there is no backup, and this data file is time spatial, no content, then, when the control file is done, the system will read it. The system view, re-record the files of the current normal status, so that the database can be restored. Seeing your question, Bai Xue red dust has been desperately thinking, once again re-establishing the Control File once, this is because to modify Database Name. What kind of situation is needed to re-establish control file: 1. Database all Control Files is all lost or corrupted (this seems unlikely, at least I didn't encounter lost or damaged cases) 2. You need to change some Database Define the parameter, such as MaxDataFiles, MaxLogfiles, MaxLoghistory. 3. If you want to make a bias, you don't want to change the Database name or you have to change all the DataFiles, logfiles' location, but also to complete with the recreate control file, such as you clone a Database to another. Machine, the system does not have the drive disc of your current DataFile. (For example, you are in the A system DataFiles all in F Drive, you cloned to the B system, only C Drive). Of course, you can use other methods to complete, thanks export / import. If you are willing to play the game of Rereate Control File, you can. But if there is Read Only TableSpaces this game is not very fun. Although the solution is also very simple. 4. Almost forgot, if your Database is sick, you want Oracle Support to help you, if he lets you rebuild the Control File, you probably not choose. I haven't thought about other cases. The situation you say in your question must be implemented by Rereate Control File. White snow and red dust
Author: snowhite2000
Time: 02-04-06 07:02
2. When doing a database backup (about RMAN), see what is 0-level backup, first-level backup, etc. What is a 0-level backup, a level of backup, like a similar word, such as looking at incremental backup (Still talking about the RMAN), what is the meaning of "the same level, lower level", etc., what does this mean? Regarding this problem, I think I first need to explain what is the RMAN DiffERENTIAL Incremental Backup and Cumulative Incremental Backup: refers to all changes of all changes after the recent Testa level or lower backup after all changes. (I Learn about your question). Cumulative Incremental Backup: Refers to all changes in all changes after the recent minimal level or lowering backup. About the level of the backup, only Level 0 Incremental Backup is a foundation backup, is a Full Backup . The figures of other Level are relative, no fixed requirements. For example: DifferenTial Incremental Backup Sunday: Level 0 Monday: Level 5 Tuesday: Level 5 Wednesday: Level 3 Explain that Sunday is full backup, Monday's BLOCKS has changed from Sunday backup, for Tuesday In terms of recent collections or low-level backups are Monday (all LEVEL 5), so it is a backup of changing blocks after backing up on Monday; on Wednesday is Level 3, the last level or lower backup is Sunday LEVEL 0, so it is backup for Blocks that has changed from Sunday backup. If Level 5 is changed to Level 2, Level 3 is replaced with level 1, the result is the same. Cumulative Incremental Backup Sunday: Level 0 Monday: Level 5 Tuesday: Level 5 Wednesday: Level 3 Thursday: Level 5 is explained as: Sunday is full backup, Monday to backup from Blocks that has changed from Sunday backup, for Tuesday In terms of recent collet - 1 or low backups are Sunday (Level 5 - 1 is Level 4 or lower), so it is still a backup of changing Blocks after Sunday backup; on Wednesday is Level 3, the last time The same level - 1 or lower backup is the LEVEL 0 on Sunday, so it is a backup of Blocks that has changed from Sunday backup. On Thursday, it is backup for changes in BLOCKs after backup on Wednesday, because Wednesday is Level 3, lower than Level 5 - 1. If Level 5 is changed to Level 2, Level 3 is replaced with level 1, the result is the same. Author: weishouqun
Time: 02-04-10 16:02
How to write the script of the white snow red dust How do I let the new Level 3 are Level 0? I found the LEVEL 3 prompt to find the parent backup or copy of the data file 1 when doing incremental backups. The backup file is large. It seems not Level 3
Author: weishouqun
Time: 02-04-10 16:13
My script is written create script level0bak {allocate channel d1 type disk; backup incremental level 0format 'd: / dbbak / a / df% s_% p' filesperset 5 (database include current controlfile); release channel d1;} create script level1bak {allocate channel d1 type disk; backup incremental level 1format 'd: / dbbak / a / df% s_% p' filesperset 5 (database include current controlfile); release channel d1;} performed level 1 data is not found when prompted a parent or a backup copy of the file can not find the data file 1 2 or parent backup copies ... in short parent backup of all data files can not be found or a copy please give pointers on January snow Red author: lunar2000
Time: 02-04-11 15:43
Quote:
Originally released by Weishouqun
My script is written create script level0bak {allocate channel d1 type disk; backup incremental level 0format 'd: / dbbak / a / df% s_% p' filesperset 5 (database include current controlfile); release channel d1;} create script level1bak {allocate channel d1 type disk; backup incremental level 1format 'd: / dbbak / a / df% s_% p' filesperset 5 (database include current controlfile); release channel d1;} performed level 1 data is not found when prompted File 1's parent backup or copy of the data file 2 is not found in the parent backup or copy of the data file ... In short, please find the parent backup or copy of all data files, please refer to the white snow, red dust, one or two
I'll try:
Create Script Level0Bak
{Allocate Channel D1 TYPE DISK;
Backup Incremental Level 0
Format 'd: / dbbak / a / df_full_% s_% p' filesperset 5
Database incrude current controlfile;
Release Channel D1;
}
Create Script Level2bak
{Allocate Channel D1 TYPE DISK;
Backup Incremental Level 2
Format 'D: / dbbak / a / df_level2_% s_% p' FilesPerset 5
Database incrude current controlfile;
Release Channel D1;
}
Create Script Level1bak
{Allocate Channel D1 TYPE DISK;
Backup Incremental Level 1
Format 'd: / dbbak / a / df_level1_% s_% p' FilesPerset 5
Database incrude current controlfile;
Release Channel D1;
}
Author: snowhite2000
Time: 02-04-12 03:06
You have performed a Level 0 before performing Level 1. If you have not performed Level 0, there is no way to execute Level 1. Is it right? Author: lunar2000
Time: 02-04-16 08:45
White snow, very old,
Author: snowhite2000
Time: 02-04-16 09:44
welcome!
Author: bellsz
Time: 02-05-13 17:09
About RMAN, there is a PDF in the forum, Johnwuwuwu wrote, very good
