Oracle????????????????/???
???????????? ???????[ 2014/8/29 11:43:15 ] ????????????? Oracle ????
???????д????????????????????????????о??в?????????????????????????д??????????????????????????????
??????????CentOS release 5.6 (Final)
????Oracle Database Release 11.2.0.1.0
????1??????????????????????????
????[root@OATest oabak]# tar -jxvf testoa_20140702.tar.bz2
????2????????
????[root@OATest temp]# su - oracle
????[oracle@OATest /]$ export ORACLE_SID=testoa
????[oracle@OATest /]$ sqlplus "/as sysdba";
????OPEN_MODE
????--------------------
????READ WRITE
????3??????????
????SQL> shutdown immediate;
????Database closed.
????Database dismounted.
????ORACLE instance shut down.
????SQL> exit
????4????sql??????????????????????????????????????????????·????????????????·????
--??????????
select name from v$controlfile;
--??????????
select name from v$datafile;
--?????????????????????(??????:???????????????????????????????????????)
show parameter spfile;
--?????????
select member from v$logfile;
--orapw$ORACLE_SID?????????password file·?? ??$ORACLE_HOME/dbs/orapw$ORACLE_SID //???????????????????????ɡ?
[oracle@OATest temp]$ sqlplus "/as sysdba";
host cp /usr/oabak/temp/control01.ctl /app/oracle/oradata/testoa/control01.ctl
host cp /usr/oabak/temp/control02.ctl /app/oracle/flash_recovery_area/testoa/control02.ctl
host cp /usr/oabak/temp/system01.dbf /app/oracle/oradata/testoa/system01.dbf
host cp /usr/oabak/temp/sysaux01.dbf /app/oracle/oradata/testoa/sysaux01.dbf
host cp /usr/oabak/temp/undotbs01.dbf /app/oracle/oradata/testoa/undotbs01.dbf
host cp /usr/oabak/temp/users01.dbf /app/oracle/oradata/testoa/users01.dbf
host cp /usr/oabak/temp/redo03.log /app/oracle/oradata/testoa/redo03.log
host cp /usr/oabak/temp/redo02.log /app/oracle/oradata/testoa/redo02.log
host cp /usr/oabak/temp/redo01.log /app/oracle/oradata/testoa/redo01.log
host cp /usr/oabak/temp/spfile${ORACLE_SID}.ora $ORACLE_HOME/dbs/
host cp /usr/oabak/temp/orapw${ORACLE_SID} $ORACLE_HOME/dbs/
????--???????????? ????????????????temp01.dbf
????????????????????????????????
????ORA-01187: cannot read from file because it failed verification tests
????ORA-01110: data file 201: '/app/oracle/oradata/testoa/temp01.dbf'
????????????????????????????????????????300MB)??????????μ?????????????500MB) ..??????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11