Is it possible to restore 12CR2 rman backup into 12CR1 database ?
1. We can restore higher version DB backup on lower version oracle binaries, but you will not be able to open it without downgrading.
Basically, in this scenario RMAN is just file copy tool i.e. we are restoring 12.2 DB backup on 12.1 binaries, but once restore/recovery is done you need to downgrade DB. It is similar to downgrading any other DB after restore/recovery.
If compatible parameter is already increased to 12.2, downgrade is not possible.
2.For downgrade, best approach is :
-- First install 12.2 binaries on destination server.
-- Do RMAN restore/recovery on these 12.2 binaries.
-- Open DB.
<< Above are RMAN related steps >>
-- Now can downgrade DB( if compatible parameter is not increased ) using lower version binaries.
Here, we are separating RMAN and downgrade steps. It would be easy to troubleshoot any problem in this case. If we restore DB on 12.1 binaries directly, then it need to be opened with 'alter database open resetlogs downgrade' and downgrade steps are run. i have seen problem with this open statement in many cases. Using same version binaries to open DB before starting downgrade steps is better
1. We can restore higher version DB backup on lower version oracle binaries, but you will not be able to open it without downgrading.
Basically, in this scenario RMAN is just file copy tool i.e. we are restoring 12.2 DB backup on 12.1 binaries, but once restore/recovery is done you need to downgrade DB. It is similar to downgrading any other DB after restore/recovery.
If compatible parameter is already increased to 12.2, downgrade is not possible.
2.For downgrade, best approach is :
-- First install 12.2 binaries on destination server.
-- Do RMAN restore/recovery on these 12.2 binaries.
-- Open DB.
<< Above are RMAN related steps >>
-- Now can downgrade DB( if compatible parameter is not increased ) using lower version binaries.
Here, we are separating RMAN and downgrade steps. It would be easy to troubleshoot any problem in this case. If we restore DB on 12.1 binaries directly, then it need to be opened with 'alter database open resetlogs downgrade' and downgrade steps are run. i have seen problem with this open statement in many cases. Using same version binaries to open DB before starting downgrade steps is better
No comments:
Post a Comment