Steps:
1) restore Controlfile
rman target / catalog /@CATALOG
set dbid=xxxxxxxxxxxxxxxxxx
set
run
{
allocate channel dev1 type tape PARMS='...';
set until time "to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore controlfile from autobackup;
}
SQL> alter database mount;
Recover database
run
{
allocate channel dev1 type tape PARMS='...';
set newname for datafile 1 to '';
.
.
.
set newname for datafile 99 to '';
set until time "to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore tablespace system, sysaux, undotbs, users;
recover database;
}
SQL> alter database open resetlogs;
Can explore more Crash recovery option at http://www.akadia.com/services/ora_crash_recovery.html
1) restore Controlfile
rman target / catalog /@CATALOG
set dbid=xxxxxxxxxxxxxxxxxx
set
run
{
allocate channel dev1 type tape PARMS='...';
set until time "to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore controlfile from autobackup;
}
SQL> alter database mount;
Recover database
run
{
allocate channel dev1 type tape PARMS='...';
set newname for datafile 1 to '';
.
.
.
set newname for datafile 99 to '';
set until time "to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore tablespace system, sysaux, undotbs, users;
recover database;
}
SQL> alter database open resetlogs;
Can explore more Crash recovery option at http://www.akadia.com/services/ora_crash_recovery.html
No comments:
Post a Comment