HOW
TO CREATE RESTORE POINT IN ORACLE 11G WITH EXAMPLE
SQL> CREATE RESTORE POINT
before_update GUARANTEE FLASHBACK DATABASE;
Restore point created.
SQL> !rman
Recovery Manager: Release 11.2.0.1.0 -
Production on Sat Oct 20 16:20:27 2012
Copyright (c) 1982, 2009, Oracle and/or
its affiliates. All rights reserved.
RMAN> connect target
connected to target database: DB
(DBID=2351874955)
RMAN> list restore point all
2> ;
using target database control file
instead of recovery catalog
SCN RSP Time Type
Time Name
---------------- --------- ----------
--------- ----
3280671 GUARANTEED
12-OCT-12 BEFORE_UPDATE
RMAN> exit
Recovery Manager complete.
SQL> create table
before_restore_point(ename varchar2(40));
Table created.
SQL> !rman
Recovery Manager: Release 11.2.0.1.0 -
Production on Sat Oct 20 16:21:35 2012
Copyright (c) 1982, 2009, Oracle and/or
its affiliates. All rights reserved.
RMAN> shutdown immediate
using target database control file
instead of recovery catalog
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR
MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03002: failure of shutdown command
at 19/20/2012 16:21:40
RMAN-06171: not connected to target
database
RMAN> connect target
connected to target database: DB
(DBID=2351874955)
using target database control file
instead of recovery catalog
RMAN> FLASHBACK DATABASE TO RESTORE
POINT 'BEFORE_UPDATE';
Starting flashback at 20-OCT-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=241 device
type=DISK
starting media recovery
media recovery failed
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR
MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03002: failure of flashback
command at 10/20/2012 16:22:21
ORA-38757: Database must be mounted and
not open to FLASHBACK.
RMAN> exit
Recovery Manager complete.
SQL> !rman
Recovery Manager: Release 11.2.0.1.0 -
Production on Sat Oct 20 16:22:35 2012
Copyright (c) 1982, 2009, Oracle and/or
its affiliates. All rights reserved.
RMAN> connect target
connected to target database: DB
(DBID=2351874955)
RMAN> shutdown immediate
using target database control file
instead of recovery catalog
RMAN> exit
Recovery Manager complete.
SQL> shutdown abort
ORA-03135: connection lost contact
SQL> exit
Disconnected from Oracle Database 11g
Enterprise Edition Release 11.2.0.1.0 - 32bit Production
With the Partitioning, OLAP, Data
Mining and Real Application Testing
[oracle@oracleoel test]$ sqlplus "/
as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production
on Sat Oct 20 16:25:21 2012
Copyright (c) 1982, 2009, Oracle. All
rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Release 11.2.0.1.0 - 32bit Production
With the Partitioning, OLAP, Data
Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !rman
Recovery Manager: Release 11.2.0.1.0 -
Production on Sat Oct 20 16:25:46 2012
Copyright (c) 1982, 2009, Oracle and/or
its affiliates. All rights reserved.
RMAN> connect target
connected to target database (not
started)
RMAN> startup mount
Oracle instance started
database mounted
Total System Global Area 1837244416
bytes
Fixed Size 2214336
bytes
Variable Size 1207961152
bytes
Database Buffers 603979776
bytes
Redo Buffers 23089152
bytes
RMAN> FLASHBACK DATABASE TO RESTORE
POINT 'BEFORE_UPDATE';
Starting flashback at 20-OCT-12
using target database control file
instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=201 device
type=DISK
starting media recovery
media recovery complete, elapsed time:
00:00:03
Finished flashback at 20-OCT-12
RMAN> alter database open resetlogs;
database opened
RMAN> exit
Recovery Manager complete.
SQL> select instance_name,status
from v$instance;
select instance_name,status from
v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 22495
Session ID: 153 Serial number: 3
SQL> exit
Disconnected from Oracle Database 11g
Enterprise Edition Release 11.2.0.1.0 - 32bit Production
With the Partitioning, OLAP, Data
Mining and Real Application Testing options
[oracle@oracleoel test]$ sqlplus "/
as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production
on Sat Oct 20 16:27:10 2012
Copyright (c) 1982, 2009, Oracle. All
rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Release 11.2.0.1.0 - 32bit Production
With the Partitioning, OLAP, Data
Mining and Real Application Testing options
SQL> select instance_name,status
from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
DB OPEN
SQL> select * from before_restore;
select * from before_restore
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from
before_restore_point;
select * from before_restore_point
*
ERROR at line 1:
ORA-00942: table or view does not exist
No comments:
Post a Comment