RMAN - Different way to connect rman console
Scenario :
Here different way or example to connect rman console
- Example 1:
[oracle@srv6 ~]$ export ORACLE_SID=sourcegg1
oracle@srv6 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:35:37 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: SOURCEGG (DBID=358165956)
RMAN>
- Example 2:
[oracle@srv6 ~]$ export ORACLE_SID=sourcegg1
[oracle@srv6 ~]$ rman
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:36:06 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /
connected to target database: SOURCEGG (DBID=358165956)
RMAN>
- Example 3:
[oracle@srv6 ~]$ rman target sys@sourcegg1
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:36:42 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
target database Password:
connected to target database: SOURCEGG (DBID=358165956)
RMAN>
- Example 4 :
[oracle@srv6 ~]$ rman
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:36:56 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/system123@sourcegg1
connected to target database: SOURCEGG (DBID=358165956)
RMAN>
- Example 5:
[oracle@srv6 ~]$ rman
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:37:20 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys@sourcegg1
target database Password:
connected to target database: SOURCEGG (DBID=358165956)
RMAN>
SQL> alter system set control_file_record_keep_time=21 scope=both;
Automatic
RMAN> configure controlfile autobackup on;
backup current controlfile;
Manual
RMAN> backup tablespace user include current controlfile;
RMAN> configure controlfile autobackup on;
backup current controlfile;
backup as copy current controlfile format '/tmp/bkpcontrol.bkp';
No comments:
Post a Comment