Enable Archive Log Mode In Oracle RAC 11g
To check the status:
[oracle@rac1 ~]$ srvctl status database -d PROD
Instance PROD1 is running on node rac1
Instance PROD2 is running on node rac2
To stop the database:
[oracle@rac1 ~]$ srvctl stop database -d PROD -o immediate
To check the status:
[oracle@rac1 ~]$ srvctl status database -d PROD
Instance PROD1 is not running on node rac1
Instance PROD2 is not running on node rac2
To mount the database:
[oracle@rac1 ~]$ srvctl start database -d PROD -o mount
To enable archivelog:
SQL> alter database archivelog;
To restart the database:
[oracle@rac1 ~]$ srvctl stop database -d PROD -o immediate
[oracle@rac1 ~]$ srvctl status database -d PROD
Instance PROD1 is not running on node rac1
Instance PROD2 is not running on node rac2
To start the database:
[oracle@rac1 ~]$ srvctl start database -d PROD
[oracle@rac1 ~]$ srvctl status database -d PROD
Instance PROD1 is running on node rac1
Instance PROD2 is running on node rac2
To set the archive destination to a ASM DISK:
alter system set log_archive_dest_1='LOCATION=+DATA/ARCH/' scope=both sid='*';
For disabling archive mode:
srvctl stop database -d PROD
srvctl start database -d PROD -o mount
alter database noarchivelog;
srvctl stop database -d PROD
srvctl start database -d PROD
No comments:
Post a Comment