Suppose you have a hot backup of a database taken on 11.2.0.2 and you want to restore it to a server where you have only 11.2.0.3 binaries installed, there is an option to open the database with the resetlogs option and also to start the database in upgrade mode ... you can do this :
....
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL>
SQL>
SQL> alter database noarchivelog ;
Database altered.
SQL> alter database open resetlogs upgrade ;
New Training Deep Dives: Handling Oracle Optimizer, Partitioning and
I/O-Intensive Databases
-
If you want to end the year by learning something practical and new, this
is it! I am running new special-focus deep dive seminars that address two
complex...
Acum 5 zile
Niciun comentariu:
Trimiteți un comentariu