RE: rman nocatalog - point in time recovery
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Jul 2004 13:31:29 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mercadante, Thomas F
Sent: Thursday, July 15, 2004 1:21 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxxxx [mailto:Paula_Stankus@xxxxxxxxxxxxxxx]
Sent: Thursday, July 15, 2004 12:39 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Ruth Gramolini
Sent: Wednesday, July 14, 2004 8:41 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Schauss, Peter
Sent: Tuesday, July 13, 2004 4:44 PM
To: oracle-l@xxxxxxxxxxxxx
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;
restore database;
}
exit;
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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 have an rman backup (nocatalog) and a separate control file backup done
at 11:00 pm.
- The database is in archivelog mode.
- At 11:00 am the next morning I have a failure which causes loss of the
entire database.
- Archivelogs through 10:45 are intact. The last archive log is = sequence
1234.
- I have the backup files created from the 11:00 pm rman backup in the
directory to which they were backed up.
- I want to restore the database to the state it was in at 10:45 am by
applying the redo logs through number 1234.
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;
restore database;
recover database;
alter database open resetlogs;
}
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 4586007) is spam:
Spam: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D4586007&m=3Ddd09e=
d4dec9a
Not spam: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D4586007&m=3Ddd09e=
d4dec9a
Forget vote: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D4586007&m=3Ddd09e=
d4dec9a
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
