- Before executing check whether HA is deploye and take necessary precautions (cluster freeze).
- Consider impact on backup of the DB, full backup is required to restore data.
- Data changes between full backups will be lost in case of restore
oracle@hostname:/oracle > sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on Mon Feb 6 01:36:08 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL> set line 9090
SQL> SHOW USER
USER is „SYS“
Step -1)
Check the Existing mode in your Database
SQL> SELECT LOG_MODE FROM V$DATABASE;
LOG_MODE
————
ARCHIVELOG
Step -2)
Shut Down Your Database Cleanly to Disable Archiving Mode .
SQL> SHUT IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
Step -3)
Start up Your Database in Mount Stage .
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 603979776 bytes
Fixed Size 1250380 bytes
Variable Size 281021364 bytes
Database Buffers 314572800 bytes
Redo Buffers 7135232 bytes
Database mounted.
Step -4)
SQL> ALTER DATABASE NOARCHIVELOG;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
