RE: rman incomplete recovery

  • From: "Johnson, George" <GJohnson@xxxxxxx>
  • To: "'joe_dba@xxxxxxxxxxx'" <joe_dba@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Dec 2005 15:03:58 -0000

        Within RMAN, shouldn't the bit "alter database mount" be written as:

        sql "alter database mount";


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Joe Smith
Sent: 13 Dec 2005 14:56
To: oracle-l@xxxxxxxxxxxxx
Subject: rman incomplete recovery


I am trying to do an incomplete recovery of my 9iRel2 db on Solaris 8.  I am

in archive log mode.
This is a test environment.
I autobackup my control file and snapshot the control file.

The basis of the backup is:

backup database plus archivelog delete all input;

My RMAN backup script works fine, it has been running on multiple boxes for 
months now.
I have tested different situations and now working on a new one.

I can do an incomplete recovery with the current control file and redo logs.

I am trying to simulate the situation of losing my controlfiles and redo 
When I try to do an incomplete recovery with a backup controlfile and no 
redo logs I get an RMAN error.
So, I rename my controlfiles and redo logs and try to recover to a time 
before my redo logs.
I am using this run block:

set controlfile autobackup format for device type disk to
set until time "to_date('12-12-05 19:00:00','MM-DD-YY HH24:MI:SI')"; restore
controlfile from autobackup; alter database mount; restore database; recover
database; alter database open resetlogs; }

I get an RMAN error about database not mounted.  I don't think that is the 
whole problem.
Any help is highly appreicated.


Express yourself instantly with MSN Messenger! Download today - it's FREE!


This message contains confidential information and is intended only 
for the individual or entity named.  If you are not the named addressee
you should not disseminate, distribute or copy this e-mail.  
Please notify the sender immediately by e-mail if you have received 
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses.  The sender therefore does not
accept liability for any errors or omissions in the contents of this 
message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version.
This message is provided for informational purposes and should not
be construed as an invitation or offer to buy or sell any securities or
related financial instruments.
GAM operates in many jurisdictions and is 
regulated or licensed in those jurisdictions as required.


Other related posts: