Seed种子数据库还原Oracle数据库操作

实验环境：安装了Oracle11GR2软件的 Centos.4

实验目的：可利用seed种子文件还原Oracle数据库实例

实验步骤：

$ cd$ORACLE_HOME/dbs

$ cat init.ora | grep -v "^#" | grep -v "^$">initSEEDDATA.ora

$vi initSEEDDATA.ora

$cat initSEEDDATA.ora

$ mkdir -p /data/oracle/app/oracle/oradata/hpprdyx/

$ export ORACLE_SID=SEEDDATA

$sqlplus / as sysdba

SQL> create spfile from pfile;

SQL> startup nomount

SQL>!

$find /oracle -name Seed*.ctl

$cp /data/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.ctl

 to /data/oracle/app/oracle/oradata/hpprdyx/control01.ctl

$exit

SQL> alter database mount;

SQL> select member from v$logfile;

SQL> alter database rename file/ade/b/2125410156/oracle/oradata/seeddata/redo01.log' to'/data/oracle/app/oracle/oradata/hpprdyx/redo01.log';     

SQL> alter database rename file'/ade/b/2125410156/oracle/oradata/seeddata/redo02.log' to '/data/oracle/app/oracle/oradata/hpprdyx/redo02.log';

SQL> alter database rename file'/ade/b/2125410156/oracle/oradata/seeddata/redo03.log' to'/data/oracle/app/oracle/oradata/hpprdyx/redo03.log';

SQL> select member from v$logfile;

$ rman target /

RMAN> catalog start with '/data/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/templates/Seed_Database.dfb';

RMAN> report schema;

RMAN> run   {
   set newname for datafile 1 to '/data/oracle/app/oracle/oradata/hpprdyx/system01.dbf';
   set newname for datafile 2 to '/data/oracle/app/oracle/oradata/hpprdyx/sysaux01.dbf';
   set newname for datafile 3 to '/data/oracle/app/oracle/oradata/hpprdyx/undotbs01.dbf';
   set newname for datafile 4 to '/data/oracle/app/oracle/oradata/hpprdyx/user01.dbf';
   restore database;
   switch datafile all;
   recover database;
    }

RMAN> exit

$sqlplus / as sysdba

SQL> alter database open resetlogs;

SQL> alter tablespace temp add tempfile '/data/oracle/app/oracle/oradata/hpprdyx/temp01.dbf' size 100M;
SQL> select name from v$tempfile;

SQL> alter tablespace temp drop tempfile '/ade/b/2125410156/oracle/oradata/seeddata/temp01.dbf';

SQL> show parameter inst

SQL> shutdown immediate

SQL> startup mount

SQL> exit

$nid target=sys/ora_sys dbname=hpprdyx

$cd $ORACLE_HOME/dbs

$cp initSEEDDATA.ora inithpprdyx.ora

$cat inithpprdyx.ora

export ORACLE_SID=hpprdyx

$sqlplus / as sysdba

SQL>create spfile from pfile;

SQL>startup

SQL>show parameter inst

参考资料：

DBCA seed文件原理可以参考杨建荣老师的

深入理解Oracle中的DBCA

如果您喜欢我的文章，请长按标识符关注我的公众号，学习Linux的路上，期待与您同行。