› Fóruns › Banco de dados Oracle › Recuperação BD pelo enterprise Manager › Recuperação BD pelo enterprise Manager
jsouza10Bom dia!
Sim percebi dei permissão para leitura e gravação e ficou assim o log:
startup mount
shutdown immediate
shutdown immediate
SQL*Plus: Release 11.1.0.7.0 – Production on Tue Mar 22 11:48:54 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> SQL> SQL> ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
startup mount
SQL*Plus: Release 11.1.0.7.0 – Production on Tue Mar 22 11:48:58 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> SQL> Connected to an idle instance.
SQL> SQL> ORACLE instance started.
Total System Global Area 772472832 bytes
Fixed Size 2163680 bytes
Variable Size 612371488 bytes
Database Buffers 155189248 bytes
Redo Buffers 2748416 bytes
Database mounted.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Recovery Manager: Release 11.1.0.7.0 – Production on Tue Mar 22 11:49:04 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
connected to target database: SENIOR (DBID=4086617815, not open)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> restore database until time “to_date(‘2011-03-15 06:00:58’, ‘YYYY-MM-DD HH24:MI:SS’)”;
3> recover database until time “to_date(‘2011-03-15 06:00:58’, ‘YYYY-MM-DD HH24:MI:SS’)”;
4> }
Starting restore at 22-MAR-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=154 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/22/2011 11:49:07
RMAN-06026: some targets not found – aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN> exit;
Recovery Manager complete.