Oracle 10G (Linux) Cold standby recovery

The complete database file set includes: database startup parameter file, control file, data file, log file.

The location and name of the file can be obtained in the following way.

parameter File
$ORACLE _home/dbs/spfile[$ORACLE _sid].ora

$ORACLE _home/dbs/init[$ORACLE _sid].ora

If the init[$ORACLE _sid].ora file does not exist, it can be copied from the $oracle_base/admin/[$ORACLE _sid]/pfile directory and renamed.

Control files
Sql> Show Parameter Control_files

Data files
Sql> select file_name from Dba_data_files;
Select file_name from Dba_temp_files;

Log file
Sql> Select member from V$logfile;

Restore Migration Steps

1. Close the source database.

   Sql>shutdown Immediate

2. Copy the data file set above.
3. Install the target database.
4. Copy the above data file set to the directory corresponding to the target database.
5. Create a password validation file.

   # CD $ORACLE _home/dbs# orapwd file=orapwd[$ORACLE _sid] Password=sys entries=10

6. Start the target database.

   sql> startup mount;sql> ALTER DATABASE open;

7. Verify the target database.

   Sql> select * from V$recover_file;

Oracle 10G (Linux) Cold standby recovery