A little interesting test, rman recovery times wrong, trouble friends and see what is wrong-CodePudding

Excuse me each friend, made a small test today, put all of the data file, archive and control files deleted entirely, and then use the original full backup data recovery, recover the database when I feel like he can't find my archive file backup, this is how to return a responsibility? Know why trouble friend answer, very grateful

CodePudding user response:

An error obviously, recover lack the necessary archive logs!

CodePudding user response:

reference 1st floor liuzhijian2008x response:

error obviously, recover lack the necessary archive log.

reference 1st floor liuzhijian2008x response:

error obviously, recover lack the necessary archive log.

Yes, I put the data file and archive files are deleted, but I use a backup before delete archivelog all will backup all the backup file a ah, why is it not to look for the file backup file

CodePudding user response:

Backup and backup complete log or have filed, you return to your archive log the biggest SCN, try, you can use the list backup acrhivelog look, look at the SCN data file, try do not fully recovered

CodePudding user response:

Recovery process is wrong, you can only do this situation is not fully recovered,

CodePudding user response:

The building Lord says overall your backup and recovery process,

CodePudding user response:

refer to the second floor wzf0703 response:

Quote: refer to 1st floor liuzhijian2008x response:

Error obviously, recover lack the necessary archive log.

reference 1st floor liuzhijian2008x response:
error obviously, recover lack the necessary archive log.

Yes, I put the data file and archive files are deleted, but I use a backup before delete archivelog all will backup all the backup file a ah, why it won't go looking for the backup archive file

Do you have any backup database? Your statement just backup archive logs,
You whether the archive logs are after backing up the database, the log an error log number is 1, it seems there is no backup database,
Normal rman recovery is to restore and then recover, estimates that you did not even do that restore

CodePudding user response:

refer to 6th floor liuzhijian2008x response:

Quote: refer to the second floor wzf0703 response:

Quote: refer to 1st floor liuzhijian2008x response:

Error obviously, recover lack the necessary archive log.

reference 1st floor liuzhijian2008x response:
error obviously, recover lack the necessary archive log.

Yes, I put the data file and archive files are deleted, but I use a backup before delete archivelog all will backup all the backup file a ah, why it won't go looking for the backup archive file

Do you have any backup database? Your statement just backup archive logs,
You whether the archive logs are after backing up the database, the log an error log number is 1, it seems there is no backup database,
Normal rman recovery is to restore and then recover, estimates that you did not even do that restore

I said under my whole process:
I will backup the database for servicing, (at the same time automatic backup control file),
Then I in the newly built a table test, submit completed backup archivelog all again, I will back up the archive,
Backup is completed I put oradata \ wouldn \ under all data files, control files and archive all deleted,
Resume:

1, nomount state: : restore conotrolfile the from... (this step no problem)
2: the mount state: restore the database;
3: : mount condition: recover the database, and then to the above is wrong, I think because I'm the new test table and remove the archive log files, so it can not recover, but before I have backup archive log files, I think it will recover from the archive log backup, it does not, however, is the result to the above error,
I also try to use the restore archivelog all, still an error

CodePudding user response:

reference baidu_36457652 reply: 3/f

backup and backup complete log or archive, you return to your archive log the biggest SCN, try, you can use the list backup acrhivelog look, look at the SCN data file number do not fully recover try

reference 5 floor wmxcn2000 reply:

the original poster said overall said your backup and restore process,

You come to see

CodePudding user response:

To restore archivelog see tips

CodePudding user response:

After you open the archive mode, first a few log backup again, to see if the follow-up can recover again