beautypg.com

HP 3PAR Application Software Suite for Oracle User Manual

Page 159

background image

[vcdba@dl160g6-13 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 9 21:59:32 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management,

OLAP,

Data Mining and Real Application Testing options

SQL> set autorecovery on

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 14568837 generated at 06/09/2011 16:30:54 needed for thread

1

ORA-00289: suggestion : +ASM11GR2_ARCHDG2

ORA-00280: change 14568837 for thread 1 is in sequence #1

ORA-00308: cannot open archived log '+ASM11GR2_ARCHDG2'

ORA-17503: ksfdopn:2 Failed to open file +ASM11GR2_ARCHDG2

ORA-15045: ASM file name '+ASM11GR2_ARCHDG2' is not in reference form

SQL> alter database open resetlogs;

Database altered.

f.

Other RAC nodes can be brought up from this point. Refer to Oracle documentation for
instructions.

Recovering to the Asynchronous Periodic Backup System when the Local and Synchronous Backup Systems are Unavailable

159