oracle10g数据库备份与还原总结

1、oracle log数据库备份与还原总结oracle 10g database backup and restore summary. txt is in a bad mood toda y. i only have four sentences to say. in eluding this and the preceding two sentences my words are more wicked than he is to deal with the wicked. to deal with a despicable man is to be more despicable than

2、 he is, and to be in love with you, my lover the cashier said: "there's no change find you two plastic bags!three archive modeyou can prevent data lossthe data can be backed up when it is openwhen the medium fails, the rest of the data file in the system table space can be recovered from th

3、e open statethe complete recovery can also be restored to a point between the backup point and the failure point1. backup1) cold backupcopy the required data files and control files after shutdown2) hot backupset the database to archive modeissue the global checkpoint on the database and lock the he

4、ader blocks of all the data filessql > alter database begin backup;backup data files and control filesdata files are copied directly to other directoriesthe control file should use the alter database backup controlfilesql > alter database backup controlfile to 'd: backup dem. cttto end the

5、 data backup, the current log group should also be archived to ensure the synchronization of the data file backupsql > alter database end backup;sql > alter system archive log cuurent;3) back up the table space* offline backup (the table space is offline, the system table space and the unused

6、undo space are not offline)©determines the data file that is included in the table space, such as space userssql > select file_name from dba_data_fileswhere tablespace_name 二'users'set the table space to be offlinesql > alter in tablespace users offline;copy the data fileset the t

7、able spaces onlinesql > alter in tablespace users online* online backupidentify the corresponding relationshipset tablespaces for backup modesql > alter tablespace users begin backup;copy the data fileset tablespaces for normal modesql > alter tablespace users end backup* the online backup

8、failedwhen performing the online backup, if appear routine failure, open the database again, if the data file is still in the readystate, will go wrong, the need to end the backup load databasesql > startup force mountcheck all the data files in the online backup statesql > select file# from v

9、 $backup where status 二'active'end online backup statussql > alter in tablespace end backupor alter in tablespace datafile backup;or recover datafile serial number open the databasesql > alter database open;2. the reduction1) fully recoveredrelevant command:recover database: restore mu

10、ltiple data files of the database (running in mount state)recover tadaspace: restore all data files in multiple tablespaces (running in open state)recover datafile: restore one or more data files (in mount, open state)* restore data files (for system table space recovery) under mountload the databas

11、e mount stateidentify the data files that need to be restoredsql > select file#, error from v $recover_filecopy back to the original positionrestore database recover the above commandopen the database alter database open;* restore the data file that is accidentally opt-out after the shutdown is o

12、pen, and the database will not openload database mountidentify the data files that need to be restoredmake the corresponding data file offlinesql > alter database datafile 4 offline; open the databasesql > alter database opencopy the data backup filerestore the data filethe is the data file on

13、line alter database datafile 4 online;* restore the data file that was accidentally lost while opendetermine the data file to be restoredmake the data file offlinecopy the data filerestore the corresponding tablespace or data fileonline for the corresponding table space or data file* in the open sta

14、te recovery not backup data file (requirements in archive mode, a new data file, its starting your resume all the archive logs must exist)load databasedetermine the data file to be restoredthe is the data file offline open the databasere-establish the data filesql > alter database create datafile

15、 ' d: demo userso 1. dbf'restore the data filemake the data file online2) incomplete recoveryuse the backup data file, archive logs, and redo logs, to restore a database backup between point and the point of failure at the moment* return classificationtime-based recovery: error-delete tables

16、, mistruncated tables, and submitted incorrect databased on teasing recovery: the state that was before a certain log sequence number was restoredscn based recovery: restore to a specific scn value statebackup control file recovery: the table space is accidentally deleted, or all control files are c

17、orrupted* incomplete recovery instructionsrecoverdatabase untilthe timerecoverdatabase untilchangerecoverdatabase untilcancelrecoverthe database. using backup controlfile* time-based recoveryclose the database (to prevent backup failure, you should back up all files of the current databaseload datab

18、ase startup mountcopy all backup data files and determine the time points of the backup filessql > select fileto_char (time, j yyyy-mm-dd hh24: mi: ss)the from v srecover file;execute recover database until timesql > recover database until time 2006-09-26 16:40:33open the database with the res

19、etlogs method and check the recovery resultssql > alter database open resetlogs; database backup all data files and control files, because when to open the database resetlogs way will be re-established after redo log, empty all the contents of the original redo log, and the log sequenee number is

20、 reset to 1sql > select name from v $datafile;sql > alter database begin backup;copy data filesql > alter database end backup;sql > alter database backup controlfile'to' d: backup demctl 'sql > alter system archive log cuurent;* based on scn recoveryclose the databaseload

21、database mountcopy all backup data files to determine the backup file scn valuessql > select file#, change#, from v $recover_file;execute recover database until changesql > recover database until change 675978;open the database by resetlogsbackup database all data files and control files* based on the cancellation