!Важно знать dbid своей базы 

RMAN> list incarnation of database;


На машине orssun 


sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 10 15:57:59 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

SQL> connect internal
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1046552736 bytes
Fixed Size                    73888 bytes
Variable Size             274432000 bytes
Database Buffers          771866624 bytes
Redo Buffers                 180224 bytes
SQL> exit
Disconnected
oracle@orssun (/ora/oracle):rman rcvcat rman/rman@rc

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06008: connected to recovery catalog database

RMAN> set dbid=1005540413

RMAN-03022: compiling command: CSET



RMAN> run {
2> allocate channel ch01 type 'SBT_TAPE';
3> send 'nb_ora_serv=orssun, nb_ora_client = orrsun';
4> restore controlfile;
5> }



oracle@orssun (/ora/oracle):svrmgrl 

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> alter database mount;
Statement processed.


oracle@orssun (/ora/oracle):rman rcvcat rman/rman@rc

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06008: connected to recovery catalog database

RMAN> set dbid=1005540413

RMAN-03022: compiling command: CSET

RMAN> connect target

RMAN-06005: connected to target database: ORCL (DBID=1005540413)


RMAN> run {
2> allocate channel ch01 type 'SBT_TAPE';
3> send 'NB_ORA_SERV=orssun, NB_ORA_CLIENT=orrsun';
4> restore database;
5> restore archivelog all;
6> }


sqlplus /nolog
SQL> connect internal
SQL> recover database using backup controlfile until cancel; # until change # until time 

...Apply logs ...
SQL> alter database open resetlogs;