NAVEEN

Tuesday, December 29, 2009

Restore point creation

create table gua_test( no varchar2(5));

insert into gua_test values (1);
insert into gua_test values (2);
insert into gua_test values (3);
insert into gua_test values (4);
insert into gua_test values (5);

Commit;

select count(*) from gua_test;


sysdba
----------

shu immediate

startup mount

create restore point five_rows guarantee flashback database;


odb user
---------

insert into gua_test values (6);
insert into gua_test values (7);
insert into gua_test values (8);
insert into gua_test values (9);
insert into gua_test values (10);

commit;

select count(*) from gua_test;


sysdba
----------

shu immediate

startup mount

flashback database to restore point five_rows;

alter database open resetlogs;


odb user
---------

select count(*) from gua_test;

result - 5 rows

---------------------------------------------------------------------------------------------------------------------------

odb user
---------

insert into gua_test values (6);
insert into gua_test values (7);
insert into gua_test values (8);
insert into gua_test values (9);
insert into gua_test values (10);

commit;

select count(*) from gua_test;

15

sysdba
----------

create restore point ten_rows guarantee flashback database;



odb user
---------

insert into gua_test values (11);
insert into gua_test values (12);
insert into gua_test values (13);
insert into gua_test values (14);
insert into gua_test values (15);

commit;

select count(*) from gua_test;

15

sysdba
----------

shu immediate

startup mount

flashback database to restore point ten_rows;

alter database open resetlogs;

odb user
---------
select count(*) from gua_test;

result - 10

1 comment:

  1. let me share my experience with regard to the service of repair sql mdf file, it automatically eliminates data corruption issues in selected databases

    ReplyDelete