This is a premium alert message you can set from Layout! Get Now!

Enable Archive Log Mode In Oracle RAC

Anup
0

 1. stop the database service.

    srvctl stop database -d PROD

2. start the database in mount state.

srvctl start database -d PROD -o mount

3. enable archive log mode.

alter database archivelog;

4. Restart the database service (using srvctl)

srvctl stop database -d PROD

srvctl start database -d PROD

5. set the archive destination to a ASM DISK

SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/' scope=both sid='*';

System altered.

SQL> archive log list

SQL> alter system switch logfile;

System altered.

Tags

Post a Comment

0 Comments

Please Select Embedded Mode To show the Comment System.*

Post a Comment
To Top