[root@cacti XE]# su - oracle
-bash-4.1$ ls
admin connect diag exit fast_recovery_area oradata oradiag_oracle product
-bash-4.1$ cd oradata/
-bash-4.1$ cd XE/
-bash-4.1$ ls
control.dbf sysaux.dbf system.dbf temp.dbf undotbs1.dbf users.dbf
-bash-4.1$ ll
total 1285700
-rw-r-----. 1 oracle dba 9748480 Dec 10 07:11 control.dbf
-rw-r-----. 1 oracle dba 744497152 Dec 10 07:10 sysaux.dbf
-rw-r-----. 1 oracle dba 377495552 Dec 10 07:10 system.dbf
-rw-r-----. 1 oracle dba 20979712 Dec 9 22:00 temp.dbf
-rw-r-----. 1 oracle dba 78651392 Dec 10 07:05 undotbs1.dbf
-rw-r-----. 1 oracle dba 104865792 Dec 8 12:41 users.dbf
-bash-4.1$ pwd
/u01/app/oracle/oradata/XE
-bash-4.1$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 11 10:47:30 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> alter system set control_files='/u01/app/oracle/oradata/XE/control.dbf' scope=spfile;
System altered.
SQL> startup force;
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2228080 bytes
Variable Size 322961552 bytes
Database Buffers 192937984 bytes
Redo Buffers 3809280 bytes
Database mounted.
Database opened.
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO EDITION
---------- --- ----------------- ------------------ --------- --- -------
1 XE
cacti.siltechconsult.com.br
11.2.0.2.0 11-DEC-14 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO XE
SQL>
0 comentários:
Post a Comment