startup upgrade and open resetlogs

Suppose you have a  hot backup of a database taken on and you want to restore it to a server where you have only 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}
Media recovery cancelled.
SQL> alter database noarchivelog ;

Database altered.

SQL> alter database open resetlogs upgrade ;

Niciun comentariu:

Trimiteți un comentariu