更新时间:2022-10-04 18:59:43
--显示控制文件
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/
|
SQL> startup
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2220200 bytes
Variable Size 2113933144 bytes
Database Buffers 2147483648 bytes
Redo Buffers 12144640 bytes
Database mounted.
Database opened.
SQL> exit
|
select 'host cp /u03/backup/'||substr(name,(instr(name,'/',-1)+1))||
' '||name from v$controlfile
union all
select 'host cp /u03/backup/'||substr(name,(instr(name,'/',-1)+1))||
' '||name from v$controlfile
union all
select 'host cp /u03/backup/'||substr(member,(instr(member,'/',-1)+1))
||' '||member from v$logfile
union all
select 'host cp /u03/backup/spfile${ORACLE_SID}.ora $ORACLE_HOME/dbs/'
from dual
union all
select 'host cp /u03/backup/orapw${ORACLE_SID} $ORACLE_HOME/dbs/'
from dual;
|