Oracle数据库热备份SQL脚本(for Linux)

Oracle数据库热备份脚本(for Linux)

Remark ----------------------------------------------------------------------------------
Remark filename:    user_online_backup_linux.sql
Remark description: User management online backup for linux (Linux下用户管理的在线备份)
Remark ----------------------------------------------------------------------------------

Prompt ****** Connect to database as sysdba
Remark connect / as sysdba;
Prompt sys/****** as sysdba;
connect sys/****** as sysdba;

archive log list;

Remark Set SQL*Plus variables to manipulate output
set termout on
set trimspool on
set echo off
set feedback off
set heading off
set verify off
set pagesize 0
set linesize 200
set serveroutput on

Remark set environment variable
Remark ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
Remark ORACLE_HOME==$ORACLE_BASE/product/11.2.0/dbh