RMAN

[vieriParticipante]

SUBIUUUU!!!!!!!!

RMAN> run{
2> SQL “ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo01.log”
3> TO ”/u03/wis/redo01.log” “;
4> SQL “ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo02.log”
TO ”/u03/wis/redo02.log” “;
5> 6> SQL “ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo03.log”
TO ”/u03/wis/redo03.log” “;
7> 8> SQL “ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo04.log”
TO ”/u03/wis/redo04.log” “;
9> 10> }

using target database control file instead of recovery catalog
sql statement: ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo01.log”TO ”/u03/wis/redo01.log”

sql statement: ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo02.log”TO ”/u03/wis/redo02.log”

sql statement: ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo03.log”TO ”/u03/wis/redo03.log”

sql statement: ALTER DATABASE RENAME FILE ”/u02/oracle/oradata/wis/redo04.log”TO ”/u03/wis/redo04.log”

RMAN>

RMAN> alter database open resetlogs ;

database opened

RMAN> exit

Recovery Manager complete.
[oracle@admbidev wis]$ sqlplus / as sysdba
[
SQL*Plus: Release 10.2.0.3.0 – Production on Fri Jul 24 14:52:04 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$instance ;

INSTANCE_NUMBER INSTANCE_NAME

---

HOST_NAME

VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT

---

LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO

---

          1 wis

admbidev.corp.casaevideo.com.br
10.2.0.3.0 24-JUL-09 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

teste de fogo agora !!!

SQL> shutdown abort ;
ORACLE instance shut down.
SQL> startup;
SP2-0714: invalid combination of STARTUP options
SQL> startup;
ORACLE instance started.

Total System Global Area 536870912 bytes
Fixed Size 1262788 bytes
Variable Size 155192124 bytes
Database Buffers 373293056 bytes
Redo Buffers 7122944 bytes
Database mounted.
Database opened.

Base retaurada!! 🙂 )))

Rodrigo poste seus comentários ai pra não ficar informação técnica
mal entendida.

obrigado a todos!! Valeu Rodrigo…
obs:Estamos esperando seu curso de RMAN no Rio hein!!