3. Select the location for archive logs:
• If SPFILE is used:
Run:
alter system set log_archive_dest=path_to_archive_logs
SCOPE=SPFILE;
• If the init.ora file is used:
Run:
log_archive_start=true
log_archive_dest=path_to_archive_logs
The default path of the file is:
Windows:
ORACLE_HOME\database\initDB_NAME.ora
UNIX:
ORACLE_HOME/dbs/initDB_NAME.ora
where DB_NAME is the name of the Oracle database instance.
4. Mount the target database and to enable the archive log mode, start SQL*Plus
and type:
startup mount
alter database archivelog;
alter database open;
Example
If the user name for the target database is system, password manager,
instance name PROD, and the user name and password for the recovery
catalog is rman, then the commands will look like:
sqlplus /nolog
SQL> connect system/manager@PROD as sysdba;
Connected.
SQL> startup mount;
SQL> alter database archivelog;
Statement processed.
SQL> archive log start;
Statement processed.
SQL> alter database open;
5. Back up the entire database.
Backup set method
For backup set method:
Zero downtime backup integration guide 53
To Next Page
Loading...
Need help?
General