2. When the restore has been completed put the datafiles and tablespaces back
online with the following procedures:
Open a command line window and enter the following commands:
sqlplus /nolog
SQL>connect user/password@service as sysdba
If you are restoring a datafile enter:
SQL>alter database datafile 'datafile_name' online;
If you are restoring a tablespace enter:
SQL>alter tablespace tablespace_name online;
Duplicating an Oracle database
Perform a production database duplication to create:
• A standby database which has the same DBID as the production (primary)
database. With this, you can:
• Create a new standby database.
• Re-create a standby database after:
• Loss of entire standby database
• Primary database control file was restored or recreated
• Database point-in-time recovery was performed on the primary database
• Switchover or failover of database roles occurred
• An independent copy, with a unique DBID, which can be used for data mining
or testing purposes.
Prerequisites
• The whole primary database with the archived logs must be backed up.
• Archive logs, which have not been backed up to tape since the last full backup
and are required for duplication must be available on the duplicate system with
the same path names as on the target system (system with the production database
to be duplicated).
• Net service name for the auxiliary instance must be configured.
• When duplicating a database on the same system on which the target database
resides, set all *_PATH, *_DEST, DB_FILE_NAME_CONVERT, and
Zero downtime backup integration guide 115
To Next Page
Loading...
Need help?
General