ORACLE::Steps to take care prior server startup or server shutdown or any maintenance in Oracle DATABASE SERVER
>>SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME CON_ID
---------- ------------------ ---------- --------- ----------
1 ACTIVE 392093972 30-JUN-22 1
3 ACTIVE 392093980 30-JUN-22 1
4 ACTIVE 392093988 30-JUN-22 1
5 NOT ACTIVE 0 2
6 NOT ACTIVE 0 2
7 ACTIVE 392093996 30-JUN-22 1
8 NOT ACTIVE 0 2
9 NOT ACTIVE 0 3
10 NOT ACTIVE 0 3
11 NOT ACTIVE 0 3
12 NOT ACTIVE 0 3
FILE# STATUS CHANGE# TIME CON_ID
---------- ------------------ ---------- --------- ----------
13 NOT ACTIVE 0 1
14 NOT ACTIVE 0 1
15 NOT ACTIVE 0 1
16 NOT ACTIVE 0 1
17 NOT ACTIVE 0 1
18 NOT ACTIVE 0 1
17 rows selected.
>>If any active,then wait for it to complete.
>>Then shut immediate
SQL> alter system switch logfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
>>Then handover server to windows team for patch or any maintenance to avoid unnecessary surprises.
No comments:
Post a Comment