rman restore

From: Zelli, Brian <Brian.Zelli_at_RoswellPark.org>
Date: Tue, 14 Oct 2014 17:43:52 +0000
Message-ID: <7DCF5A73984B85409A1FB7B957E590ED84497F11_at_EXMB3RSC.roswellpark.org>

Ok, I am using rman for backups and I capture a bunch of backup files and controlfile. I am using rman with no catalog since I am not archiving. If I want to restore to another server (finally a test box to restore), do I just bring all the files over and issue an rman restore? Is there a cheat sheet around to kind of guide me? I found this:

Restore Example
There are many ways to restore a database using an RMAN backup - this example assumes you are performing a Disaster-Recovery restore of all data and recovering the entire database with the same SID and the same disk/tablespace layout. You will need the following information: Database SID: ________

Database SYS password: ________
Disk layout and sizes: ________
Database ID (DBID): ________

There are 5 steps to recover the database:

1) Create a new (empty) database instance
2) Mount the instance
3) Restore the datafiles
4) Recover the database
5) Reset the logs
1) Create a new (empty) database instance

Configure the new server with same disk layout as the original database - if necessary use Symbolic Links (or in Windows use disk manager to re-assign drive letters.) Ensure you have enough disk space for both the backup files plus the restored database files. Create a new database with the database configuration assistant (DBCA) and set the SYS password and global database_name to the same as the original database. If the database to be restored is in archive log mode, set the LOG_ARCHIVE_FORMAT parameter to match the setting in the original database. The ORAPWD utility can also be used to change the SYS password. Set the environment variable NLS_LANG for your character set - NLS_LANG=American_America.WE8ISO8859P1
2) Mount the empty instance
SQL> Shutdown immediate;
SQL> Startup mount;
or specifying the pfile explicitly:

SQL> CREATE PFILE='C:\oracle\Database\initLive.ora' FROM SPFILE;
SQL> Shutdown immediate;
SQL> Startup mount pfile=C:\oracle\Database\initLive.ora

3) Restore the datafiles
In this case we have copied the RMAN backup files and archive logs to R:\Rman\ Change the dbid to match that of the database being restored RMAN> SET dbid = 477771234;
RMAN> run {
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'R:\Rman\%U'; restore database;
}
At this point the datafiles and tablespaces will be re-created. For a large database it can take a long time to restore each tablespace - for better performance during a restore place the RMAN backup files on a separate disk to the Oracle datafiles to reduce disk contention. 4) Recover the database
SQL> Recover from 'L:\oradata\live' database until cancel using backup controlfile; SQL> cancel
5) Reset the logs
SQL> alter database open resetlogs;
This will update all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp. As soon as you have done a resetlogs run a full backup, this is important as should you suffer a second failure you will not be able to perform a second recovery because after resetting the logs the SCN numbers will no longer match any older backup files. Notes:
The DBID can be retrieved in several places, if the database is running: Select dbid from V$DATABASE; The RMAN client displays the dbid at startup when connecting to a database: Copyright (c) 1995, 2003, Oracle. All rights reserved. connected to target database: RDBMS (DBID=7776644123)

The default filename format for an RMAN controlfile autobackup is c-IIIIIIIIII-YYYYMMDD-QQ, where: IIIIIIIIII is the DBID.

Brian

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 14 2014 - 19:43:52 CEST