Database in Archive log Mode


  • Database in Archive log Mode, Flashback On and Force Logging
i. [oracle@crs1 ~]$ srvctl STOP DATABASE -d crsdb
ii. [oracle@crs1 ~]$ sqlplus / AS SYSDBA
iii. SQL> STARTUP MOUNT EXCLUSIVE;
iv. SQL> ALTER DATABASE ARCHIVELOG;
Database altered.
v. SQL> ALTER DATABASE FLASHBACK ON;
Database altered.
vi. SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
vii. SQL> ALTER DATABASE OPEN;
Database altered.
viii. [oracle@crs1 ~]$ srvctl START INSTANCE -i crsdb2 -d crsdb
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: