3.2.4 Recovery

Recover the Oracle Database according to the necessity of Oracle stop.

Information

When Oracle must be stopped to recover the Oracle Database:

The data file belongs to SYSTEM tablespace or UNDO tablespace
The whole database is recovered
Incomplete recovery is performed

When Oracle does not have to be stopped to recover the Oracle Database:

The data file does not belong to SYSTEM tablespace or UNDO tablespace
Complete recovery is performed

For details, see the Oracle manual

3.2.4.1 Oracle must be stopped

If Oracle must be stopped, recovery the Oracle Database as follows. If there are Oracle-dependent resources (e.g. SAP R/3), a resource failure might occur during Oracle stop, so it is necessary to stop them manually in advance.

userApplication stop
```
# hvutil -f <userApplication>
```
Monitoring disruption
Resource which monitoring is stopped by hvoradisable command will not start up even if the userApplication starts up. Using this function, the resources other than Oracle can start up.
```
# hvoradisable -a <userApplication>
```
Confirmation of stop of monitoring
Confirm that stop of monitoring has been successfully done.
(Refer to note of "4.1 hvoradisable - Discontinue Monitoring Resources".)
userApplication startup
```
# hvswitch <userApplication>
```
Recovery
Recover the database.

Oracle instance and listener startup

# su - <Oracle user>
$ lsnrctl start <Listener>
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup

Monitoring restart
```
# hvoraenable -a <userApplication>
```
Confirmation of restart of monitoring
Confirm that restart of monitoring has been successfully done.
(Refer to note of "4.2 hvoraenable - Restart Monitoring Resources".)

3.2.4.2 Oracle does not need to be stopped

If the Oracle does not need to be stopped, recover the Oracle Database as follows;

Maintenance mode / Monitoring disruption

# hvutil -m on <userApplication> (Maintenance mode)
# hvoradisable -a <userApplication> (Monitoring disruption)

Confirmation of maintenance mode and stop of monitoring
Confirm that changing into maintenance mode and stop of monitoring have been successfully done.
(Refer to note of "4.1 hvoradisable - Discontinue Monitoring Resources".)
Recovery
Recover the database. Be sure to check if the Oracle instance and listener are properly running before going on to the next step.

Monitoring restart / Maintenance mode stop

# hvoraenable -a <userApplication> (Monitoring restart)
# hvutil -m off <userApplication> (Maintenance mode stop)

Confirmation of restart of monitoring and maintenance mode
Confirm that restart of monitoring and changing out of maintenance mode has been successfully done.
(Refer to note of "4.2 hvoraenable - Restart Monitoring Resources".)