Oracle Technologies Blog

By ASKM

Refreshing a Database with backups available on Tape

Posted by Srikrishna Murthy Annam on May 4, 2011

In the present article i am going to describe how to refresh a database. Assume that you have some consistant backups available on TAPE for the database to be refreshed.

Just follow the following sequence of steps to refresh a database ….

$sqlplus '/as sysdba'
SQL> select dbid,created,controlfile_created,last_open_incarnation# from v$database;
-- Note down the dbid and incarnation
SQL> archive log list
-- Note down sequence numbers
-- Now create one user and input some data to user. This is to verify  that after refresh we should not get this data.
SQL> create user askm identified by askm;

SQL> grant connect,resource to askm;

SQL> conn askm/askm

SQL> create table test_table as select * from sys.dba_objects;

-- Verify the tape configuration
$ tdpoconf SHOWENVironment

$ tdpoconf SHOWENVironment -tdpo_optfile=tdpo.opt

-- Connect to RMAN and verify the available backups
$ rman target / catalog rman/rman@rmancat

RMAN> list backup summary;

-- Exit from RMAN session and shutdown the database
SQL> shut immediate

RMAN Refresh Script:

$ rman target / catalog rman/rman@rmancat
RMAN> startup nomount;
RMAN> run {
allocate channel t1 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=tdpo.opt)";
restore controlfile;
alter database mount;
restore database;
recover database noredo;
release channel t1;
}
alter database open resetlogs;

Verification Steps :

$sqlplus '/as sysdba'
SQL> select dbid,created,controlfile_created,last_open_incarnation# from v$database;
-- compare incarnation with earlier value
SQL> archive log list
-- compare sequence numbers,it now starts from 0.
SQL> select username ,created from dba_users where username='ASKM';
-- Should return no rows.

Follow the video demo showing how to restore a database from backups available on tape. This is a private video so, send me a personal request if you need access to this video.

Hope it helps
SRI

Advertisements

9 Responses to “Refreshing a Database with backups available on Tape”

  1. Sam said

    Hello SriKrishna, The Information posted is very informative. Could you please email me video for demonstrating to refresh 1 database from the backups available on tapes of another database. Thanks in advance…

  2. learnwithme11g said

    Hi , now you should be able to view the video. Please send us your comments and suggestions.

    Thanks
    SRI

  3. Sam said

    Thank You, SriKrishna. I understood this is the demonstration to refresh database from its own backups available on Tapes. Could you please let me know by any chance you have the steps to refresh one database from another database backups available on tapes? Though the procedure is pretty much same after the tapes are moved to local server. I wanted to understand the additional steps that need to be taken care when performing refresh from one database to another.

  4. learnwithme11g said

    Pls follow the link which is published now ….

    https://learnwithme11g.wordpress.com/2011/07/04/rman-duplication-from-tape-backups/

  5. Sam said

    Thank You, SriKrishna. Could you also please provide access to the Video?

  6. samz said

    Hi Krishna

    Please give me the access of this video.

  7. Som Sharma said

    Please give me the access to this video

  8. Tarun said

    Hi Krishna,
    Please give me the access of this video
    Thanks
    Tarun

  9. Srikrishna Murthy Annam said

    Hi Tarun, You are given access to videos. Please check.

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

 
%d bloggers like this: