I don’t have old backup (autobackup) of control files.


oracle@bakuexa1dbadm01:/opt$ echo $ORACLE_SID
 MISDEV1
 oracle@bakuexa1dbadm01:/opt$ /u01/app/11.2.0.3/grid/bin/srvctl stop database -d MISDEV -o immediate
 oracle@bakuexa1dbadm01:/opt$ /u01/app/11.2.0.3/grid/bin/srvctl start database -d MISDEV -o mount
 oracle@bakuexa1dbadm01:/opt$
 oracle@bakuexa1dbadm01:/opt$ sqlplus "/ as sysdba";
SQL*Plus: Release 11.2.0.3.0 Production on Sun May 3 08:09:36 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
 Connected to:
 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
 With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
 Data Mining and Real Application Testing options
SQL> select name,open_mode from gv$database;
NAME OPEN_MODE
 --------- --------------------
 MISDEV MOUNTED
 MISDEV MOUNTED
SQL>
 SQL>
 SQL> exit
 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
 With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
 Data Mining and Real Application Testing options
 oracle@bakuexa1dbadm01:/opt$
 oracle@bakuexa1dbadm01:/opt$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Sun May 3 08:09:48 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: MISDEV (DBID=247039367, not open)
RMAN>
RMAN> run
2> {
 3> set until time "to_date('02.05.2015 15:45:08','DD.MM.YYYY HH24:MI:SS')";
 4> restore database;
 5> recover database;
 6> sql 'alter database open resetlogs';
 7> }
executing command: SET until clause
Starting restore at 03-MAY-15
 using channel ORA_DISK_1
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 +DATAC1/misdev/datafile/system.286.865245843
 channel ORA_DISK_1: restoring datafile 00002 to +DATAC1/misdev/datafile/sysaux.285.865245861
 channel ORA_DISK_1: restoring datafile 00003 to +DATAC1/misdev/datafile/undotbs1.282.865245869
 channel ORA_DISK_1: restoring datafile 00004 to +DATAC1/misdev/datafile/undotbs2.274.865245891
 channel ORA_DISK_1: restoring datafile 00005 to +DATAC1/misdev/datafile/users.259.865245909
 channel ORA_DISK_1: restoring datafile 00006 to +DATAC1/misdev/datafile/misdev_data.296.866052191
 channel ORA_DISK_1: restoring datafile 00007 to +DATAC1/misdev/datafile/misdev_index.295.866052211
 channel ORA_DISK_1: reading from backup piece /data/MISDEV_backup/data_backup_MISDEV/full_MISDEV_20150501_333.bck
 channel ORA_DISK_1: piece handle=/data/MISDEV_backup/data_backup_MISDEV/full_MISDEV_20150501_333.bck tag=TAG20150501T200002
 channel ORA_DISK_1: restored backup piece 1
 channel ORA_DISK_1: restore complete, elapsed time: 00:14:45
 Finished restore at 03-MAY-15
Starting recover at 03-MAY-15
 using channel ORA_DISK_1
starting media recovery
 media recovery complete, elapsed time: 00:00:07
Finished recover at 03-MAY-15
sql statement: alter database open resetlogs
RMAN> exit
In alert log:
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
 Lost write protection mode set to "typical"
 Completed: ALTER DATABASE MOUNT /* db agent *//* {1:29398:14885} */
 Sun May 03 08:20:11 2015
 Full restore complete of datafile 5 +DATAC1/misdev/datafile/users.259.865245909. Elapsed time: 0:00:01
 checkpoint is 76994329
 last deallocation scn is 3
 Full restore complete of datafile 7 +DATAC1/misdev/datafile/misdev_index.295.866052211. Elapsed time: 0:00:01
 checkpoint is 76994329
 last deallocation scn is 3
 Sun May 03 08:20:43 2015
 Full restore complete of datafile 4 +DATAC1/misdev/datafile/undotbs2.274.865245891. Elapsed time: 0:00:33
 checkpoint is 76994329
 last deallocation scn is 76933749
 Undo Optimization current scn is 76984265
 Full restore complete of datafile 3 +DATAC1/misdev/datafile/undotbs1.282.865245869. Elapsed time: 0:00:34
 checkpoint is 76994329
 last deallocation scn is 76985187
 Undo Optimization current scn is 76984265
 Sun May 03 08:21:28 2015
 Full restore complete of datafile 1 +DATAC1/misdev/datafile/system.286.865245843. Elapsed time: 0:01:19
 checkpoint is 76994329
 last deallocation scn is 47742454
 Undo Optimization current scn is 76984265
 Sun May 03 08:22:08 2015
 Full restore complete of datafile 2 +DATAC1/misdev/datafile/sysaux.285.865245861. Elapsed time: 0:01:58
 checkpoint is 76994329
 last deallocation scn is 76818388
Sun May 03 08:34:53 2015
 Full restore complete of datafile 6 +DATAC1/misdev/datafile/misdev_data.296.866052191. Elapsed time: 0:14:44
 checkpoint is 76994329
 last deallocation scn is 76758533
 Sun May 03 08:34:55 2015
 alter database recover datafile list clear
 Completed: alter database recover datafile list clear
 alter database recover datafile list
 1 , 2 , 3 , 4 , 5 , 6 , 7
 Completed: alter database recover datafile list
 1 , 2 , 3 , 4 , 5 , 6 , 7
 alter database recover if needed
 start until time 'MAY 02 2015 15:45:08'
 Media Recovery Start
 started logmerger process
 Parallel Media Recovery started with 24 slaves
 Sun May 03 08:34:56 2015
 Recovery Manager complete.
 oracle@bakuexa1dbadm01:/opt$
 oracle@bakuexa1dbadm01:/opt$
 oracle@bakuexa1dbadm01:/opt$ echo $ORACLE_SID
 MISDEV1
 oracle@bakuexa1dbadm01:/opt$ /u01/app/11.2.0.3/grid/bin/srvctl stop database -d MISDEV -o immediate
 oracle@bakuexa1dbadm01:/opt$ /u01/app/11.2.0.3/grid/bin/srvctl start database -d MISDEV
 oracle@bakuexa1dbadm01:/opt$
 oracle@bakuexa1dbadm01:/opt$
 oracle@bakuexa1dbadm01:/opt$ sqlplus "/ as sysdba";
SQL*Plus: Release 11.2.0.3.0 Production on Sun May 3 08:40:38 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
 Connected to:
 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
 With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
 Data Mining and Real Application Testing options
SQL> select name,open_mode from gv$database;
NAME OPEN_MODE
 --------- --------------------
 MISDEV READ WRITE
 MISDEV READ WRITE
SQL>
 SQL> exit
 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
 With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
 Data Mining and Real Application Testing options
 oracle@bakuexa1dbadm01:/opt$
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: