Saturday, May 17, 2014

Restore controlfile to non-default location


1.Restore controlfile to non-default location using autobackup


$ rman target =/

Recovery Manager: Release 11.2.0.4.0 - Production on Sat May 17 03:42:47 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CVRMAN (DBID=657566608)

RMAN> restore controlfile to '/SHARED/backup1/controlfile.bkp' from autobackup;

Starting restore at 17-MAY-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=54 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=52 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=29 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=30 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=28 device type=DISK

recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_1: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_17/s_847769767.313.847769769 found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140517
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_2: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_17/s_847769767.313.847769769 found in the recovery area
channel ORA_DISK_2: looking for AUTOBACKUP on day: 20140517
channel ORA_DISK_2: skipped, AUTOBACKUP already found
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_3: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_17/s_847769767.313.847769769 found in the recovery area
channel ORA_DISK_3: looking for AUTOBACKUP on day: 20140517
channel ORA_DISK_3: skipped, AUTOBACKUP already found
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_4: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_17/s_847769767.313.847769769 found in the recovery area
channel ORA_DISK_4: looking for AUTOBACKUP on day: 20140517
channel ORA_DISK_4: skipped, AUTOBACKUP already found
recovery area destination: +DATA
database name (or database unique name) used for search: CVRMAN
channel ORA_DISK_5: AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_17/s_847769767.313.847769769 found in the recovery area
channel ORA_DISK_5: looking for AUTOBACKUP on day: 20140517
channel ORA_DISK_5: skipped, AUTOBACKUP already found
channel ORA_DISK_1: restoring control file from AUTOBACKUP +data/CVRMAN/AUTOBACKUP/2014_05_17/s_847769767.313.847769769
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
Finished restore at 17-MAY-14



2.Restore controlfile to non-default location using backuppiece

RMAN>  restore controlfile to '/SHARED/backup1/%U' from '+data/CVRMAN/AUTOBACKUP/2014_05_17/s_847769767.313.847769769';

Starting restore at 17-MAY-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5

channel ORA_DISK_2: skipped, AUTOBACKUP already found
channel ORA_DISK_3: skipped, AUTOBACKUP already found
channel ORA_DISK_4: skipped, AUTOBACKUP already found
channel ORA_DISK_5: skipped, AUTOBACKUP already found
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
Finished restore at 17-MAY-14

No comments: