how do i apply an level_1 backup to a level_0 backup ? [message #504602] |
Tue, 26 April 2011 13:35 |
cakeday
Messages: 31 Registered: May 2010
|
Member |
|
|
hi all:
i have done many restores from a level 0 backup and restore it.
the way i have done this in the past is,
RESTORE THE CONTROL FILE FIRST using the block below. (The tag comes from the logfile of level_0 backup)
rman target / << EOF
set dbid = 2967781169;
run
{
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u001/admin/adsmagent/tdpo.opt)';
#restore controlfile from autobackup db_recovery_file_dest='c-2967781169-20110419-01';
#restore controlfile FROM AUTOBACKUP;
restore controlfile FROM 'c-2967781169-20110421-01';
release channel t1;
}
EOF
AND THEN I RESTORE AND RECOVER THE DATABASE using the script below.
i pick the end time based on the logfile.
rman target / << EOF
run
{
set until time "to_date('21-apr-2011 23:00:00','dd-mon-yyyy hh24:mi:ss')";
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u001/admin/adsmagent/tdpo.opt)';
#SET NEWNAME FOR DATAFILE '/u001/user/data002/perfstat_data_002.dbf' TO '/u001/data001/perfstat_data_002.dbf';
restore database;
recover database;
release channel t1;
}
EOF
BUT IF I WERE TO apply a level 1 backup to update this backup, do i still recover the db ?
Do i do restore of level 0, then restore of level 1, restore of level 1 and then eventually recover the db once ?
what i am trying to do is, move the db from one hardware to another.
but it is a large db, 700 gb -- so to cut down the outage time, i want to do the level 0 ahead of time, then keep applying level 1's so i can cutdown on the outage time.
thank you for all your help!
|
|
|
Re: how do i apply an level_1 backup to a level_0 backup ? [message #504604 is a reply to message #504602] |
Tue, 26 April 2011 13:45 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:BUT IF I WERE TO apply a level 1 backup to update this backup, do i still recover the db ?
Do i do restore of level 0, then restore of level 1, restore of level 1 and then eventually recover the db once ?
You have nothing to do, RMAN knows what it has to restore to recover the database.
Quote:it is a large db, 700 gb -- so to cut down the outage time, i want to do the level 0 ahead of time, then keep applying level 1's so i can cutdown on the outage time.
Create a standby database for this.
Regards
Michel
|
|
|
|
|
|
|
|
Re: how do i apply an level_1 backup to a level_0 backup ? [message #505387 is a reply to message #505386] |
Mon, 02 May 2011 14:27 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ No this is not what he is trying to do; see the sentence: "AND THEN I RESTORE AND RECOVER THE DATABASE using the script below", retore and recover is already done with level 0 BEFORE any incremental.
2/ Merge is not available in version 9.2
Regards
Michel
|
|
|