Take backup of current CONTROLFILE :
SQL> select controlfile_type from v$database;
CONTROL
-------
CURRENT
SQL> ho rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jan 3 20:03:04 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB2 (DBID=1284867013)
RMAN> backup current controlfile;
Starting backup at 03-JAN-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 03-JAN-18
channel ORA_DISK_1: finished piece 1 at 03-JAN-18
piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_ncnnf_TAG20180103T200312_f4stfb19_.bkp tag=TAG20180103T200312 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-JAN-18
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
110 Full 9.45M DISK 00:00:01 03-JAN-18
BP Key: 110 Status: AVAILABLE Compressed: NO Tag: TAG20180103T200312
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2018_01_03/o1_mf_ncnnf_TAG20180103T200312_f4stfb19_.bkp
Control File Included: Ckp SCN: 1075139 Ckp time: 03-JAN-18
No comments:
Post a Comment