Shulou(Shulou.com)06/01 Report--

Four full recovery scenarios in archive mode 1. The database is open and the ordinary data file is corrupted. The table space where the data files are located is offline (immediate) copy the files in the backup, and go to the specified path recover to restore the table space where the data files are located. When the database is closed, files such as system files and undo tablespaces are corrupted. Start the files in the MOUNT copy backup and restore the lost files to the specified path to restore the lost files 3. Database closed state, deleted the normal data file. Copy the files in the backup in the MOUNT state, and open the recover recovery files to the specified path 4. During the database opening phase, the new data file was corrupted. Table space where the data files are located offline (immediate) recreate an empty data file to restore the missing data files in the table space online RMAN three incomplete recovery scenarios after resetlogs starts the database, the original backup is still available. Delete user example tag timestamp delete user example MOUNT status connection rman uses rman anonymous block run {set until time to_timestamp ('xxxx-xx-xx xx:xx:xx' 'yyyy-mm-dd hh34:mi:ss') restore database Recover database;} use resetlogs to open the library; 2. Delete all data files, log files, control files to the directory of data files, delete all files nomount connection rman specify control file path, restore control files restore controlfile from 'xxxxxxxxxxxxxxxxxxxxxx' MOUNT state restore database restore database Using sequence-based incomplete recovery run {set until sequence 1; recover database;} using resetlogs to open the database; 3. There is a backup, but there is a problem with the backup set, or the archive file is missing. First of all, add the following three implicit parameters _ allow_resetlogs_corruption=true _ corruption_rollback_segments=true _ offline_rollback_segments=true to pfile to start MOUNT resetlogs to force the opening of the library.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.