Re: RMAN recovery question...
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: DIANNA.GIBBS@xxxxxxxxxxxxx
- Date: Thu, 25 Jan 2007 11:47:12 +0300
Dianna,
Your scripts look correct and no changes are required.
If you are on version 10gR2, you dont need to create temp tablespace
explicitly after the complete restore, oracle creates them automatically for
you. If you are not on 10gR2, then, you need to create temp tbs manually.
What about channels, can I allocate
more channels for a faster recovery?
more channesl are not for faster recovery, it depends on how many tape
drives with the backup library, rather, you may use parallel with recovery
to have parallel recovery.
And this may be a stupid question,
but if more-current files are there, is RMAN intelligent enough
to just restore the changed blocks? It was a full on-line
backup. And depending on the answer, should I delete all the old files
or can I just leave them as is?
I once did recovery where after restoring some files, rman got terminated
due to time out with the thrid party tool we use for backup to tape and when
I strat restore again, oracle was intelligent enough to bypass them as
saying they are already on the disk and continue restoring furthe datafiles.
I would also suggest you couple of things, like make sure your backups are
valid, without restoring probably, RETORE VALIDATE DATABASE and you can also
test how much time they gonna take, using, RESTORE DATABSE TEST (please
correct me I am wrong with this command).
http://www.oracle-base.com/articles/9i/RecoveryManager9i.php
On 1/25/07, DIANNA GIBBS <DIANNA.GIBBS@xxxxxxxxxxxxx> wrote:
I'm new to RMAN and have a recovery question. We're recovering
our test database to a point in time. The database is around 60 gig.
When we start recovery, will RMAN re-create, restore and then
recover all the database? And this may be a stupid question,
but if more-current files are there, is RMAN intelligent enough
to just restore the changed blocks? It was a full on-line
backup. And depending on the answer, should I delete all the old files
or can I just leave them as is? What about channels, can I allocate
more channels for a faster recovery?
Here's my script which I'm planning on doing command line:
rman target /
connect catalog rman_xxx@rcat
(password)
run {
set until time "to_date('19-JAN-2007 18:00:00','DD-MON-YYYY
HH24:MI:SS')";
allocate channel ch1 type disk;
restore controlfile ;
alter database mount ;
restore database ;
recover database ;
release channel ch1;
}
Check to make sure temp tablespace is there
alter database open resetlogs;
Thanks so much-
Dianna G.
--
//www.freelists.org/webpage/oracle-l
--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA
http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
Other related posts:
