Before you restore an Oracle database, you must prepare the database depending on the types of activities you plan to perform.
About this task
Steps
(VCS clusters only) To restore the Oracle database to a Solaris VCS cluster, stop the listener and other dependent processes. Otherwise, skip this step and go to step 3.
(Raw devices only) Before you restore datafiles on a raw device, back up the files in the flash recovery area. Otherwise, skip this step and go to step 3.
NOTE:For configurations in which you store the database on a raw file structure, Oracle recommends that you use a normal file system as the flash recovery area.
Ensure that
ORACLE_SID is set correctly by typing the following command:
echo $ORACLE_SID
$ORACLE-SID must point to the correct system identifier to restore the Oracle database.
To restore an Oracle Real Application Clusters (RAC) database, complete the following steps:
Shut down all database instances on all nodes by typing the following commands:
sqlplus “/ as sysdba” shutdown immediate; exit
Start an instance without mounting the database on the registered node by typing the following commands:
startup nomount; exit
Skip step 5 and go to step 6.
To restore a nonclustered Oracle database, close the database and start an instance without mounting the database:
Connect to the database by typing the following command:
sqlplus "/ as sysdba"
The command prompt changes to the SQL prompt.
Shut down the database by typing the following command:
shutdown immediate;
The following information is displayed in the command shell:
Start the database by typing the following command:
startup nomount;
The following information is displayed in the command shell:
ORACLE instance started. Total System Global Area 171966464 bytes Fixed Size 787988 bytes Variable Size 144964076 bytes Database Buffers 25165824 bytes Redo Buffers 1048576 bytes Database mounted.
Disconnect from the database by typing the following command:
exit
The following information is displayed in the command shell:
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
Move the existing datafiles (*.dbf), control files (*.ctl), redo log files (*.log), archive log files (*.arc), and autobackup files (*.bkp). The following commands move the existing database files to a convenient location:
NOTE:The Oracle files can be in the default location or in a nondefault location. The default location of Oracle files varies depending on the version of Oracle. The previous commands use the default values for the directories.
For Oracle 11g R2, type the following additional commands:
NOTE:Starting with Oracle 11g R2,
flash_recovery_area is referred to as
fast_recovery_area.
The following directories are the default directories of the datafiles (*.dbf), control files (*.ctl), redo log files (*.log), archive log files (*.arc), and autobackup files (*.bkp):
$ORACLE_HOME/oradata/DB_NAME
$ORACLE_HOME/flash_recovery_area/DB_NAME
Restore the database to the
$ORACLE_HOME/oradata/DB_NAME directory.
NOTE:If the Oracle directories have been deleted or do not exist, create the directory structure before restoring the database.
Data is not available for the Topic
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please select whether the article was helpful or not.
Comments cannot contain these special characters: <>()\