| Restore ControlFile to new host [message #250877] |
Wed, 11 July 2007 12:55  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
Linux RHEL4/Oracle 10.2
I'm testing out recovery scenarios. I successfully executed the below command in rman:
run {
allocate channel dev1 type disk;
backup incremental level 0
format '/d20/oradata/T_DEV/backup/t_dev_backup_%U'
database
include current controlfile;
release channel dev1;
}
When I attempt to restore my backup to the new host, how can I restore the controlfile I backed up in my command above? Do I need controlfile autobackup enabled?
Thanks.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Restore ControlFile to new host [message #250900 is a reply to message #250898] |
Wed, 11 July 2007 14:24  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
I'm confused, I'm being lazy? Here's the output from your seggestion:
RMAN> run {
2> allocate channel dev1 device type disk;
3> restore controlfile from backupset;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "backupset": expecting one of: "autobackup, double-quoted-string, single-quoted-string, tag"
RMAN-01007: at line 3 column 26 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 3 column 35 file: standard input
What whole concept did I not read?
|
|
|
|
|
|
| Re: Restore ControlFile to new host [message #250903 is a reply to message #250902] |
Wed, 11 July 2007 14:29 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
RMAN> list backupset;
Backup Set Copy #1 of backup set 76481
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:09:39 07-11-2007 06:29:15 NO TAG20070711T181933
List of Backup Pieces for backup set 76481 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
76519 1 AVAILABLE /u101/oracle/ds/backup/al_9fimj4do_1_1.bck
76520 2 AVAILABLE /u101/oracle/ds/backup/al_9fimj4do_2_1.bck
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
76699 Full 13.58M DISK 00:00:01 07-11-2007 06:29:30
BP Key: 76734 Status: AVAILABLE Compressed: NO Tag: CF1
Piece Name: /u101/oracle/ds/backup/cf_9limj509_1_1.bck
Control File Included: Ckp SCN: 13390063757 Ckp time: 07-11-2007 06:29:29
RMAN>RESTORE CONTROLFILE FROM TAG 'TAG20070711T181933'; [Updated on: Wed, 11 July 2007 14:30] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Restore ControlFile to new host [message #251856 is a reply to message #250877] |
Mon, 16 July 2007 23:54 |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
 
|
|
Copy the backupset into the new host. And in new host use file location and use .
As you are using OS command to copy backup set into a new host so RMAN does not know where the backup set is. So you manually specily filename clause to locate your backupset.
restore controlfile from 'filename' ;
[Updated on: Mon, 16 July 2007 23:56] Report message to a moderator |
|
|
|
| Re: Restore ControlFile to new host [message #251985 is a reply to message #251856] |
Tue, 17 July 2007 10:53 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Arju wrote on Mon, 16 July 2007 22:54 | Copy the backupset into the new host. And in new host use file location and use .
As you are using OS command to copy backup set into a new host so RMAN does not know where the backup set is. So you manually specily filename clause to locate your backupset.
restore controlfile from 'filename' ;
|
not neceassry because backup information is in controlfile the oracle will read the controlfile
for backup only one thing matters
and that is the location if you gonna paste
the backup to same location then just enter the command
restore database;
[Updated on: Tue, 17 July 2007 10:54] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
