Steps to enable Archivelog mode in RAC environment:
The following steps need to be taken to enable archive logging in a RAC database environment:
1. Shutdown immediate all database instances
$ srvctl stop database -d <db_unique_name>
2. Startup database in mount mode
$ srvctl start database -d <db_unique_name> -o mount
3. Enable archive logging
$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;
4. Stop database
$ srvctl stop database -d <db_unique_name>
5.Start all database instances
$ srvctl start database -d <db_unique_name>
6.Verify archiving is enabled/disabled
sql> archive log list;
The following steps need to be taken to enable archive logging in a RAC database environment:
1. Shutdown immediate all database instances
$ srvctl stop database -d <db_unique_name>
2. Startup database in mount mode
$ srvctl start database -d <db_unique_name> -o mount
3. Enable archive logging
$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;
4. Stop database
$ srvctl stop database -d <db_unique_name>
5.Start all database instances
$ srvctl start database -d <db_unique_name>
6.Verify archiving is enabled/disabled
sql> archive log list;
sccm training
ReplyDelete