| Backup recovery [message #151684] |
Fri, 16 December 2005 02:51  |
sam_jo98
Messages: 5
Registered: December 2005
Location: Phil
|
Junior Member |
|
|
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Dec 16 16:39:35 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
connected to target database (not started)
RMAN>
echo set on
RMAN> set dbid 4030725045;
executing command: SET DBID
RMAN> startup force nomount;
Oracle instance started
Total System Global Area 293601280 bytes
Fixed Size 1248624 bytes
Variable Size 96469648 bytes
Database Buffers 192937984 bytes
Redo Buffers 2945024 bytes
RMAN> set controlfile autobackup format for device type disk to 'D:\oracle\product\10.2.0\flash_recovery_area\XBC\BACKUPSET\2005_12_14\%F';
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
RMAN> run {
2> allocate channel oem_restore type disk;
3> restore spfile from autobackup;
4> }
allocated channel: oem_restore
channel oem_restore: sid=157 devtype=DISK
Starting restore at 16-DEC-05
released channel: oem_restore
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/16/2005 16:39:42
RMAN-06564: must use the TO clause when the instance is started with SPFILE
RMAN> shutdown immediate;
Oracle instance shut down
RMAN> exit;
Recovery Manager complete.
|
|
|
|
|
|
| Re: Backup recovery [message #151705 is a reply to message #151685] |
Sun, 18 December 2005 08:36  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
From documentation
| Quote: |
If restoring to a nondefault location, then you could run commands as in the following example:
RESTORE SPFILE TO '/tmp/spfileTEMP.ora'; # if you are using a catalog
RESTORE SPFILE TO '/tmp/spfileTEMP.ora' FROM AUTOBACKUP; # if in NOCATALOG mode
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
