With the Partitioning, OLAP and Data Mining options
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 2072552 bytes
Variable Size 130023448 bytes
Database Buffers 176160768 bytes
Redo Buffers 6316032 bytes
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
oracle@sg2as059:/u01/app/oracle>
oracle@sg2as059:/u01/app/oracle> rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Sat Jun 18 23:52:27 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: test (not mounted)
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
restore controlfile from 'cntrl_15_1_753725973' ;
release channel ch00;
}3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: sid=46 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
sent command to channel: ch00
Starting restore at 18-JUN-11
channel ch00: restoring control file
channel ch00: restore complete, elapsed time: 00:01:08
output filename=/u01/test/control01.ctl
Finished restore at 18-JUN-11
released channel: ch00
RMAN>
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
recover database;
release channel ch00;
}3> 4> 5> 6> 7> 8>
allocated channel: ch00
channel ch00: sid=46 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
sent command to channel: ch00
Starting restore at 18-JUN-11
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/18/2011 23:58:07
ORA-01507: database not mounted
RMAN> sql'alter database mount';
sql statement: alter database mount
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
restore database;
recover database;
release channel ch00;
}3> 4> 5> 6> 7> 8>
allocated channel: ch00
channel ch00: sid=46 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
sent command to channel: ch00
Starting restore at 18-JUN-11
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u07/test/oradata/undotbs01.dbf
restoring datafile 00003 to /u07/test/oradata/sysaux01.dbf
channel ch00: reading from backup piece bk_9_1_753725520
channel ch00: restored backup piece 1
piece handle=bk_9_1_753725520 tag=HOT_DB_BK_LEVEL0
channel ch00: restore complete, elapsed time: 00:02:35
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u07/test/oradata/system01.dbf
restoring datafile 00004 to /u07/test/oradata/tbs_1.dbf
channel ch00: reading from backup piece bk_10_1_753725520
channel ch00: restored backup