DB recovery question

From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Mon, 27 Sep 2010 12:52:40 +1000
Message-ID: <AANLkTimr9sRcQDnMx74WGrhUv4PJjK9S1n9nFQnbhV-6_at_mail.gmail.com>



Hi,

I'm trying to perform a PIT recovery of one database onto a different machine.

I have a level 0 rman backup but unfortunately I was forced to use a controlfile from a later date.

I'm trying to restore the database to a point in time after the level 0 backup started but before it completed.

I have separately (successfully) restored the archivelog files created during the rman backup.

Here's the rman recovery session output. The level 0 backup started 2010-09-18 21:14:56 and completed 2010-09-19 00:37:49.

The rman backup command was "backup as compressed backupset incremental level 0 database plus archivelog;".

Can someone please have a look at this output and if possible tell me what I need to do to successfully issue an 'alter database open' command?

Thanks,

Steve

RMAN> run {
2> set controlfile autobackup format for device type disk to '/var/oracle/autobackup/%F';

3> allocate channel c1 device type disk;
4> restore spfile from autobackup maxseq 200 maxdays 100;
5> restore controlfile from autobackup maxseq 200 maxdays 100;
6> }

executing command: SET CONTROLFILE AUTOBACKUP FORMAT using target database control file instead of recovery catalog

allocated channel: c1
channel c1: SID=16351 instance=rac21d1 device type=DISK

Starting restore at 26-SEP-10

recovery area destination: +FRA
database name (or database unique name) used for search: RAC21D

channel c1: no AUTOBACKUPS found in the recovery area
channel c1: looking for AUTOBACKUP on day: 20100926
channel c1: AUTOBACKUP found:

/var/oracle/autobackup/c-3325391588-20100926-00
channel c1: restoring spfile from AUTOBACKUP
/var/oracle/autobackup/c-3325391588-20100926-00
channel c1: SPFILE restore from AUTOBACKUP complete Finished restore at 26-SEP-10

Starting restore at 26-SEP-10

recovery area destination: +FRA
database name (or database unique name) used for search: RAC21D

channel c1: no AUTOBACKUPS found in the recovery area
channel c1: looking for AUTOBACKUP on day: 20100926
channel c1: AUTOBACKUP found:

/var/oracle/autobackup/c-3325391588-20100926-00
channel c1: restoring control file from AUTOBACKUP
/var/oracle/autobackup/c-3325391588-20100926-00
channel c1: control file restore from AUTOBACKUP complete output file name=+DATA/rac21d/controlfile/current.356.730754783 output file name=+FRA/rac21d/controlfile/current.260.730754783 Finished restore at 26-SEP-10
released channel: c1

RMAN> **end-of-file**

RMAN> mount database;

database mounted

RMAN> restore database;

Starting restore at 26-SEP-10
Starting implicit crosscheck backup at 26-SEP-10 allocated channel: ORA_DISK_1
Crosschecked 77 objects
Finished implicit crosscheck backup at 26-SEP-10

Starting implicit crosscheck copy at 26-SEP-10 using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 26-SEP-10

searching for all files in the recovery area cataloging files...
cataloging done

List of Cataloged Files


File Name: +fra/RAC21D/CONTROLFILE/current.256.695327725
File Name: +fra/RAC21D/CONTROLFILE/current.257.704538107
File Name: +fra/RAC21D/CONTROLFILE/current.261.730744287
File Name: +fra/RAC21D/CONTROLFILE/current.258.730753631

using channel ORA_DISK_1

creating datafile file number=34
name=+DATA/rac21d/datafile/xxx_data.307.730323725 creating datafile file number=35
name=+DATA/rac21d/datafile/xxx_index.308.730323731

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to
+DATA/rac21d/datafile/system.259.682280555 channel ORA_DISK_1: restoring datafile 00002 to +DATA/rac21d/datafile/sysaux.260.682280559 channel ORA_DISK_1: restoring datafile 00003 to +DATA/rac21d/datafile/undotbs1.261.682280561 channel ORA_DISK_1: restoring datafile 00004 to +DATA/rac21d/datafile/undotbs2.263.682280567 channel ORA_DISK_1: restoring datafile 00005 to +DATA/rac21d/datafile/users.264.682280571 :
channel ORA_DISK_1: reading from backup piece
/var/oracle/rman-backup/9olo80tb_1_1

channel ORA_DISK_1: piece handle=/var/oracle/rman-backup/9olo80tb_1_1 tag=TAG20100918T214618
channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 01:30:16 Finished restore at 26-SEP-10

RMAN> recover database until time "to_date('2010-09-18 22:00:00', 'YYYY-MM-DD HH24:MI:SS')"; Starting recover at 26-SEP-10
using channel ORA_DISK_1

starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '+DATA/rac21d/datafile/system.340.730757423'

media recovery complete, elapsed time: 00:00:01

Finished recover at 26-SEP-10

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 09/26/2010 21:46:13 ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '+DATA/rac21d/datafile/system.340.730757423'

Here's the output from the alert log ...

alter database recover if needed
 start until time 'SEP 18 2010 22:00:00' using backup controlfile Media Recovery Start
Fast Parallel Media Recovery NOT enabled Media Recovery Not Required
ORA-1547 signalled during: alter database recover if needed  start until time 'SEP 18 2010 22:00:00' using backup controlfile ...
Sun Sep 26 21:46:13 2010
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...

Any help is much appreciated.

Steve



This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Sep 26 2010 - 21:52:40 CDT

Original text of this message