Databases Reference
In-Depth Information
For now, the name of the init.ora file is ORACLE_HOME/dbs/inito12c.ora . This file will be renamed when the
database is renamed to DEVDB in a later step. For now, the name of the database is o12c; this will be renamed in a
later step. Here are the contents of the init.ora file:
control_files='/ora01/dbfile/DEVDB/control01.ctl',
'/ora01/dbfile/DEVDB/control02.ctl'
db_block_size=8192
db_name='o12c'
job_queue_processes=10
memory_max_target=300000000
memory_target=300000000
open_cursors=100
os_authent_prefix=''
processes=100
remote_login_passwordfile='EXCLUSIVE'
resource_limit=true
shared_pool_size=80M
sql92_security=TRUE
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
workarea_size_policy='AUTO'
Ensure you change parameters such as control_files to reflect the new path directories on the destination
server (/ora01/dbfile/DEVDB in this example).
if this was an oracle Database 10 g example, you would need to set the parameters of:
background_dump_dest , user_dump_dest , and core_dump_dest .
Note
Step 6: Create Any Required Directories for Data Files, Control Files,
and Dump/Trace Files
For this example, the directories of /ora01/dbfile/DEVDBA and /ora01/oraredo/DEVDBA are created:
$ mkdir -p /ora01/dbfile/DEVDBA
$ mkdir -p /ora01/oraredo/DEVDBA
Step 7: Start Up the Database in Nomount Mode
You should now be able to start up the database in nomount mode:
$ rman target /
RMAN> startup nomount;
Step 8: Restore a Control File from the RMAN Backup
Now restore the control file from the backup that was previously copied. For example:
RMAN> restore controlfile from '/ora01/rman/DEVDB/c-3414586809-20120805-10';
 
 
Search WWH ::




Custom Search