| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman nocatalog - point in time recovery
Good catch, Tom! This would actually do a complete recovery, explaining why
the data is still gone. If the incarnation changed then it will have to be
set back to the previous incarnation and the restored and recovered again
with the proper date.
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F
Sent: Thursday, July 15, 2004 1:21 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: rman nocatalog - point in time recovery
Paula,
Take a look at your date below. You said '07/01/07'.
Is this really what you want - year 2007 ???
Check to make sure that the to_date param really translates to 2007, and not 1907. I now specifically use the century in all to_date functions to make sure:
To_date('07/01/2007','mm/dd/yyyy').
This is probably not your problem.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Paula_Stankus_at_doh.state.fl.us [mailto:Paula_Stankus_at_doh.state.fl.us]
Sent: Thursday, July 15, 2004 12:39 PM
To: oracle-l_at_freelists.org
Subject: RE: rman nocatalog - point in time recovery
Guys,=20
I did the following:
execute script alloc_all_tapes;
restore database UNTIL TIME "TO_DATE('07/01/07 12:00:00','MM/DD/YY =
HH24:MI:S S')";
recover database UNTIL TIME "TO_DATE('07/01/07 12:00:00','MM/DD/YY = HH24:MI:S S')";
Then I did an alter database open resetlogs
As developer mentioned he needed objects that were there on the 7th or = the 8th. He says they still aren't there and there were no changes between until the 9th.
Is this not recovery and restoring the database up till the UNTIL =
TIME?????
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Ruth Gramolini
Sent: Wednesday, July 14, 2004 8:41 AM
To: oracle-l_at_freelists.org
Subject: RE: rman nocatalog - point in time recovery
Sometimes I find it is just expedient to use sqlplus to open the = database. Sometimes, there is no other way. Rman is still a work in progress and = it has been seriously improved since the 8.0.5... days but when you are = doing incomplete recovery and it seems to want a redo log instead of an = archived log, then I have found, sqlplus recover the way you did it is the = easiest way. Even Oracle support has told me this.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Schauss, Peter
Sent: Tuesday, July 13, 2004 4:44 PM
To: oracle-l_at_freelists.org
Subject: RE: rman nocatalog - point in time recovery
This may not be the cleanest solution, but it worked:
rman
run {
set until logseq=3D1235 thread =3D1;
allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 type disk;
sqlplus internal
sqlplus> recover database until cancel using backup controlfile; alter
sqlplus> database open resetlogs; exit;
Is there a better way to do this?
thanks,
Peter Schauss
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Schauss, Peter
Sent: Tuesday, July 13, 2004 4:12 PM
To: Oracle-L (E-mail)
Subject: rman nocatalog - point in time recovery
Enviroment: Oracle 8.1.7.4 / AIX 5.2
Scenario:
I restore my control files by copying them to the appropriate = directories on the disk (e.g. /ora1/oradata/sid/control01.ctl ... /ora2/... = /ora3/...).
I run the following commands in rman
run {
set until logseq=3D1234 thread=3D1;
allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 type disk;
Oracle says:
RMAN-03002: failure during compilation of command RMAN-03013: command type: set RMAN-06003: ORACLE error from target database: RMAN-20206: log sequence =not found in the recovery catalog
What am I missing here?
Thanks,
Peter Schauss
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
BEGIN-ANTISPAM-VOTING-LINKS
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |