Home » , , , , , » Refreshing a Database with backups available on Tape

Refreshing a Database with backups available on Tape

Written By Srikrishna Murthy Annam on Wednesday, May 4, 2011 | 12:30 PM

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
Share this article :

Related Articles By Category



+ comments + 9 comments

Sam
July 3, 2011 at 8:22 PM

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...

learnwithme11g
July 4, 2011 at 3:15 AM

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

Thanks
SRI

Sam
July 4, 2011 at 4:45 AM

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.

learnwithme11g
July 4, 2011 at 6:04 AM

Pls follow the link which is published now ....

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

Sam
July 5, 2011 at 2:33 AM

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

samz
June 19, 2012 at 4:20 AM

Hi Krishna

Please give me the access of this video.

Som Sharma
June 20, 2012 at 8:44 PM

Please give me the access to this video

Tarun
April 21, 2013 at 12:05 PM

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

Srikrishna Murthy Annam
April 26, 2013 at 5:44 AM

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

Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger