Restoring datafile 00001 to /u02/oracle/ora1/em/system01.dbf Using target database control file instead of recovery catalogĬhannel ORA_DISK_1: starting datafile backupset restoreĬhannel ORA_DISK_1: specifying datafile(s) to restore from backup set All rights reserved.Ĭonnected to target database (not started) Recovery Manager: Release 10.2.0.3.0 – Production on Sat May 24Ĭopyright (c) 1982, 2005, Oracle. SQL> alter system set cluster_database=false scope=spfile sid=’*’ ORA-1157 signalled during: ALTER DATABASE OPEN…įirst, take the database out of cluster mode via: Linux Error: 2: No such file or directory ORA-01157: cannot identify/lock data file 3 – see DBWR trace file You will find something similar to the following in the instance’s alert log:Įrrors in file /u02/oracle/logs/em/bdump/em1_dbw0_c: PRKP-1001 : Error starting instance em1 on node rac1ĬRS-0215: Could not start resource ‘ora.em.em1.inst’. Shutdown the database and simulate a failure by dropping and/or corrupting a datafile. I used a NOCATALOG, disk-based backup for this example, Highlight the steps required for recoverying RAC databases. Instance databases, however there are some key differences – the goal of this post is to Backup and recovery operations for RAC databases are similar to that of single This example illustrates how to backup and recover a 2-node, 10gR2 RAC cluster on
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |