C:\Documents and Settings\Administrator>rman target /

Recovery Manager: Release 10.1.0.5.0 - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: TEST (DBID=1962090068)

RMAN> run
2> {
3> backup database;
4> sql 'alter system switch logfile';
5> }

Starting backup at 28-AUG-08
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=136 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSTEM01.DBF

input datafile fno=00003 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSAUX01.DBF

input datafile fno=00002 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\UNDOTBS01.DB
F
input datafile fno=00004 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 28-AUG-08
channel ORA_DISK_1: finished piece 1 at 28-AUG-08
piece handle=F:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\01JP5UKE_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
[B]including current controlfile in backupset
including current SPFILE in backupset[/B]
channel ORA_DISK_1: starting piece 1 at 28-AUG-08
channel ORA_DISK_1: finished piece 1 at 28-AUG-08
piece handle=F:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\02JP5UKT_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 28-AUG-08

sql statement: alter system switch logfile


-------------------xxxxxxxxxxxxxxxxx--------------

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 28 12:51:17 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> host del F:\oracle\product\10.1.0\oradata\test\*.*
F:\oracle\product\10.1.0\oradata\test\*.*, Are you sure (Y/N)? Y

SQL> host del F:\oracle\product\10.1.0\db_1\database\SPTEST*.ora

--------------------------xxxxxxxxxxxxxxxxxxxxxxxxx----------

RMAN> set dbid=1962090068

executing command: SET DBID

RMAN> startup nomount force;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'F:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE
\INITTEST.ORA'

trying to start the Oracle instance without parameter files ...
Oracle instance started

Total System Global Area      88080384 bytes

Fixed Size                      788116 bytes
Variable Size                 69466476 bytes
Database Buffers              16777216 bytes
Redo Buffers                   1048576 bytes


RMAN> restore SPFILE from "F:\oracle\product\10.1.0\Db_1\database\02JP5UKT_1_1";


Starting restore at 28-AUG-08
using channel ORA_DISK_1

channel ORA_DISK_1: autobackup found: F:\oracle\product\10.1.0\Db_1\database\02J
P5UKT_1_1
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 28-AUG-08

RMAN> restore CONTROLFILE from "F:\oracle\product\10.1.0\Db_1\database\02JP5UKT_
1_1";

Starting restore at 28-AUG-08
using channel ORA_DISK_1

channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
output filename=F:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\CTL1TEST.ORA
Finished restore at 28-AUG-08

RMAN> shutdown immediate;

Oracle instance shut down

-----------------xxxxxxxxxxxxxx--------------

SQL> conn / as sysdba
Connected to an idle instance.
SQL> create pfile from spfile;

File created.

SQL> --EDIT INIT.ORA FILE AND UPDATE CONTROLFILE PARAMETER
SQL> create spfile from pfile;

File created.
--------------------xxxxxxxxxxxxxxxxx-----------

RMAN> restore database;

Starting restore at 28-AUG-08
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSTEM01.DBF
restoring datafile 00002 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\UNDOTBS01.DBF
restoring datafile 00003 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSAUX01.DBF
restoring datafile 00004 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\USERS01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=F:\ORACLE\PRODUCT\10.1.0\DB_1\DATABASE\01JP5UKE_1_1 tag=TAG20080828
T125022
channel ORA_DISK_1: restore complete
Finished restore at 28-AUG-08

-----------------------xxxxxxxxxxxxxxxxxx------------------
SQL> conn / as sysdba
Connected.
SQL> set autorecovery on
SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 441017 generated at 08/28/2008 12:50:22 needed for thread 1
ORA-00289: suggestion :
F:\ORACLE\PRODUCT\10.1.0\DB_1\RDBMS\ARC00005_0663943637.001
ORA-00280: change 441017 for thread 1 is in sequence #5


ORA-00279: change 441028 generated at 08/28/2008 12:50:40 needed for thread 1
ORA-00289: suggestion :
F:\ORACLE\PRODUCT\10.1.0\DB_1\RDBMS\ARC00006_0663943637.001
ORA-00280: change 441028 for thread 1 is in sequence #6
ORA-00278: log file
'F:\ORACLE\PRODUCT\10.1.0\DB_1\RDBMS\ARC00005_0663943637.001' no longer needed
for this recovery


ORA-00308: cannot open archived log
'F:\ORACLE\PRODUCT\10.1.0\DB_1\RDBMS\ARC00006_0663943637.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SQL> alter database open resetlogs ;

Database altered.


-----------xxxxxxxxxxxxxxxxxx---------------------------