How to use RMAN for Stop/Start Oracle Database

Stop/Start Oracle Database from RMAN
Андрей Волков

Андрей Волков

Системное, сетевое администрирование +DBA. И немного программист!))  Профиль автора.

You can use RMAN to stop and start your database with methods that are almost identical to those available through SQL*Plus. When performing restore and recovery operations, it’s often more convenient to stop and start your database from within RMAN. The following RMAN commands can be used to stop and start your database:


  • SHUTDOWN
  • STARTUP
  • ALTER DATABASE

The SHUTDOWN command works the same from RMAN as it does from SQL*Plus. There are four types of shutdown: ABORT, IMMEDIATE, NORMAL, and TRANSACTIONAL. I usually first attempt to stop a database using SHUTDOWN IMMEDIATE; if that doesn’t work, don’t hesitate to use SHUTDOWN ABORT. Here are some examples:

RMAN> shutdown immediate;

RMAN> shutdown abort;

If you don’t specify a shutdown option, NORMAL is the default. Shutting down a database with NORMAL is rarely viable, as this mode waits for currently connected users to disconnect at their leisure. I never use NORMAL when shutting down a database.

As with SQL*Plus, you can use a combination of STARTUP and ALTER DATABASE commands with RMAN to step the database through startup phases, like this:

RMAN> startup nomount;

RMAN> alter database mount;

RMAN> alter database open;

Here is another example:

RMAN> startup mount;

RMAN> alter database open;

If you want to start the database with restricted access, use the DBA option:

RMAN> startup dba;

Image Tip  Starting with Oracle 12c, you can run all SQL statements directly from within RMAN without having to specify the RMAN sql command.

Вас заинтересует / Intresting for you:

RMAN: Specifying the Backup Us...
RMAN: Specifying the Backup Us... 2137 views Андрей Волков Sat, 29 Feb 2020, 10:14:03
RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 1266 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Checking for Corruption ...
RMAN: Checking for Corruption ... 18584 views Андрей Волков Thu, 30 Sep 2021, 11:57:27
RMAN: Backing UP Oracle Databa...
RMAN: Backing UP Oracle Databa... 549 views Андрей Волков Wed, 29 Sep 2021, 18:27:51
Comments (0)
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Suggested Locations