-
Start a new instance and mount, but do not open, the database.
STARTUP MOUNT
To enable or disable archiving, the database must be mounted but not open.
-
Change the database archiving mode. Then open the database for normal operations.
ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN;
-
Shut down the database.
SHUTDOWN IMMEDIATE
-
Back up the database.
Changing the database archiving mode updates the control file. After changing the database archiving mode, you must back up all of your database files and control file. Any previous backup is no longer usable because it was taken inNOARCHIVELOG
mode.
Tuesday, April 16, 2013
Oracle: change DB to archivelog mode
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment