Tuesday, 31 December 2013

RMAN startup and shutdown script

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\tinku>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: IACM (DBID=1011267594)

RMAN> run {
2> shutdown;
3> startup nomount;
4> alter database mount;
5> alter database open;
6> }

database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

database mounted

database opened

RMAN>

RMAN> run {
2> shutdown;
3> startup nomount;
4> alter database mount;
5> alter database open;
6> shutdown;
7> }

database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

database mounted

database opened

database closed
database dismounted
Oracle instance shut down

RMAN>

No comments:

Post a Comment