[oracle@oracle-node-1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 28
13:54:49 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
oraclerac1
SQL> select name, log_mode from v$database;
NAME LOG_MODE
--------- ------------
ORACLERAC NOARCHIVELOG
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +FRA
Oldest online log sequence 5
Current log sequence 6
SQL>
SQL> alter system set cluster_database=false scope=spfile
sid='oraclerac1';
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition
Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic
Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real
Application Testing options
[oracle@oracle-node-1 ~]$ srvctl stop database -d oraclerac
[oracle@oracle-node-1 ~]$
[oracle@oracle-node-1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 28
13:58:10 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
mount;
ORACLE instance started.
Total System Global Area 4008546304 bytes
Fixed Size
2234560 bytes
Variable Size
838862656 bytes
Database Buffers
3154116608 bytes
Redo Buffers
13332480 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter system set cluster_database=true scope=spfile
sid='oraclerac1';
System altered.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition
Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic
Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real
Application Testing options
[oracle@oracle-node-1 ~]$ srvctl start database -d oraclerac
[oracle@oracle-node-1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 28
14:00:49 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> select name, log_mode from v$database;
NAME LOG_MODE
--------- ------------
ORACLERAC ARCHIVELOG
SQL> archive log list;
Database log mode Archive Mode
Automatic archival
Enabled
Archive destination +FRA
Oldest online log sequence 5
Next log sequence to archive 6
Current log sequence 6
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition
Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic
Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real
Application Testing options
[oracle@oracle-node-1 ~]$
No comments:
Post a Comment