To create a standby database when the copies and standby datafiles have the same names:
After connecting to the primary database, and if desired, the recovery catalog database, mount but do not open the primary database and ensure the database was closed cleanly before mounting. For example, enter:
RMAN> STARTUP MOUNT PFILE=init.ora;
Make sure that you set DB_FILE_NAME_CONVERT in the standby initialization parameter file so that standby datafile file names are translated from the primary datafile file names. For example:
DB_FILE_NAME_CONVERT = '/oracle/dbs', '/dsk2/oracle'
Copy all of the datafiles and the standby control file. For example, enter:
COPY
DATAFILE 1 TO '/dsk2/oracle/df_1.f',
DATAFILE 2 TO '/dsk2/oracle/df_2.f',
DATAFILE 3 TO '/dsk2/oracle/df_3.f',
DATAFILE 4 to '/dsk2/oracle/df_4.f',
DATAFILE 5 TO '/dsk2/oracle/df_5.f',
DATAFILE 6 TO '/dsk2/oracle/df_6.f',
DATAFILE 7 TO '/dsk2/oracle/df_7.f',
DATAFILE 8 to '/dsk2/oracle/df_8.f',
DATAFILE 9 TO '/dsk2/oracle/df_9.f',
DATAFILE 10 TO '/dsk2/oracle/df_10.f',
DATAFILE 11 TO '/dsk2/oracle/df_11.f',
DATAFILE 12 to '/dsk2/oracle/df_12.f',
CURRENT CONTROLFILE FOR STANDBY TO '/dsk2/oracle/cf.f';
Start the standby instance and mount the standby control file. For example, start SQL*Plus and enter:
SQL> STARTUP NOMOUNT PFILE=/dsk2/oracle/dbs/initSTANDBY1.ora
SQL> ALTER DATABASE MOUNT;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-626605/ ,如需转载,请注明出处,否则将追究法律责任。