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

This article introduces to you what is the difference between the four sentences of recover database, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1 recover database using backup controlfile

2 recover database until cancel

3 recover database using backup controlfile until cancel

4 recover database until cancel using backup controlfile

The results are as follows:

If the control file is lost, after the control file backed up by restore, you must use the using backup controlfile option. On the other hand, until cancel is not fully recovered, that is, if the current/active redo is lost, or an archive file is missing from the restore database, it is terminated.

Conclusion:

1. It is applicable to the old control files of restore, and there is no loss of archived logs and cuurrent/active redo. If all archived logs and online logs are intact, data can not be lost. Similar to recover database

2. The current control file is not lost (the old control file of restore is not required). If the archive log or current/active log is lost, it will be terminated. Maximum possible recovery of data

3, 4: the effect of my test in oracle 10.2.0.4 environment is the same, that is, it is applicable to the old control file of restore. After restoring to the backup of the control file, the system will prompt you to apply the archive log after the backup of the control file. If not, stop. It is also the most possible way to recover data.

As a result, if you have an old database backup, use recover database or recover database using backup controlfile when all the archived and online logs are well preserved. No data is lost.

If the archive log or online log (active, current) is lost after the backup data file restore, you can recover to the previous archive log that was lost.

Until cancel just doesn't fully recover.

Alter database open resetlogs is required

After opening the database, you need to understand how to make a full database backup.

Online log files are missing:

If you shut down the database normally, and then start the Times error:

SQL > alter database open

Alter database open

*

An error occurred on line 1:

ORA-00313: cannot open a member of log group 1 (for thread 1)

ORA-00312: online log 1 thread 1:

'C:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ REDO01.LOG'

SQL > alter database open resetlogs

Alter database open resetlogs

*

An error occurred on line 1:

ORA-01139: the RESETLOGS option is valid only after an incomplete database recovery

SQL > recover database until cancel

Complete the media recovery.

SQL > alter database open resetlogs

The database has changed.

There will be no data loss at this time

On the difference between the four sentences of recover database what is shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.