2/13/2023 0 Comments Cutlist for sketchup 2015![]() ![]() Piece Name: /u03/app/oracle/oradata/orcl/backup/1vlc5nqn_1_1 ![]() ![]() We can also find the last SCN in our archive logs through RMAN using LIST BACKUP OF ARCHIVELOG ALL.īS Key Size Device Type Elapsed Time Completion TimeīP Key: 54 Status: AVAILABLE Compressed: NO Tag: TAG20100427T094350 ![]() Here we see that the archive logs contain log information up to SCN 1375117. We can find the last SCN by querying V$ARCHIVED_LOG. When we restore the database we are not going to have the active redo logs from the original database so we want to stop the recovery at the last SCN in the archive logs. The first group of numbers appearing after the c-, 123915029, is the DBID. If you are unable to connect to the database you can also find the DBID by inspecting the file name of the control file autobackup. All rights reserved.Ĭonnected to target database: ORCL (DBID=1239150297) You can find the DBID by connecting to the database with RMAN as shown ~]$ rman One of the first things we want to do is get the Database ID ( DBID) from the database in which we will be restoring its backup. For this demonstration we will be using Oracle Database 11gR2 on Linux and disk based backup. This document will detail the steps to restore a database on a new host using RMAN. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |