Okcan Yasin Saygili's Blog

May 24, 2010

Restore Points

Filed under: RMAN — yasinsaygili @ 11:32 am

It is too basic situaiton but people dont feel last change enverimont ,so Today we understand people not remamber everything and finnaly i found last restore point with this code ,it is so simple but very effective for me

RMAN>list restore point all;

it is too important for DBA ,if you forget something and before i made new change something ,you use this command ,this command will very helpfull for us…

Restore Point is divided 2 part

  1. Normal Restore Point
  2. Guarentee Restore Point

Create Restore Point

if you create restore point ,your system is archive log mode ,after that you will make guarantee flashback,

such as

SQL>CREATE RESTORE POINT [point];

DROP Restore Point

if you dont want restore point so you can drop it with this command

SQL>DROP RESTORE POINT [point];

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: