[oracle@pard15 ~]$. oraenv
ORACLE_SID = [oracle]STG1
The Oracle base has been changed from /u01/app/oracle to /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:12:55 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +RECO
Oldest online log sequence 26114
Next log sequence to archive 26116
Current log sequence 26116
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, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$srvctl stop database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is not running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl start instance -i STG1 -d STG -o mount
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:15:01 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select inst_id,instance_name,status from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ---------------- ------------
1 STG1 MOUNTED
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +RECO
Oldest online log sequence 26114
Next log sequence to archive 26116
Current log sequence 26116
SQL> alter database noarchivelog;
Database altered.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +RECO
Oldest online log sequence 26114
Current log sequence 26116
SQL> alter database open;
Database 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, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl stop instance -i STG1 -d STG
[oracle@pard15 ~]$srvctl start database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:17:57 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select inst_id,instance_name,status from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ---------------- ------------
1 STG1 OPEN
2 STG2 OPEN
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +RECO
Oldest online log sequence 26114
Current log sequence 26116
ORACLE_SID = [oracle]STG1
The Oracle base has been changed from /u01/app/oracle to /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:12:55 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +RECO
Oldest online log sequence 26114
Next log sequence to archive 26116
Current log sequence 26116
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, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$srvctl stop database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is not running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl start instance -i STG1 -d STG -o mount
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:15:01 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select inst_id,instance_name,status from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ---------------- ------------
1 STG1 MOUNTED
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +RECO
Oldest online log sequence 26114
Next log sequence to archive 26116
Current log sequence 26116
SQL> alter database noarchivelog;
Database altered.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +RECO
Oldest online log sequence 26114
Current log sequence 26116
SQL> alter database open;
Database 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, OLAP,
Data Mining and Real Application Testing options
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is not running on node pard16
[oracle@pard15 ~]$srvctl stop instance -i STG1 -d STG
[oracle@pard15 ~]$srvctl start database -d STG
[oracle@pard15 ~]$srvctl status database -d STG
Instance STG1 is running on node pard15
Instance STG2 is running on node pard16
[oracle@pard15 ~]$. oraenv
ORACLE_SID = [STG1] ?
The Oracle base remains unchanged with value /u02/app/oracle
[oracle@pard15 ~]$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 10 07:17:57 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select inst_id,instance_name,status from gv$instance;
INST_ID INSTANCE_NAME STATUS
---------- ---------------- ------------
1 STG1 OPEN
2 STG2 OPEN
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +RECO
Oldest online log sequence 26114
Current log sequence 26116
No comments:
Post a Comment