Database Reference
In-Depth Information
e xeRCiSe 7.1 (continued)
2. Start RMAN and confirm that you have a valid backup with the LIST BACKUP OF
DATABASE SUMMARY command and with the RESTORE DATABASE VALIDATE command.
Note that your output will likely look very different from ours:
C:\Documents and Settings\Robert>rman target=/
Recovery Manager: Release 12.1.0.1.0 -
Production on Sat Jan 4 20:01:34 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1194923408)
RMAN> list backup of database summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed
------- -- -- - ----------- --------------- ------- ------- ----------
Tag
---
2 B F A DISK 03-OCT-13 1 1 YES
TAG20131003T135426
RMAN> restore database validate;
Starting restore at 04-OCT-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 device type=DISK
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\ORACLE\FLASH_RECOVERY_AREA\
ORCL\BACKUPSET\2013_10_03
\O1_MF_NNNDF_TAG20131003T135426_4GDY3S9H_.BKP
channel ORA_DISK_1: piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\
BACKUPSET\2013_10_03
\O1_MF_NNNDF_TAG20131003T135426_4GDY3S9H_.BKP tag=TAG20131003T135426
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:01:36
Finished restore at 04-OCT-13
RMAN>exit
3. If you are running in Windows, create the service for the new database with ORADIM .
In this example, you are creating a new database instance called neworcl :
C:\>oradim -new -sid neworcl
Instance created.
If there are any other OS-specific operations required to create a database instance,
complete them now.
Search WWH ::




Custom Search