It seems that the Controlfile records are over-written.
1. check control_file_record_keep_time
show parameter control
NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 7
The value is very low. So please increase.
alter system set control_file_record_keep_time=20 scope=both;
System altered.
SQL> show parameter control
NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 20
2) Next you need to catalog the archivelogs to make the backup run without errors
RMAN> catalog start with '/u01/archive';
3. Now start the backup
NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 7
The value is very low. So please increase.
alter system set control_file_record_keep_time=20 scope=both;
System altered.
SQL> show parameter control
NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 20
2) Next you need to catalog the archivelogs to make the backup run without errors
RMAN> catalog start with '/u01/archive';
3. Now start the backup
No comments:
Post a Comment