Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Recovery of non system datafile which is not in the backup


SQL> create tablespace raj
datafile '/u01/app/oracle/venu/raj01.dbf' size 2m;
SQL> create user u2 identified by u2 dafault tablespace raj;
SQL> grant connect,resource to u2;
SQL> conn u2/u2
u2> create table a(a number);
u2> insert into a values(1);
u2> insert into a select * from a;
u2> /
u2> conn / as sysdba
SQL> select name from v$datafile;
SQL> select file#,name from v$datafile;

oracle venu> ls
oracle venu> rm raj01.dbf
oracle venu> ls

SQL> alter database datafile 5 resize 10m;
SQL> alter database datafile 5 offline;
SQL> alter database create
datafile '/u01/app/oracle/venu/raj01.dbf';
SQL> recover datafile 5;
SQL> alter database datafile 5 online;
SQL> conn u2/u2
u2> select count(*) from a;

Related Posts Plugin for WordPress, Blogger...

Flag Counter