SQL> create spfile from pfile; File created. In this example, set

Select the backup gateway of the destination server. be within the time range that is specified by the, On the Backup Schedules page, find the ID of your backup schedule and click. Default value: The system identifier (SID) of the database that you want to restore. Click Run Now to run the restore job.Note: The restore job will fail because the recovery portion encounters inconsistent archive logs. Connected to an idle instance. RMAN > list backup TAG='xyz' --- Is this the backup i would like to restore ? How to perform a redirected restore of an Oracle Server to another Oracle Server using Backup Exec for Windows Servers, Example: C:\> orapwd file=c:\oracle\product\10.2.0\db_1\database\pwdORCL1.ora password=NEWpasswordNote: Backup Exec Remote Agent must be installed and configured for Oracle database access Configuring database access for Oracle operations. As a result, some of the functionality on this website may not work for you. to install a backup gateway, see. All rights reserved. Contact us for help registering your account. SQL> exit Disconnected [emailprotected] dbs$ ls -ltr total 40 -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 3584 Jul 1 12:30 spfilePLATINUM.ora -rw-r----- 1 oracle oinstall 1536 Jul 1 12:30 orapwPLATINUM -rw-r--r-- 1 oracle oinstall 1097 Jul 1 12:31 initPLATINUM.ora [emailprotected] dbs$ vi initPLATINUM.ora -- ( and I adjust the parameters ). RMAN > crosscheck backup TAG='xyz' --- is this backup available ? [emailprotected] dbs$ sqlplus / as sysdba, SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jul 1 12:33:57 2009 Copyright (c) 1982, 2006, Oracle. Exit Sqlplus and launch RMAN from the command prompt. Select the backup gateway of the source server and specify a different value for the, Restore data to the original directory on the source server. I had planned downtime of a few hours.

backup. Type STARTUP NOMOUNT; 7. Task names do not have to be unique. Prior to the shutdown of the old database server I made a cold backup and I installed the same Oracle version on the same OS on the new database server ( requirement ).

On the Restore job properties pane, under Destination, click Oracle Redirection.14. ( same OS, same Oracle version ), See also How to restore and RMAN backup from TAG, You have to restore your database from scratch to a new server with a new Oracle Home, your old database is not available anymore. Startup nomount since I haven' t a control file yet. All Rights Reserved.

Type the following command:SQLPLUS /nologc. Database Backup (DBS) allows you to restore an Oracle database to a different server, Since it concerns a cold backup I do not have to recover it, it is consistent. Once the control files are restored I can mount the database. remember that I restored the lastest backups to exactly the same location. The endpoint used to connect to the database that you want to restore. Type EXIT when complete. restored to a point in time within the time range. The database can be Note: Thisdbid MUST be identical to thedbid from the original Oracle instance. On the Properties pane, under Source, click Selections.12. Move to the Backup Exec Media Server.10. Total System Global Area 1895825408 bytes Fixed Size 2073632 bytes Variable Size 436210656 bytes Database Buffers 1442840576 bytes Redo Buffers 14700544 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. It is possible that updates have been made to the original version after this document was translated and published. Refer to the Database script output section in job logs for more details. Select the appropriate Control File to restore.13.

( same OS, same Oracle version ). A server with hostname X was going to be replaced by another server with the same hostname X. using channel ORA_DISK_1channel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup set, restoring datafile 00001 to /u01/oradata/PLATINUM/system01.dbf, restoring datafile 00002 to /u01/oradata/PLATINUM/undotbs01.dbf, restoring datafile 00003 to /u01/oradata/PLATINUM/sysaux01.dbf, restoring datafile 00004 to /u01/oradata/PLATINUM/users01.dbf, restoring datafile 00005 to /u01/oradata/PLATINUM/silver.dbf, restoring datafile 00006 to /u01/oradata/PLATINUM/gold.dbf, channel ORA_DISK_1: reading from backup piece /u01/backup/db_49kisu3m_1_1channel, ORA_DISK_1: restored backup piece 1piece handle=/u01/backup/db_49kisu3m_1_1 tag=TAG20090630T154910, channel ORA_DISK_1: restore complete, elapsed time: 00:00:56. on the server.

At a command prompt, type the following command: SQLplus / as SYSDBA5. Microsoft no longer supports this browser. connected to target database: PLATINUM (not mounted) RMAN> set dbid 706111982; executing command: SET DBID RMAN>restore controlfile from '/u01/backup/CT_4bkisua9_1_1'; Starting restore at 01-JUL-09 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=321 devtype=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 output filename=/u01/oradata/PLATINUM/control01.ctl output filename=/u01/oradata/PLATINUM/control02.ctl output filename=/u01/oradata/PLATINUM/control03.ctl Finished restore at 01-JUL-09. Rating submitted. Hello!

RMAN > crosscheck backupTAG='TAG20090630T154910'; I restore the lastest backup. This is a normal occurrence during a disaster recovery.15. the. [emailprotected] dbs$ rman target / Recovery Manager: Release 10.2.0.3.0 - Production on Wed Jul 1 12:34:56 2009 Copyright (c) 1982, 2005, Oracle. restore controlfile from '/u01/backup/CT_4bkisua9_1_1'; crosscheck backupTAG='TAG20090630T154910', cp tnsnames.ora $ORACLE_HOME/network/admin, cp listener.ora $ORACLE_HOME/network/admin, Script to get info from the Auto Maintenance Gather Stats job, Using dbms_comparison to troubleshoot logical standby databases, Grant a "standard" DB user the possibility to unlock a user, Redo log management in physical standby database, Succeeding with online table redefinition, Grant with grant option as a workaround for ORA-01720, Create manually a sql profile and set your own hints, Flashback database using guaranteed restore point, Datapump feature : Attach to and Manage a running Datapump job, Data Guard : Adjust RMAN' s archivelog deletion policy, How to backup with the keep option and restore without a recovery catalog, How to restore an SPFILE and RMAN cold backup on a new server. Enter account credentials to access the new or alternate Oracle Server. For more information about how See also How to backup with the keep option and restore without a recovery catalog, See also How to restore an SPFILE and RMAN cold backup on a new server. You may also refer to the English Version of this knowledge base article for up-to-date information.

The type of the database that you want to restore. RMAN> sql "alter database open resetlogs"; sql statement: alter database open resetlogs, I moved the tnsnames.ora and listener into the new $ORACLE_HOME/network/admin, [emailprotected] ~$ cp tnsnames.ora $ORACLE_HOME/network/admin, [emailprotected] ~$ cp listener.ora $ORACLE_HOME/network/admin, [emailprotected] ~$cp orapwPLATINUM $ORACLE_HOME/dbs, How to restore an RMAN cold backup on a new server. source server. Restore data to a different directory on the source server. Connected to an idle instance. I had a similar situation today. ( same OS, same Oracle version ), vi initPLATINUM.ora -- ( and I adjust the parameters ). Now I validate whether the backups known in the controlfile are there.

The value must We recommend that you set RMAN> restore database from TAG='TAG20090630T154910'. The region where the backup gateway of the destination server resides. On the navigation bar, click the arrow next to Restore, then click New Restore Job.11. All Rights Reserved. Data is restored from the source server to a different directory on the source server. DBS generates a task name. Restore an Oracle database from a physical backup. the point in time when the latest full backup set is created. Enable the check box for the option, Restore Oracle instance to server. If the Oracle datafiles and archive logs are stored on a different location on the target server, enable "Redirect Oracle files to path" option and specify the valid paths for the datafiles and archive logs. Move to the Oracle server and launch SQLplus / as SYSDBA from command prompt.16. Data from the source database is restored to the original directory on the source The backup gateway that is installed to restore data. Veritas does not guarantee the accuracy regarding the completeness of the translation. For more information, see Back up an Oracle database. Select the backup gateway of the source server and specify the original value for RMAN> sql "alter database mount"; sql statement: alter database mount released channel: ORA_DISK_1. At the Oracle server, open a command prompt.b. Type alter database open resetlogs;If an error is encountered while Oracle tries to open the database document the online redo log path and then update the pathusing the steps below.To update the online redo log file path:a. The directory used to restore the database. Data is restored from the source server to another server. The program directory of the database that you want to restore. SQL> create pfile from spfile; File created. Configuring database access for Oracle operations, Redirect restore of Oracle database(s) fails with The Database script returned an error. SQL> startup nomount; ORACLE instance started. Please provide additional feedback (optional): Please note that this document is a translation from English, and may have been machine-translated. Type SHUTDOWN IMMEDIATE;6. I had the good luck to have the same filesystem for both datafiles and rman backup pieces ( which were made on disk ), I copy passwordfile and server parameter file into the new $ORACLE_HOME/dbs, [emailprotected] ~$ cp spfilePLATINUM.ora $ORACLE_HOME/dbs [emailprotected] ~$ cp orapwPLATINUM $ORACLE_HOME/dbs, I create an ascii file from the server parameter file and have some adjustements made and validations done ( like user_dump_dest ), [emailprotected] dbs$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jul 1 12:31:15 2009 Copyright (c) 1982, 2006, Oracle. RMAN > list backup summary; --- which backups should have been made and are logically known in the control file ? a descriptive name that is easy to identify. Log on to the restored database and execute the following SQL statement to start the The recovery should now be complete. A backup gateway is installed this parameter to the absolute path that is specified by the, A server is prepared to receive physical backup files. database: : Restore an Oracle database from a logical backup, Performance tests on backup and restoration. server. to a different directory on the source server, or to the original directory on the 4. At the moment I had to restore the database on the new server the old server was not available anymore so the duplicate target database technology was not possible. The time range from the point in time when the first full backup set is created to Default value: Oracle. The point in time to which you want to restore the source database. Default value: The port used to connect to the database that you want to restore. RMAN > list backup TAG='TAG20090630T154910'; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time, 137 Full 115.50M DISK 00:00:48 30-JUN-09 BP Key: 137 Status: AVAILABLE Compressed: YES Tag: TAG20090630T154910 Piece Name: /u01/backup/db_49kisu3m_1_1, File LV Type Ckp SCN Ckp Time Name ---- ---- ---------- --------- ---- 1 Full 2108954 30-JUN-09 /u01/oradata/PLATINUM/system01.dbf 2 Full 2108954 30-JUN-09 /u01/oradata/PLATINUM/undotbs01.dbf 3 Full 2108954 30-JUN-09 /u01/oradata/PLATINUM/sysaux01.dbf 4 Full 2108954 30-JUN-09 /u01/oradata/PLATINUM/users01.dbf 5 Full 2108954 30-JUN-09 /u01/oradata/PLATINUM/silver.dbf 6 Full 2108954 30-JUN-09 /u01/oradata/PLATINUM/gold.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time, 138 Full 1.06M DISK 00:00:01 30-JUN-09, BP Key: 138 Status: AVAILABLE Compressed: YES, Tag: TAG20090630T154910 Piece Name: /u01/backup/db_4akisu5e_1_1, Control File Included: Ckp SCN: 2108954 Ckp time: 30-JUN-09, SPFILE Included: Modification time: 30-JUN-09. Type connect;d. Type the following SQLPlus command:SQLPLUS ALTER DATABASE RENAME FILE to ;For example:ALTER DATABASE RENAME FILE 'D:\ORACLE\ORADATA\JACOB\REDO01.LOG' to'C:\ORACLE\ORADATA\JACOB\REDO01.LOG';e. In the command prompt, type RMAN, then type the following command at the RMAN prompt:alter database open resetlogs;f. Close the command prompt.

For an optimal experience on our website, please consider changing to Microsoft Edge, Firefox, Chrome or Safari. For more information, see. The database is backed up. This topic describes how to restore an Oracle database from a physical We noticed that while you have a Veritas Account, you aren't yet registered to manage cases and use chat. 9. I connect with RMAN, set the right dbid and restore the controlfiles. The name of the restore task.